I have imported an Excel spreadsheet where each row is one record. There is an ID number for the record, several fields with unique information and various states that may or may not have a numeric entry. I can extract the record and place specific parts in listboxes/or textboxes. My problem is trying figure how how to convert the states with numbers and instead of showing horizonial have them vertical so they fit into a subform, easier to see up and down not across. I can use the following query to extract all the states for that ID.
SELECT SLIC_Trips.ID, SLIC_Trips.[IN], SLIC_Trips.AL, SLIC_Trips.AR, SLIC_Trips.IA, SLIC_Trips.IL, SLIC_Trips.KY, SLIC_Trips.MI, SLIC_Trips.MN, SLIC_Trips.MO, SLIC_Trips.MS, SLIC_Trips.NC, SLIC_Trips.NY, SLIC_Trips.OH, SLIC_Trips.PA, SLIC_Trips.SC, SLIC_Trips.TN, SLIC_Trips.VA, SLIC_Trips.WI, SLIC_Trips.WV
FROM SLIC_Trips
WHERE (((SLIC_Trips.ID)=[Forms]![frmSLIC]![TxtRecID]));
It would make it much easier to read if only those states with a value would appear. Comfused?
SELECT SLIC_Trips.ID, SLIC_Trips.[IN], SLIC_Trips.AL, SLIC_Trips.AR, SLIC_Trips.IA, SLIC_Trips.IL, SLIC_Trips.KY, SLIC_Trips.MI, SLIC_Trips.MN, SLIC_Trips.MO, SLIC_Trips.MS, SLIC_Trips.NC, SLIC_Trips.NY, SLIC_Trips.OH, SLIC_Trips.PA, SLIC_Trips.SC, SLIC_Trips.TN, SLIC_Trips.VA, SLIC_Trips.WI, SLIC_Trips.WV
FROM SLIC_Trips
WHERE (((SLIC_Trips.ID)=[Forms]![frmSLIC]![TxtRecID]));
It would make it much easier to read if only those states with a value would appear. Comfused?
