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

have something on form that shows all records

100+
P: 107
Hello,
I have a form in microsoft access. I enter one record at a time.
I am wondering is there anyway to have on the form something that shows all the records also- There is only going to be 7 total. Then once 7 are entered in 7 days -They will be deleted and started over the next week?

I thought I could have a list box open and it would show every record no matter what record I have open - but cannot get that to work
Thank you,
any ideas?
Jul 26 '08 #1
Share this Question
Share on Google+
2 Replies


Expert 100+
P: 374
What happens to the data after the 7 days. Do you do some kind of summary reporting, or store the sum of the 7 days into another table?

Because if that is not the case, the simple way to accomplish what it is that you're doing is to simple create a single record that has all 7 days in it, then have those fields update that one record, then that would support multiple people having there 7 days at a time.

Then you would have the option of adding additional 7 days at a time.

Hope that helps,

Joe P.
Jul 26 '08 #2

100+
P: 107
thank you that will work
Jul 26 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.