• Re: Blank Fields in query (Access 97,Access 2000)

    Author
    Reply
    • #673337

      What happens if you rerun the query, do you see all the times? It is not clear how you are using the query. If you have values in MilesTo, then you should get values in the calculated field unless something else is going on. It seems like a silly suggestion, but have you tried moving the TimeTo column to the right of MilesTo?