Shot List Report

[conehead]

I am making a database for a shot list and equiptment log for a movie my production company is making. I have a database for the shots including location description and other needed info. and i have a database for equiptment needed which includes the name and the location it is needed for... i am looking to make printable reports that say only one of the locations, the description of that locations, etc. and then the equiptment needed just for that location... is this possible because all i end up with is a list of all of the locations and all of the descriptions and all of the equiptment for everywhere.

thank you very much for any help given,
Conehead

 

[statsman]

I assume you have a table that is the source for your shot locations. In this table there should be a field that refers to the location (either a number or the name of the location).
Create a query that includes all of the fields you will need on your report.
In the criteria of the query for the location field type [Enter Location] (square brackets required).
When you run the query, it will prompt you to enter the location info. The query should only return data for that location.
Create your report using the query rather than the table.
When you run the report the query will again prompt you for the location info and you should only have a print out of the data for that location.

 

[conehead]

thank you that did work... but i would need to make a query for every location is there a way to make a seperate report for all the locations automatically?

Thank you,
Conehead

 

[ThreeCrow]

Going with statsman directions you only need the Report underlying Query.

 

[conehead]

Thank you very much