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 Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Recent content by smokyjoker
-
Concatening fields
Thanks very much to both of you. I tried putting it on the row source of a combo box and it tells me that it doesn't exist. Also, why does the "Trim" not go on the first field also?- smokyjoker
- Post #11
- Forum: Microsoft: Access Forms
-
Concatening fields
Sorry scriverb--I'll start from the beginning. I have thirteen tables that are lookup tables for a master table. Each table represents options for a position in a part number. Each table has three columns: tablenameID, Value, and Description. The 'tablenameID' is an autonumber field and the...- smokyjoker
- Post #8
- Forum: Microsoft: Access Forms
-
Concatening fields
I have a slightly more complex concatenated query that I need to put together. The above example has put me on the right track, but I have several fields that I need to specify criteria for. Here's my code based on your example: =(SELECT [LitGroup], [LitGroupType], [LitGroupSubType]...- smokyjoker
- Post #5
- Forum: Microsoft: Access Forms
-
Getting alternate row data based on autonumber ID
Hello-- I have a four tables called LitGroup, LitGroupType, LitGroupSubType, and LitGroupStyle. I have all four tables set up as a series of one-to-many relationships (There are many LitGroupType values for one LitGroup row, and so on. I have a combo box in a form bound to a unique ID to limit...- smokyjoker
- Thread
- Replies: 0
- Forum: Microsoft: Access Forms
