Simple query using dates

  • Thread starter Thread starter Mindy Sterling
  • Start date Start date
M

Mindy Sterling

I just want to make a query that will spit out all of the scheduled classes
between 2 dates. How do I do that? I've looked in help and can't get it
exactly right.

I want the receptionist to be able to pull up the query, put in 2 different
dates and have it spit out the results to a form. Any help woule be great!!

Thanks,

Mindy
 
I want the receptionist to be able to pull up the query, put in 2 different
dates and have it spit out the results to a form. Any help woule be
Click to expand...
great!!

Shoot... don't want to spit to a form but rather a report....sorry!


Mindy
 
You should create a parameter query in the date column
using:
Between [Enter start date:] And [Enter end date:]
in the criteria field. Then create a report referring to
this data.
Check help file for a description of parameter queries to
explain how this works.

I hope this helps,
Mark.
 
That's the one I tried but I never could get the syntax right...
Let me give it another go...

Thanks,

Mindy


Mark said:
You should create a parameter query in the date column
using:
Between [Enter start date:] And [Enter end date:]
in the criteria field. Then create a report referring to
this data.
Check help file for a description of parameter queries to
explain how this works.

I hope this helps,
Mark.
-----Original Message-----

query, put in 2
different help woule be
great!!

Shoot... don't want to spit to a form but rather a report....sorry!


Mindy



.
Click to expand...
Click to expand...
 
Yep...that did it....
I had it in the FIELD instead of CRITERIA....I tried it in the CRITERIA but
it didn't work so I must have had it all wrong on the Syntax but I *was*
using the Between/And expression.

Loads of thanks~

Mindy

Mark said:
You should create a parameter query in the date column
using:
Between [Enter start date:] And [Enter end date:]
in the criteria field. Then create a report referring to
this data.
Check help file for a description of parameter queries to
explain how this works.

I hope this helps,
Mark.
-----Original Message-----

query, put in 2
different help woule be
great!!

Shoot... don't want to spit to a form but rather a report....sorry!


Mindy



.
Click to expand...
Click to expand...
 
Back
Top