Concantenating Fields

[browninaz]

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...

 

[browninaz]

Thanks for your input Pat, but I can't figure out why I need to redesign my tables for the question at hand. I have one table that is strictly for floor prep, which includes everything from the floors, steps, patching, floating, etc., and one table for installation areas which includes the floors, steps, walls, or where ever you can install flooring (or tile, etc.). I tried to group different categories of the whole sales process while thinking of structure and design, but where I fell short is my lack of experience in querying a database, and well, lack of an education in this field (developing). If I may ask, how would you do it? I'll attach a copy of the structure that I have as of now, see what you think.