MS Access: Crosstab Query and Report
Posted on 2013-01-30
I have a crosstab query in MS Access that is used to display a list of the company's assets that we have on hand along with their respective age groups. Please see below:
Country (Row Heading)
Location (Row Heading)
Asset Number (Row Heading)
Age Group (Column Heading)
Now I have added [Country Name:] as a criteria under the Country column (in the query) and also added it to the Parameters window with a Text datatype.
It works well!
However, now that I am designing the report, I am running into problems.
I added the name of the query (qryAssetList) to the recordsource of the report but when I click on Add Existing Fields, I get the following message:
"No fields available to be added to the current view.
The current recordsource may be invalid (for example, it may contain an invalid join expression), or there was some other problem gathering recordsource information for this object)"
Does anyone have any idea what this means and how it can be fixed?