I have a query that returns data with the following elements
id, name, address, svc date, svc_typ,svcdesc
Sample data:
What I'm getting:
3 records
1, bud grant, 123 someplace, Minneapolis,MN, 1/1/2010,3245,service 1
1, bud grant, 123 someplace, Minneapolis,MN,1/30/2010,3245, service 1
1, bud grant, 123 someplace, minneapolis,MN,3/4/2010, 3246,service 2
What I need is 1 record
1, bud grant, 123 someplace, minneapolis,MN,1/1/2010,3245,service 1,1/30/2010,3245,service 1,3/4/2010,3246,service 2
a crosstab doesn't work for the following reasons
1. Sample only shows 1 member the actual results will be around 100
2. Members can have 3+ services
3. There is no value to calculate the 3 elements are fields
This is a 1 time requirement and needs to be complete today. So coding in VBA isn't productive. Is there any way to do this in a query? Any ideas anybody???
id, name, address, svc date, svc_typ,svcdesc
Sample data:
What I'm getting:
3 records
1, bud grant, 123 someplace, Minneapolis,MN, 1/1/2010,3245,service 1
1, bud grant, 123 someplace, Minneapolis,MN,1/30/2010,3245, service 1
1, bud grant, 123 someplace, minneapolis,MN,3/4/2010, 3246,service 2
What I need is 1 record
1, bud grant, 123 someplace, minneapolis,MN,1/1/2010,3245,service 1,1/30/2010,3245,service 1,3/4/2010,3246,service 2
a crosstab doesn't work for the following reasons
1. Sample only shows 1 member the actual results will be around 100
2. Members can have 3+ services
3. There is no value to calculate the 3 elements are fields
This is a 1 time requirement and needs to be complete today. So coding in VBA isn't productive. Is there any way to do this in a query? Any ideas anybody???
