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

Create and Pass custom date to form, query and report

P: n/a
I have created a db for a non-profit, contacts, volunteers, donors,
etc.

Our statistical year ends on the last Sunday of September and starts
on the first Monday following.

Our statistical month ends on the last Sunday of a given month and
starts on the first Monday following the last Sunday of the previous
month.

My users are not computer savy and need as many default options as
possible.

I have a table with two fields ID 1-12 (nbr) and Month January -
December (txt) with corresponding query. On my SB I have a combo box
based on this query that defaults to the current month using the
default =Format(Date(),"mmmm"). The user will be able to select a
previous month.

I need help in taking the results of the cbo to two text boxes, one to
show beg of stat month and one to show end of stat month (ex: Feb 2004
dates were 1/26/2004 - 2/29/2004). Dates will then be used as default
for entering volunteer detail records, and reporting volunteer hours
by stat month. I am looking for advice on how to make the
calculations.

Thanks LizM
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.