Sorry for the second post, but (after creating 50 or 60 unmatched queries) I am still not able to get one right.... John Spencer has helped me with the...

I have a DB which has contact info stored in a One-to-Many table. The main Table has some additional contact info which I would like stored in the...

Hello, I am having an issue with an update query and using an IF statement in the "Update To" fields of that query. I have 2 tables in the query ("Actuals"...

I have part numbers & their operation numbers stored as text as follows: 103-8812-10 105-1235-R 6Y-5565-50 I’d like to separate the actual part number from...

Hello, how can I modify the code below to allow all the records to be displayed if the check mark is off? In other words, I have a table with records with...

I am working on a database with a structure similar to an order entry database. I need help writing a SQL statement analogous to one that will generate output...

Okay, I have a query that joins three tables. This query looks at several fields and adds them, simple enough but whenever I view the query it asks for the...

I have a form called frmPackage with a list box containing a query. I have part numbers (NPN) in a table called tblPackage that look like...

Hi, I could be appreciated if you could help me on this: I have create a query to append some fields onto a new table and create a new Index field...

I have tried several Data functions to determine how to count the total number of "Thursday's" in a given month. For instance: If I choose to find out how...

i have two tables i need to compare. One of them has over 300,000 lines of data. The first table that I need to use for the base has a column named OWNER and...

what is the function to countif in MS Access? To clarify I would like to count grades and break them out like 4 ..5's or 3 ...2's etc

I am trying to join 2 tables. I want to join if 'Field B' is in 'Field A'. ie. Field A = 'ABCDE' Field B= 'BC' ....the join would be successful cause 'BC' is...

Hi, Is it possible, do you think, to insert a combo box into the criteria section of a query? The user of the query will have a lot of units to choose from in...

Hi I am going to illustrate what i am trying to do in an example. I have the following results from a query: Payment# Account # Payment Date ...

It was easy in access 2003 Much obliged dennist

I have Employees Table with 9 employee record already in the table i want to insert a new Employee record in the table with INSERT INTO the primary key is...

I am having trouble in designing a query to prompt user input via wildcards. How do I go about making this happen. For example: I promt the user by asking ,...

Hi, I am new to forum posts, but have reached last resort, - have flat spot in my head from beating on brick wall! LOL. Need to build a query ( I think) ...

need help to get a cv template downloaded free?