how do I have Access display the same data for each day between a.

[Guest]

I am working on a simple database for a school. Basically, I need a tool for
the teachers to check out a certain number of books for their class and a way
to track how many books are available for each day. I am able to calculate
how many books are available for the check out and check in date but can't
figure out how to display the same data for in between the two dates....plz
help.

 

[vseale]

If I understand correctly, you want a count of available
books at the time the query is run. If that's what you
need, create a query (assuming check out and check in are
two different fields) with the check out criteria - Is
Null (no quotes), click on the sum icon in the toolbar and
count the check in field

 

[John Vinson]

I am working on a simple database for a school. Basically, I need a tool for
the teachers to check out a certain number of books for their class and a way
to track how many books are available for each day. I am able to calculate
how many books are available for the check out and check in date but can't
figure out how to display the same data for in between the two dates....plz
help.

Without some idea of how your tables are structured, it's very hard to
guess how you might do this.

The only hint I can offer is that you can use a criterion on a Date
field of

BETWEEN [Enter start date:] AND [Enter end date:]

to return records where the date field is between those dates
(inclusive).

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps