Hi Everyone
My computer has been updated to 2010 whilst I've been off sick (was 2003 before my accident).
I hope someone can help me please? I've created a main table, for devises across the company, and a combo box/selection box based on another table which holds a list of all the "Responsible" employee's aswell as another combo box/selection box for the device location.
So the person entering the information, can enter all the information for a device (torq wrench, socket set etc), who is responsible for it and which department they belong to (where to find the device).
Which all works fine
However, I'd like to create 2 queries, one to enable the user to run a report of all device's allocated with an employee or to be able to run a query for all device's stored in a particular department.
But I have been unable to set the correct query criteria, to enable to query user to be able to selection from a drop down list, which responsible person or location to pull back the correct list.
I was getting an error asking me to set the parenthesis, I have now deleted criteria for both queries, as even if I put [Enter] and type a Responsible person's name exactly as its held on the table, the report comes back blank.
Be really ever so grateful for some help
I've tried looking on the web search and in my 2010 Access user guide, but I've not been able to find any tips/help.
Quite possibly as I am not using the correct terminology
Thank you in advance
Clair
:banghead:
My computer has been updated to 2010 whilst I've been off sick (was 2003 before my accident).
I hope someone can help me please? I've created a main table, for devises across the company, and a combo box/selection box based on another table which holds a list of all the "Responsible" employee's aswell as another combo box/selection box for the device location.
So the person entering the information, can enter all the information for a device (torq wrench, socket set etc), who is responsible for it and which department they belong to (where to find the device).
Which all works fine
However, I'd like to create 2 queries, one to enable the user to run a report of all device's allocated with an employee or to be able to run a query for all device's stored in a particular department.
But I have been unable to set the correct query criteria, to enable to query user to be able to selection from a drop down list, which responsible person or location to pull back the correct list.
I was getting an error asking me to set the parenthesis, I have now deleted criteria for both queries, as even if I put [Enter] and type a Responsible person's name exactly as its held on the table, the report comes back blank.
Be really ever so grateful for some help
I've tried looking on the web search and in my 2010 Access user guide, but I've not been able to find any tips/help.
Quite possibly as I am not using the correct terminology
Thank you in advance
Clair
:banghead:
