Search results

I have 2 tables: PARTS and INVLOC. PARTS contains 15,413 records When I run the following query, I am only getting 12,889 records returned: SELECT PARTS.*, INVLOC.qty_on_hand FROM PARTS LEFT JOIN INVLOC ON PARTS.part_num = INVLOC.item_no WHERE INVLOC.loc = 'EX' ORDER BY PARTS.ID;I am missing...

I have run into a frustrating problem I can't make any sense of. I have a query that joins 3 tables. It works fine when the first table is an Access table, but throws an error message when I change the first table to a linked table (SQL Server). The second two tables are always linked tables and...

Ok this is a long table design question I have been having trouble wrapping my head around. I have a database my company uses to keep track of equipment that we repair. Currently we have a table 'repairs', with fields like: ID, customer, equip_type, serial_num, date_received...

Hello. I am not sure exactly how to word this problem. Hopefully someone understands what I am trying to do here. I have a simple form with a text box, I enter a series of part numbers separated by newlines, and then I use the following code to query for each of the separate part numbers: Dim...

Assigning Primary Key Value Hello. I had already posted this in the General forum but then I found this one and I think this might be the proper place for my question. I have an access form which includes my primary key field "ID". Normally when I use this form to enter a new record this field...

Hello All. First time poster - I hope I am posting this in the right forum. I have an access form which includes my primary key field "ID". Normally when I use this form to enter a new record this field displays "(New)" until I enter data in any other field, then the ID field updates to...