By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,197 Members | 1,151 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,197 IT Pros & Developers. It's quick & easy.

Variable start date for report parameters

P: n/a
I have a report that summarizes attendance occurances for my team of
50 employees. Right now the date values are entered by the user before
report execution.

I want the start date to be flexible... I built a query which shows
all reps on an active attendance write up (within the last 180 days).
I want the attendance report to use the query's write up date as the
start date for each employee (if an active write up exists), and if no
active write up exists, then use the current date minus 180 days. The
code would need to loop through each employee to determine the start
date of the report. The end date will be the current date for all
employees. The report is a summary of all reps so the variable start
time seemed tricky to me. Please let me know if there is any other
information needed.

Thanks-

Scott

Jul 24 '07 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.