Need some basic help

[7NetAd]

I've been tasked with creating an access database, and I think I'm in a little over my head here...the person who is generally tasked with doing this has been terminated, and now the job has fallen to me...

In any case, I'm generally quite familiar with the basics of Access...but I need help creating a control within a database.

There are two check-boxes in the database, 'Service Complete', and 'Service Picked-Up'. Is there any way to set it up so that when neither of those boxes is checked, it places that form under one heading, when one is checked, it places the form in another, and when they're both checked, it places the form in still another area?

What do I do?

Thanks again for your help.

 

[ReAn]

Not sure what you mean by "placing the form" under "headings".

Care to elaborate?

 

[7NetAd]

Sorry, I guess terminology is everything. When one box is checked, the record needs to be included in one report, when the other is checked, it needs to go into another.

My primary job is not creating Access databases...I'm the head of the IT department...but the owner is something of a luddite, and he basically hands me anything that says 'Computers' and lets me delegate from there. Unfortunately, I'm the only one who has any experience with databases...and it's limited, to say the least.

 

[ReAn]

Not sure exactly what you mean but try this:

In your table make two yes/no fields called Report1 and Report2

then make a checkbox on your form and make it's controlsource corresponding to whichever one of those two fields.

Then when you run your report, filter only those with "yes" in the report field corresponding to the report you ran.