How do I set up a Text box with a oddball formula in access 2007?

[darth.pathos]

Good morning,

I'm working on a productivity database for our summer students and I need to have a field in my Report Header saying the number of reports needing to be cleared every working day (using today's date and the current number of open tickets) to meet the quota by August 31st. I have 2 students, working 2 days a week each, so I have 4 days of productive time. I have played around with a bunch of different functions but cannot figure out how to do this.

Number of tickets = 700
Number of Working days = 4


Total Number of Days = ((Now()-#31 aug 2013#)

Any thoughts? I'm sure it's really obvious but I'm just not seeing it. I blame it on Monday :-)
Thanks
Chris

[rzw0wr]

I'm sure it's really obvious but I'm just not seeing it.

Me neither.

I am not seeing what you want.

Complete details would help a great deal.

Please explain as fully as you can what you want and what you have tried.

If needed upload you database. It is Monday for us also.

Dale

[darth.pathos]

Sorry Dale! trying this again <blush>

I need to have a field on my report saying "We need to do xxxx number of tickets a day to meet our quota". The xxxx will be calculated based on Total Ticket number (~700, going down every day), and then by the number of days of work (4, 2 students x 2 days).
Because both the number of tickets and the number of working days are dynamic, I'm having problems getting the Number of Working days. Right now, using 700 tickets / 40 working days, I need the two students to complete 17.5 tickets total. Tomorrow, that number will go up to 18 if they do nothing today, and so on.

Unfortunately I can't upload the database as it's really, really full of Personal Health Information, and the query is way too complex for me to strip down to the basics. Hopefully this description will give you enough to help me out :-)
Chris

[rzw0wr]

OK.
You want a query, correct.
In this query you want to, first have the number of days between two dates ( work days) left, then you want to number of tickets (tasks) left from 700. Correct.

Needed requirements:
Field Names of dates.
Field names students (workers)
Any other data you want in your query.

Dale

PS. I am not real good with SQL yet, but I will try and maybe someone with experience will stop by.

[darth.pathos]

...well I figured it out - all i had to do was take my calculation using DATEDIFF and multiply the whole thing by 4/7 (4 working days out of 7). It was that simple.

Guess this is going to be one off those weeks. Wahoo.

Thanks
Chris