browninaz
Ugly Data Hoarder
- Local time
- Today, 04:52
- Joined
- Oct 26, 2012
- Messages
- 88
Hello all,
This has been a struggle for me to try and figure out for awhile. I have a query that pulls data from the following fields in 2 different tables:
Area1FloorPrep (tblFloorPrep) ex. remove ceramic tile
Area1Size (tblInstallationAreas) ex. 20 s/f, or just 20
Area2FloorPrep (tblFloorPrep)
Area2Size (tblInstallationAreas)....
All the way to Area20 (Floorprep and InstallationAreas) for both tables. I have created an installer invoicing form that pulls the data from the workorder that these fields are located in, but the problem I'm having is that I don't know what kind of query to create to concantenate the data in the 20 fields and concantenate the size of the areas next to the appropriate concantenated floor prep description. Is there a way to do this without coding?
Hopefully someone understands what I'm saying. If not, whats the right way to ask?
Thanks to all who will help this poor novice...
This has been a struggle for me to try and figure out for awhile. I have a query that pulls data from the following fields in 2 different tables:
Area1FloorPrep (tblFloorPrep) ex. remove ceramic tile
Area1Size (tblInstallationAreas) ex. 20 s/f, or just 20
Area2FloorPrep (tblFloorPrep)
Area2Size (tblInstallationAreas)....
All the way to Area20 (Floorprep and InstallationAreas) for both tables. I have created an installer invoicing form that pulls the data from the workorder that these fields are located in, but the problem I'm having is that I don't know what kind of query to create to concantenate the data in the 20 fields and concantenate the size of the areas next to the appropriate concantenated floor prep description. Is there a way to do this without coding?
Hopefully someone understands what I'm saying. If not, whats the right way to ask?
Thanks to all who will help this poor novice...