Returning text totals..

[Ben6550]

I want to run a query which extracts data from a table and returns a total, the data is text form and i seem to be unable to get a total for the extracted records. Any ideas?

 

[SteveR77]

Ben,


Can you provide a sample of your data and what you wish the desired output to be?


Thanks,


Steve

 

[Ben6550]

This is the query using the wizard produced, but i recieve is an error message saying query is too complex to be evaluated:

SELECT interview.Position
FROM interview
GROUP BY interview.Position
HAVING (((Count(interview.[Interview Date])) Between [Start Date] And [finish Date]) AND ((interview.Position)="homephone&quot);

Think it's because of the criteria. Is there a solution to getting the totals?

 

[SteveR77]

Ben,

Try doing your count on the homephone field.
The value should be the same as counting the date field but will hopefully reduce the amount of complexity in the query.


The only other way would be to build one query that has the results which are passed to a second query that does the grouping and count.


Steve