Duplicate query, (sort of)

[cdoyle]

Also, not sure if I'm just doing something wrong or not.

But if I try and add any other fields to this query (to display on the report) for example we have a comments field. If I add that to the query, the query won't display any results.

not sure what I'm doing wrong.

 

[cdoyle]

Anyone have any ideas how to make it do what I need?

 

[ajetrumpet]

Doyle,

take a look at this thread...
http://www.access-programmers.co.uk/forums/showthread.php?t=135763

You can post the SQL you have now if you would like. From your last post, it sounds like you just need to eliminate the "data_type = 6" section of the WHERE clause