Help with query in this database

[nickmaxwell]

Hi



I am trying to create a query in the attached database that will allow me to find all open cases for a contractor ("Assigned to in the issues") and another query which will allow me to find all closed cases for a contractor. And then print this form off.

But for the life of me I cannot get the query to work. Querying on the status is fine but the query on the contractor, just will not work. I am assumming it is because in the Issues table the contractor is a lookup from the contactors table....

If you could help out it would very much help my melted head.

Nick

[alansidman]

Suggest you convert your db to an version that is 2003 or earlier so more people can access it. AC 2010 is not viewable by users of earlier versions.

Alan

[nickmaxwell]

Unfortunately I cant - I must be using features specific to 2010 as it doesnt give me the option to save as any other version.

[alansidman]

In that case, suggest you post your SQL statements for your queries. Indicate what you expect for results and what you are getting for results.

[RayMilhon]

You need to go back and redesign your DB. I recommend using a naming convention such as all table names start with tbl, query names start with qry, forms frm.... You have tables and forms with the same names queries and reports. You have a table for contractors but then store the name in the issues table rather than a foreign key to the contractors table. Do some reading on Normalization, Primary and Foreign Keys.

[alansidman]

Based upon Ray's comment as I haven't seen your db, look here.

http://www.deeptraining.com/litwin/d...aseDesign.aspx

[nickmaxwell]

Thanks for the help guys. Reading up now.