L
Legacy 3234
Guest
I've got a select query to create a report of everything a particular user entered on a particular day.
The date going into the report is automatically generated from an entry form using =now() as the default value and it's bound to the EntryDate field of a table.
In the form, table and query I've got it formatted as "short date". But sometimes when I look at my table after making test entries, the first entry will be in long date/time format.
Problem is, when I run the query it's not returning all the records even though all the dates look the same in my table. I think it has something to do with that first entry but I don't know what to do to fix it. Sometimes the first entry looks fine.
Can anyone suggest a way to make this work? This is the first select query I've done.
The date going into the report is automatically generated from an entry form using =now() as the default value and it's bound to the EntryDate field of a table.
In the form, table and query I've got it formatted as "short date". But sometimes when I look at my table after making test entries, the first entry will be in long date/time format.
Problem is, when I run the query it's not returning all the records even though all the dates look the same in my table. I think it has something to do with that first entry but I don't know what to do to fix it. Sometimes the first entry looks fine.
Can anyone suggest a way to make this work? This is the first select query I've done.