Report from Crosstab Query w/Date Range Parameters

[Mad Mister Mark]

Access newbie here in over my head!

Trying to generate a report for an employee's time sheet info from a crosstab query.

I've been reading in all sorts of forums, and I've gathered that I need to set the date range parameters in the original query on which the crosstab query was built.

I have done that using:
Between [StartDate] And [EndDate]
under a query field titled:
ACTIVITY DATE
in Design view.

I have additionally created:
StartDate
and
EndDate
with Data Type:
Date/Time

When I run the original query (billing_code_query), my parameter boxes pop up, I enter the info and everything works perfectly.

When I run the crosstab query (timesheet_query) based on the original query, the parameter boxes pop up twice. After experimenting, I found I can enter the date range in the first set of parameter pop-up boxes and click OK through the blank second set, and the query runs correctly.

When I generate the report built from the crosstab query, two sets of parameter boxes pop-up as with the crosstab query, but no matter what I enter the end result is an error box stating:
The Microsoft Office Access database engine does not recognize " as a valid field name or expression

Following online guides and tutorials I've tried creating forms to populate parameters, but I still get the same results.

I can't imagine this task is that esoteric. Everything else has been relatively simple to create. I'm really stuck, though.

Any help would be much appreciated!

 

[cpberg1]

Mark

If you're still working on this you may need to tell your cross tab queries to accept parameters.

Right click on the design view of the crosstab query and click parameters.

In the parameter field type the same thing you use in the criteria for the sort. Choose the approprite data type.

Best