I have 10 querys, that get the same data from 10 fifferent tables.
I created a template report to edit the data from the first query.
My question: How can I tell Access to get that other queries in the same report format.
Can you please explain in more detailing.
I have the template report called "Faults_43_R".
It isn't binded to any query.
How can I build the code to chose the query and obtain the report automatically.
Only explain by headlines.
Hi my friend,
I have the follwong table.
Date / time Counter1 Counter2
the table holds counters according a date and time
20/11/04 6:00 am 10 15
20/11/04 15:00 pm 20 30
20/11/04 11:00 pm 70 50
I want the query to calculate the difference between the counters according to shifte. You noticed that the times in wach day are the shifts (morning,afternoon and evening).
So, The result of the query of the a bove example is:
In 20/11/04 :
From 6:00 to 15:00 10 (20-10) 15 (30-15)
From 15:00 to 11:00 50 (70-20) 20 (50-30)