Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Hi : I am trying to write a quer
- Thread starter gys67
- Start date
Hello
Go into new query, select the table and put in the criteria box:
[Field1] & [Field2] & [Field3] & [Field4]
This will put all 4 fields in one record. If you want to put a space between them, use & " " & instead of the single ampersand.
John
Go into new query, select the table and put in the criteria box:
[Field1] & [Field2] & [Field3] & [Field4]
This will put all 4 fields in one record. If you want to put a space between them, use & " " & instead of the single ampersand.
John
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question