Date criteria

  • Thread starter Thread starter DBAmat
  • Start date Start date
D

DBAmat

I have 2 tables 1 of the fields in one table is comments but is not in
the other i am running a query to match users from ID Name etc but not
comments the comments field has dates in it i want to show the results
but only before the date of september 06?

Anyone help please ASAP
 
Ive tried it on one query (Matches) but on the other(Miss-Matches) it
doesnt work ive set the join properties to option 2 on miss matches it
works on matches could you help Please?
 
Back
Top