Search results for query: *

The query did what it was designed to do but I did not explain myself clearly enough early, what I am wanting to do with this query is to find out what items don't match based on a join of 4 column names. I tried using the Access Query Wizard for finding unmatched data but it only allows you to...

Howie Thanks a lot, I never thought about doing it with 4 joins in one query. I will give it a try this morning and let you know how I made out. bdavid50

Help I need to generate a query between two table, no one column is unique between the two tables. What is unique to both tables is the combination of 4 columns from each table. The query I need to generate is a difference query between the two tables using 4 columns from each table. How...

Thank both of you for your help. Alex, to answer a few of your questions. 1.) Yes, the text boxes are bound to the new table. I want to populate that table with the data from the list box and the data the user inputs. 2.) Yes, the enter key is being used to add the data from the text boxes...

I am stumped and need some help. I am only a moderately knowledgeable Access 97 user. I need to create a form (easy enough). In the form I need to collect data from ColumnA Table1, and display it in a List Box. Once the user picks an item form the list I want that pick to populate Field_1 on...

Thank you for your input, I agreed with Jerry and am in the process of reworking my form. I currently have no records and so rework is not that big of a chore.

Thank you for your input, I thought that, that was really the way to go about the whole issue. I am just an intermedite user with Access and was trying to make this work. I appreciate your input.

This may be difficult to explain or I may be approaching the whole issue wrong. I am developing a small database the has multiple numbers in a single field seperated by a comma. The field will be populated from a form. The following example demonstrates what the input data will look like...

This may be difficult to explain or I may be approaching the whole issue wrong. I am developing a small database the has multiple numbers in a single field seperated by a comma. The field will be populated as follows 25648, 28964-01, 89745, etc., not every entry has the same set of numbers or...