Simple Question..How do I calculate fields in MS Access (design vi

  • Thread starter Thread starter Lady123
  • Start date Start date
L

Lady123

If anyone can help, please do....How do I setup the system to run certain
reports to include:

completion dates only
completion dates with no values
completion dates by indivdual names
task that were completed between a certain timeframe

Thanks in advance.
 
Here is what I would suggest.
Create an Option group with a choice for each version of the report you want
to run. Then in the After Update of the Option Group, use the Where Argument
of the OpenReport method to filter your reports.
 
If anyone can help, please do....How do I setup the system to run certain
reports to include:

completion dates only
completion dates with no values
completion dates by indivdual names
task that were completed between a certain timeframe

Thanks in advance.
Click to expand...

Since we have no way to know anything about the structure of your tables
(what's a completion date? how is it determined? how and in what table are the
names stored?) all I can suggest is "base the report on an appropriate query
with criteria on the date field".

Your subject line mentions "calculated fields" but the text does not appear to
do so, which is part of my confusion.

John W. Vinson [MVP]
 
Thanks for your response....

A "completion date" corresponds to a tasks, the tasks are completed by a
certain date. Each team or individual in the office has tasks that have "due
dates". Once the tasks are completed I insert the date it was completed, thus
a "completion date". The "completion date" are stored in the table, report &
query tables. Also, "completion dates" with "no data" are those that
haven't been completed yet, those fields are "blank". I would like to run a
report with those "blank" fields also I would like to have a report by
"responsible party/originator". The responsible party/originator have been
setup in table, report & query table. So far, I have a tracking report that
I created that shows everything to include: due date, topic, completion date,
responsible party & conclusion. I started a completion report, but I was
unsuccessful. Any suggestions would be greatly appreciated. Thanks.
 
Back
Top