MarcieFess
Registered User.
- Local time
- Yesterday, 18:47
- Joined
- Oct 25, 2012
- Messages
- 107
I have a query, StoreAisleQuery. The query returns all products in each store with store name, aisle number, hazard class, volume of each product and other information.
I used this query to create a crosstab query that would total the volume of each hazard class in each store.
I see that it actually added 2 queries to my list of queries...it added 'StoreAisleQuery_Crosstab', and it added 'StoreAisleQuery_Crosstab Query'. Both return identical results
Is this normal behavior, or have I done something to create a second unnecessary query?
Second question...in order to run the query with fresh information I merely need to make it the record source of the report that uses it, right?
I used this query to create a crosstab query that would total the volume of each hazard class in each store.
I see that it actually added 2 queries to my list of queries...it added 'StoreAisleQuery_Crosstab', and it added 'StoreAisleQuery_Crosstab Query'. Both return identical results
Is this normal behavior, or have I done something to create a second unnecessary query?
Second question...in order to run the query with fresh information I merely need to make it the record source of the report that uses it, right?
