How do I produce a report from tables in my database within a specific time frame

[paul]

Hi

I am very new to this and hope you bear with me!

I want to pull specific data from 3 tables into one report using a date
range.

I have 3 main tables and matching forms to enter the data which are,
time records, disbursements, and mileage.

Each record entered has a job code. I have created a table with a list
of job codes so that only valid codes can be entered onto the forms.
Each record also identifies the date the work was carried out.

I want to produce a report from these tables showing just the records
the job no relates to and all the fields associated with it within a
specific time frame i.e from 01/01/06 to 30/06/06.

Can anyone help?

 

[Larry Daugherty]

There is a more elegant way than the one I'll suggest below but once
you understand the suggestions below, replace the prompts in the
criteria lines of the QBE grid with references to a Launcher form with
the information already in the controls on the form.

in the criteria line for the:

date field: Between [Enter beginning date] and [Enter ending date]

Job code field: [Enter job code]

HTH

 

[Paul]

Ok, now I only have to figure out how to get there!