Count in Query

  • Thread starter Thread starter Barry
  • Start date Start date
B

Barry

I have a table with a number of columns, two of them being SaleDate, and
Premium.

I want a query that will give me a count of all the premiums, as well as the
count of the various premiums about 4 different rates, grouped by date. I
tried a crosstab query which worked but i am unable to use parameters with
the query - I keep getting - The Microsoft Jet database engine does not
recognize <name> as a valid field name or expression.


I want it to look something like this:

Date Total $60 $70 $80 $90
2003/11/05 10 5 5
2003/11/06 12 3 4 3 2

Thanks in advance

Barry
 
I tried a crosstab query which worked but i am unable to use parameters with
the query - I keep getting - The Microsoft Jet database engine does not
recognize <name> as a valid field name or expression.
Click to expand...

This is a quirk of crosstab queries. You're always *allowed* to
specify a query's parameters in its Parameters collection; for a
crosstab you are *required* to do so.

Open the query in design view, right mouseclick in the grey background
of the tables, and select Parameters. Put the *exact* parameter in the
left column and specify its datatype in the right.
 
Back
Top