Rich_Lovina
Registered User.
- Local time
- Tomorrow, 08:55
- Joined
- Feb 27, 2002
- Messages
- 224
I have a crosstab query based on a query. I click the show totals button on the wizard. It comes up with "You tried to execute a query that does not include the specified expression 'Surname' as part of an aggregate function.
The query shows titles by state, where the count is no of surnames, yet the design shows word Expression: Surname twice.
I can fix it and run it by changing expression to count and deleting the second option.
I only wish to know why the wizard plays up on this one.
The query shows titles by state, where the count is no of surnames, yet the design shows word Expression: Surname twice.
I can fix it and run it by changing expression to count and deleting the second option.
I only wish to know why the wizard plays up on this one.
