[sukkarfarid]

How can I change the my query to crosstab query..
please see the picture..



I write this code... how can I change to a crosstab query

SELECT SeaTable.location, Count(SeaTable.location) AS CountOflocation
FROM SSFMainTable INNER JOIN SeaTable ON SSFMainTable.ID = SeaTable.MainTLink
WHERE (((SSFMainTable.AD) Between [enter1] And [enter]))
GROUP BY SeaTable.location
HAVING (((SeaTable.location) Like "G/A*" Or (SeaTable.location) Like "Qiz*"));

Thanks and regards
Farid

[ScottGem]

A crosstab query requires THREE columns in the source. One column for the Rows, one for the columns and one for calculation. So you have to add a column to your query. I would add a column like so:

Counts: " "

Use the Crosstab Wizard and make that column your ROW, make the Location column your Columns and then count the primary key field for your counts.