Easy Question, Please Help ASAP :/

T

tt_Gyrl

Hi-
I juSt learned Access and I'm having trouble with operators.

I need to run a query using specific date ranges. EX: 7/1/2005 - 8/20/2007.

For my next column I need:

I also need to run a query using containing all the data that has the words
"Pass" and "In Progress".

Can someone please assist me with the correct formula? I need this within
the next 15 mins. Thanks soo much.
 
C

cjonesjr

Hi-
I juSt learned Access and I'm having trouble with operators.

I need to run a query using specific date ranges. EX: 7/1/2005 - 8/20/2007.

For my next column I need:

I also need to run a query using containing all the data that has the words
"Pass" and "In Progress".

Can someone please assist me with the correct formula? I need this within
the next 15 mins. Thanks soo much.
Click to expand...

Sorry I couldn't help you in the time you wanted.
The next time you need to do this, here's what you do

Open the query in design view
In the Criteria row in the field that has your dates, enter this:
Between[Enter First Date] and [Enter Second Date]
Save the query.
Now, when you run the query, you'll get a dialog box that says Enter
First Date. Be sure to enter it in the same format as the field.
Click Ok and you'll get another dialog box that says Enter Second
Date.
When you enter the two dates, you'll see the records between the two
dates.

You can use the same method for your second part of the question.

What I would do is to enter those words in the criteria portion of the
fields. Save the query and every time you run it, it will look for
those specific words.

To use And in the criteria row, you can enter it in one row as Pass
and In Progress

Hope this helps

CEJJ
 
Top