- Joined
- Apr 2, 2012
- Messages
- 2
- Reaction score
- 0
I have a query that find information from two tables and has the fields below [ to limit confusion there is some sample data too]
LN FN SCode RCode Date
Smith Mike AAA Car 2/2/2010
Smith Mike AAA Car 2/4/2009
Smith Mike SA Car 2/3/2009
Smith Mike AAA Car 2/8/2011
Smith Mike RE Car 2/3/2008
Michaels Jack RE Car 2/2/2011
etc...
From the Above i am looking for a query to give me results as the following, but i can't seem to figure it out:
Smith Mike AAA Car 3
SA Car 1
RE Car 1
Michaels Jack RE Car 1
A query something like that. I know i can use a report to get the formatting like i have shown, but i can't seem to figure out how to get the total counted data like i want.
Any Help
LN FN SCode RCode Date
Smith Mike AAA Car 2/2/2010
Smith Mike AAA Car 2/4/2009
Smith Mike SA Car 2/3/2009
Smith Mike AAA Car 2/8/2011
Smith Mike RE Car 2/3/2008
Michaels Jack RE Car 2/2/2011
etc...
From the Above i am looking for a query to give me results as the following, but i can't seem to figure it out:
Smith Mike AAA Car 3
SA Car 1
RE Car 1
Michaels Jack RE Car 1
A query something like that. I know i can use a report to get the formatting like i have shown, but i can't seem to figure out how to get the total counted data like i want.
Any Help