Recent content by Nuclear P0wers

Union Query worked guys. Thanks for your help!

Awesome. I'll try this out and let you know if this works. Thanks!

Let's say that I have two different columns (fields) in a set of records. I need to combine the values listed in those two fields into one field for use in a drop down menu. Is there a way to do that? The two different fields in question have different names.

I understand your concern, but i have simplified the data entry for ease of explanation. The two Section tables will have different data in them. I guess my overarching question is this: Can I create a query that only produces one field with records that contain field entries from 2 different...

Attached

I currently have 3 different tables: B Section C Section D Section I want to figure out the SQL or Query required to have access look at the Table "C Section", find items in that table with the same number in a given field; look at the table "D Section" and list all items that have the same...