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:
in Design view.
I have additionally created:
with Data Type:
When I run the original query (billing_code_query), my parameter boxes pop up, I enter the info and everything works
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,
Any help would be much appreciated!