Report built on a Crosstab Query (Access 2003)

[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

 

[Duane Hookom]

IMO, parameter prompts are never acceptable
http://www.tek-tips.com/faqs.cfm?fid=6763.

I noticed you haven't entered the unique values of [Mail Type] into the
column headings property. Your report might be more efficient if you included
them.