Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.
Yes/No reports in Access 2003
Name: RickM Date: December 3, 2004 at 08:07:00 Pacific OS: XP SP2 CPU/Ram: 1.5gb
Comment:
I have a system inventory in Access. I need to write a query and report to list all items that do not have a complete inventory. I do have a y/n field in the database; I want the query and report to list ONLY the items that aren't checked (checked is yes, unchecked is no). How do I do this?
Name: rac1473 Date: December 3, 2004 at 10:18:07 Pacific
Reply:
Hi Rick
What you have to do is use the query wizard to query the table where all you info is stored. once the query is done and saved you have to open it in its design view.then where the query has the y/n box you have to put in the box underneath the tick the following. =NO ,then save. You should now be able to make a report which is linked to this query.
hope this helps
0
Response Number 2
Name: RickM Date: December 3, 2004 at 11:30:44 Pacific
Reply:
I figured it out about 30 minutes after I posted this. Was trying to do a report....skipped it, did the query and remebered the part about NO (after I while the one access class I had 5 years ago came back). Once the query was working then I got the report done.
Summary: This is an Access db to track leave slips. To enter new time we have a form with a combo box, choose a name in the combo box, then a subform shows that employee's info from our timeoff table, and lets...
Summary: I am trying to put yes/no answers into Access and retrieve a query or report that would a) count the total number of entries in a given field b) count the total "Yes" answers c) Calculate the percent...
0 
