Guidance on how to do this please

H

Hell-fire

Hi,

I hope this could be something simple to answer. I need to make a report
that tallies up open and closed issues.

There are 5 issues in a combo box for the "IO" field. I want to link the
"Closed Date" field with the "IO" field. So if the "Closed Date" field is
blank, then the "IO" selected is considered open and vice versa.

Is this possible? If so, how would I do this. I'm unfortunately a newbie
at this, so would need a detail explaination. I know I can use =sum for the
formula, but not sure how to link two tables to do the rest.

Thank you
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top