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

Need date help

P: 1
Hello,
I am using Access as a front end to mssql...
I want a form where the data comes from two table.

Table1
ID, Country, City

Table2
ID, Date, Temp, Comments

What I need
Form, Columnar

[ID ][Country][City] [Month1][Month2][CurrentMonth]
12 NZ Wellington 20 22 _______
13 AU Sidney 20 21 _______


I need to display the previous 2 months temperature and be able to enter this current months temperature, having the date be automatically added as today
I currently do this a speadsheet but want to start keeping a database.
I like the table format, because I can easily jump around and see what I missed
But are entered typically in order a few a day, based on country.
I will not enter Month1 or Month1, I want them to just display the previous 2 months temps, if I miss one it is ok to be blank.
So basically, CurrentMonth needs to be the only editable field.
Thanks
ICE
May 22 '07 #1
Share this Question
Share on Google+
1 Reply

NeoPa
Expert Mod 15k+
P: 31,770
You have posted this question in the Access Articles section.
I will move it to the Access Forum for you.
Good luck with your question.

MODERATOR.
May 23 '07 #2

Post your reply

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