wh00t
Registered User.
- Local time
- Today, 04:29
- Joined
- May 18, 2001
- Messages
- 264
I've been working on a crosstab query to display data on a form to improve the current method of having 118 DLookups in the form, I have part of what I want but not all and I can't seem to find a way to do it. The form is a reference form and is displayed in a graphical way and needs to be displayed in a certain way.
The following data is stored
Bay - Trailer - Status
what I need is to display the Bay as colum headings and have the trailer and status as values. I can have both if I merge the 2 in the value but this is not useful for the form for conditional formatting as the values are completely random. Is there a way where I can have 2 values for 1 colum heading?
The following data is stored
Bay - Trailer - Status
what I need is to display the Bay as colum headings and have the trailer and status as values. I can have both if I merge the 2 in the value but this is not useful for the form for conditional formatting as the values are completely random. Is there a way where I can have 2 values for 1 colum heading?
