Help needed PLEASE

[spiderwebb1960]

I have been making modifications to a database for a client. Now ever time I try to view a report I get the following error message - The specified field '[Stock out]' could refer to more than one taqble listed in the FROM clause of your SQL Statement- Please could someone tell me where to start looking to debug this, all the rest of the database works fine just these reports.

Spiderwebb1960

 

[mrharvey]

Hey Spider:

Access is just trying to tell you that the field [Stock Out] exists in more than one table in the SQL join. All you should need to do is to qualify it by referencing the appropriate table. For example: tblInventory.[Stock Out].

Michael

 

[spiderwebb1960]

Thanks Michael will try and see how far I get

Spider