Quick Query Question (Three Q's) :o)

[James Pond]

Hello all,

Its my first post here and I am asking for help )

I am new to Access and am struggling on trying to find information for the following:

I need to find items from 01/04/99 to 26/04/99

I have the qeury all set up but it turns up a blank.

Any response would be great!

Many thanks!

George

 

[racemadnss]

In Query Design mode add this criteria under your Date Field

Between 04/01/99 AND 26/01/99

I noticed that you have your date setup like this

DD/MM/YY

I Have my dates set up MM/DD/YYYY

Make sure you search in the format of the dates in your table