Queries

[JimSmitty]

I want to create a query:<br><br>I have reports that have information such as enrollment dates, ages, etc. If i want to print out a report that is based on the fact that they all enrolled in June of 2000, how do i do that?<br><br> <p>Jim Smitty<br><a href=mailto:jimschmitty@hotmail.com>jimschmitty@hotmail.com</a><br><a href= > </a><br>

 

[samara]

so in your query design view, type in the criteria of your date field, <br><br>BETWEEN #1/7/2000# AND #31/7/2000#<br><br>or by SQL code...<br><br>SELECT * FROM YourTable<br>WHERE date BETWEEN #1/7/2000# AND #31/7/2000#<br><br>Hope this would help YOU... <p>Mohamed Aly<br><a href=mailto:samara_79@hotmail.com>samara_79@hotmail.com</a><br><a href= > </a><br>

 

[JimSmitty]

I understand what you mean by this, but what i want to do is from my switchboard, allow users of my database to pick out the criteria they want and print out a report... are there ways to do this? <p>Jim Smitty<br><a href=mailto:jimschmitty@hotmail.com>jimschmitty@hotmail.com</a><br><a href= > </a><br>

 

[samara]

Yes, you can create a form with many combo boxes (each combo for one field of your report) and let the user to select their criteria and hit a &quot;RUN&quot; button to view the filtered report.<br><br>i hope that will work for YOU... <p>Mohamed Aly<br><a href=mailto:samara_79@hotmail.com>samara_79@hotmail.com</a><br><a href= > </a><br>

 

[JimSmitty]

Well,<br>&nbsp;I really have no idea how to get started on the query considering my tables and reports are so big and filled wit so much data... can you do maybe step by step in a way for me? Thanks<br><br>Jim <p>Jim Smitty<br><a href=mailto:jimschmitty@hotmail.com>jimschmitty@hotmail.com</a><br><a href= > </a><br>

 

[Guest_imported]

The easiest way to do this is, <br><br>In your query table, in the date field, in CRITERIA type this.<br><br>Between [Enter Start Date] And [Enter End Date]<br><br><br>When you click on the query, or the report using this query, you will get prompted to enter the dates that will be used as the period your looking for.