H
hughess7
Hi, I have a crosstab query which produces data like example below. I have a
few queries though:
1. If the activity is not an audit it produces the text ' days' still and I
don't want it to show this. Tried an IIf statement but resulted in an
aggregate function error?
2. When I produced a report based on the crosstab query it didn't show the
dealer code and no of days, only the activity. Can it not be displayed on a
report ?
3. Would like details to be shown again on next days where longer than 1
day, I have posted this question already but no replies as yet... I guess
this isn't an easy one to solve and I don't have a clue where to start with
it!
Specialist 02/05/2005 03/05/2005 04/05/2005 05/05/2005
Fred Audit
04907
ANGERS
3 Days
Declan Bank Holiday Audit
Days 12345
Suffolk
4 Days
Thanks in advance for any help.
Sue
few queries though:
1. If the activity is not an audit it produces the text ' days' still and I
don't want it to show this. Tried an IIf statement but resulted in an
aggregate function error?
2. When I produced a report based on the crosstab query it didn't show the
dealer code and no of days, only the activity. Can it not be displayed on a
report ?
3. Would like details to be shown again on next days where longer than 1
day, I have posted this question already but no replies as yet... I guess
this isn't an easy one to solve and I don't have a clue where to start with
it!
Specialist 02/05/2005 03/05/2005 04/05/2005 05/05/2005
Fred Audit
04907
ANGERS
3 Days
Declan Bank Holiday Audit
Days 12345
Suffolk
4 Days
Thanks in advance for any help.
Sue