Desktop

Ask something
Discussion Locked

ACCESS IS TRYING TO KILL ME!

0 helpful
3 replies

by joe 1 view

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I have created a query that call for all customer job information. When I run the query in standard mode all information for all customers appears, so far so good. When I try to get the query to just return all information for one particular projectit comes up blank. It does not matter what project name I try to query. It does not matter if I try to get it to act as a parameter query instead of a select query and it does not matter if I create a form that asks for criteria. I know it is probably something very simple that I am overlooking, but it is starting to cause my head to hurt. Please help

Thank you,

3 replies

by phingers

Create a new form. On the form try to create a combo box that holds the project the query should return resluts for. To do this create the combo box, give it a name you'll recognise. The row source type should be table/query, invoke the ...query builder and create a query to 'group by' project, select yes to update the SQL property.
Open the form and select a project using your combo box - this way you at least know that the selection is correct, point your query to the form and see if it works.

This discussion is closed to new replies.