Crosswords6 mins ago
Access Help
I'm enhancing a database I've been working on for a few weeks. Some of you have already helped out with this...
I have a table of reps (Key is Rep ID)
I have a table of errors, each error (type) incurs a points value.
I have a query & report that displays the points/rep between two given dates
I have a query & report that translates the points value into a grade.
The problem is that a grade is only given to reps with a points value.
Points are only given to reps who have made errors.
What I now want to do is update all of this to allocate a grade to those reps who haven't made an error. They can then be recognised for this.
I've been playing around with a query but cannot get the reps with no errors to be displayed.
I do not want reps with errors (with a points value or grade) to be displayed.
I then want to turn the query into an Append Query adding a grade (Say '1') to those with no errors.
Hope that is easy to read.. Can anyone point me in the right direction?
I have a table of reps (Key is Rep ID)
I have a table of errors, each error (type) incurs a points value.
I have a query & report that displays the points/rep between two given dates
I have a query & report that translates the points value into a grade.
The problem is that a grade is only given to reps with a points value.
Points are only given to reps who have made errors.
What I now want to do is update all of this to allocate a grade to those reps who haven't made an error. They can then be recognised for this.
I've been playing around with a query but cannot get the reps with no errors to be displayed.
I do not want reps with errors (with a points value or grade) to be displayed.
I then want to turn the query into an Append Query adding a grade (Say '1') to those with no errors.
Hope that is easy to read.. Can anyone point me in the right direction?
Answers
1 to 2 of 2
Best Answer
No best answer has yet been selected by tpreece01. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.
For a start, open your query in design view, LEFT click on the line joining the 2 tables to select it - it should become thicker. Then still pointing to this line RIGHT click and choose join properties. A window will open to give you a choice of three types of join. Choose the one which suits your requirements and you should get reps without any errors included in your query result.
I did that before posting the question vascop, however it still returned the same results...
I've actually got it working today using two queries (it didn't seem to like working between two given dates)..
The first query lists all errors between the two dates..
The second query lists all reps from the reps table and filters it by type of error [Where Is Null] from the first query.
Works a treat.
I've actually got it working today using two queries (it didn't seem to like working between two given dates)..
The first query lists all errors between the two dates..
The second query lists all reps from the reps table and filters it by type of error [Where Is Null] from the first query.
Works a treat.
1 to 2 of 2
