Report built on a Crosstab Query (Access 2003)

  • Thread starter Thread starter Dave K.
  • Start date Start date
D

Dave K.

I built a report from a crosstab query that every time I open the report it
prompts me to enter the query values twice.

the query has the following SQL statements to prompt the use to enter the
beginning date and ending date and then veiw the records.
PARAMETERS [Enter Ending Date] DateTime, [Enter Beginning Date] DateTime;
TRANSFORM Sum(Qry220MachineReadings.[Meter Reading]) AS [SumOfMeter Reading]
SELECT Qry220MachineReadings.Date, Sum(Qry220MachineReadings.[Meter
Reading]) AS [Total Of Meter Reading]
FROM Qry220MachineReadings
WHERE (((Qry220MachineReadings.Date)=[Enter Ending Date] Or
(Qry220MachineReadings.Date)=[Enter Beginning Date]))
GROUP BY Qry220MachineReadings.Date
ORDER BY Qry220MachineReadings.Date DESC
PIVOT Qry220MachineReadings.[Mail Type];

What I have is database that you can enter mulitable meter readings for
several different types of machines.

I want to find the total of each meter readings between two different dates.

Ex:
Meter A Meter B

machine 1
10-29-08 100 500
10-31-08 600 1500

total 500 1000 for period between 10/29 and 10/31
 
Back
Top