Formating, Sorting and setting parameters for Date Column

  • Thread starter Thread starter Thorson
  • Start date Start date
T

Thorson

in one of my queries I have a date column: CalfBirthDate. It pulls up the
date correctly in the query, however when I try to sort the column it sorts
it by month and then day and then year instead of by the actual date, so it
is sorting it more like a number than a date.

I also would like to limit it to the dates on or before an entered date,
when I enter this in the criteria field it doesn't return the correct
results. The parameter is entered into a form not the actual query I entered
in the following into the criteria section:
<=[Forms]![frmCurrentInventoryDateQuery]![txtDate]

I'm assuming that one thing is causing both problems, any suggestions? Is
my formatting of the fields messed up?

Thank you.
 
Never mind, I solved the problem. I have 3 tables that create a union query
which is linked to this query, two of those tables had the incorrect format
for the date field. All is solved now.
 
Back
Top