Hi,

I have 3 tables from which I need to access this information. Tables are: HARDWARE & EQUIPMENT_INFO & LEGER:

Hardware Fields are:

Serial No
Equip_Code
SchoolID
Schooltype
Make
Model

Equipment_Info Fields are:

Equip_Name
Equip_Code

LEGER Fields are:

File No
Serial no
Supplier
Value

The user will have a listbox that displays the Equip_name.On clicking the selection I need to make a connection query on the Access Database.


I need to
SELECT * FROM HARDWARE WHERE SCHOOLTYPE = P AND WHERE LISTBOX1.selection = ((INNER join HARDWARE AND EQUIP_INFO WHERE Serial No: S.No) and (INNER join LEGER AND EQUIPMENT_INFO WHERE Inventory_no = Equip_Code))

Never done a detailed query. Can someone tell me If I have the right code for the query. Thanks for your help