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

Expression Builder Help...

P: 2
Hey Everyone,

So I am completely new to Access. I have never used it befor in my life (however i am somewhat familiar with SQL). I got thrown into an internship which involves using access (they knew I had no expirience, but I guess they expected me to learn)...

So to address my problem, and i am sure that it is rather simple for most of you but I can no figure it out to save my life. I am trying to create a default value in a field by using the expression builder. The table has a bunch of fields, however the to get the result, I simply need to take the field "initial start date" (which is in date form), and add 183 days or 6 months, and output that date as the expiration date in the "expiration date" field.

Thanks in advance, and i am sure you guys will be seeing much more of me this summer. =)

-Ben-
Jun 6 '07 #1
Share this Question
Share on Google+
2 Replies


P: 2
I also forgot to mention, that while playing around with it, I quite often get the error message "The database engine does not recognize either the field "Initial Inquiry Date" in a validation expression, or the default value in the table Inquiries"...not sure why im getting it, but hopefully someone does.
Jun 6 '07 #2

Rabbit
Expert Mod 10K+
P: 12,316
Hey Everyone,

So I am completely new to Access. I have never used it befor in my life (however i am somewhat familiar with SQL). I got thrown into an internship which involves using access (they knew I had no expirience, but I guess they expected me to learn)...

So to address my problem, and i am sure that it is rather simple for most of you but I can no figure it out to save my life. I am trying to create a default value in a field by using the expression builder. The table has a bunch of fields, however the to get the result, I simply need to take the field "initial start date" (which is in date form), and add 183 days or 6 months, and output that date as the expiration date in the "expiration date" field.

Thanks in advance, and i am sure you guys will be seeing much more of me this summer. =)

-Ben-
For these kinds of validation, or rather, you want to auto populate the field, usually you would use a query or calculate the value when it is needed. There is no need to store a value that you can calculate from existing values. However, in situations like these, you would have to do it through a form.
Jun 6 '07 #3

Post your reply

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