Get Rid of Duplicate

[Ukraine82]

I have a query that I would like to put in a report. Before I do that I have an expression that runs stolen car make and car model. How do I get rid of duplicate and put car make field and car model field together?

I attached a sample database. If you run the query you will notice I have lots of duplicate, but I want to put them all in One with a total theft.

Thanks,

Michael

 

[M8KWR]

i have attached what i believe you require, I have had to use two queries though.

Unsure how to condense it to just 1. I have not had that much time to look at it though.

If there is anything else please ask. Are you going to do a front screen to enter your date range???

 

[M8KWR]

I have done it in one query,

Paste this into the query, in sql mode

TRANSFORM Count([General Table].[CLAIM#]) AS [The Value]
SELECT [Car Make] & [Car Model] AS Car, Count([General Table].[CLAIM#]) AS [Total Of CLAIM#]
FROM [General Table]
WHERE ((([General Table].DOL) Between #1/1/2004# And #10/31/2004#))
GROUP BY [Car Make] & [Car Model]
PIVOT Format([DOL],"mmm") In ("Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec");


Hope this helps...

 

[M8KWR]

i forgot to have an email noticification just in case you needed extra assistance, ignore this message

 

[Ukraine82]

Thanks alot man. The whole time my claim rep field was causing duplicate. I knew I was on the right track.

Thanks again,

Michael