In need of some assistance with my queries and spaces within the cell of the column

[eyperry]

Hello,



I would like to know is it possible to join 4 queries into one. Now each query right now is related to a table. I want to keep the table that is connected to each query and yes its the same table in each query that is connected. How can I combine all 4 queries into one query.

Also I have a few columns how can I remove the additional spaces within the cells in the column. For instance, it looks like this 72 77--- I want it to look like this 7277. ( No spaces)

Also I am not the best with SQL as of yet so I do a lot in the design view tab

Thank you Access Forums

[nrgins]

Just create a new query and add your table and your four queries to it, and join the table to each query individually on the primary key of the table, being sure to use an outer join (all records from table and only matching records from query).

To get rid of spaces, use the Replace function:

Replace([Field Name], " ", "")