fraser_lindsay
Access wannabe
- Local time
- Today, 18:48
- Joined
- Sep 7, 2005
- Messages
- 218
Hello,
I have a QBF routine that I have been using to produce tailored reports form my DB. I want to create a new query using QBF to allow the users to select different parts of the business but also using some static rules to return the data.
I am returning list of employees based on some simple rules.
I have an unbound form and code for various combo boxes and I know this works as I have used it on two other forms.
Where I am struggling is how to write in VBA the code for the rules. I want to list employees by the combo boxes selected but only those above a score of 50 for at least one or any combination of eight fields.
Can anyone help?
I have been trying to create a query then import the SQL text into VBA but don't know what to assign it to or even if the code is correct.
I have a QBF routine that I have been using to produce tailored reports form my DB. I want to create a new query using QBF to allow the users to select different parts of the business but also using some static rules to return the data.
I am returning list of employees based on some simple rules.
I have an unbound form and code for various combo boxes and I know this works as I have used it on two other forms.
Where I am struggling is how to write in VBA the code for the rules. I want to list employees by the combo boxes selected but only those above a score of 50 for at least one or any combination of eight fields.
Can anyone help?
I have been trying to create a query then import the SQL text into VBA but don't know what to assign it to or even if the code is correct.
