Capturing Date from 2 different fields in report

[angrin]

Hi there,
I have a calendar that is based on our work scheduled. Sometimes our tech does work on different days than our builders.
For each calendar date, I want the report to capture TECH DATE work hour sums and BUILD DATE work hour sums.

Right now the groups on the report are based on BUILD DATE, so the TELECOM hrs do not add up properly if it was scheduled on a different date.

Is there a way provide summary report based on the general date, selecting both TECH and BUILD date fields at the same time?

Thank you in advance for any help you may be able to provide me!

-Angela

 

[randysmid]

Hi,
You may want to use a "make-table" query. By doing this, you can combine two or more queries together to get the data you are interested in. Your first query will create the work table (often called temporary). Then, the 2nd query will be an append query. The resulting table will be used as a recordsource for the report. Make sense?

HTH,
Randy Smith
California Teachers Association