Ok this ones gonna be fun I think. I'm trying to figure out how to put data in a field based on it's value...
Used Breaker | Phase | Grid | Plug Type | SW | Description | Description | SW | Plug Type | Grid | Phase | Used Breaker
That's the header across the top... now I know I can filter each record based on the ID of the SW... Each SW will have it's own ID I can pull from and will always contain a value of 1 - 42.
What I'm trying to achieve is something like this...
Used Breaker | Phase | Grid | Plug Type | SW | Description | Description | SW | Plug Type | Grid | Phase | Used Breaker
--------------Data From SW ID where Value = 1 -------------|--------------Data From SW ID where Value = 2 -------------
--------------Data From SW ID where Value = 3 -------------|--------------Data From SW ID where Value = 4 -------------
Etc etc? Does that make sense? I think I can do this if I make a Form with this stuff then a query off that form but I was hoping to just do the filtering on the Report itself. Is this possible or do I need to make another form and query?
Thanks all.