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-
2 2580
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.
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.
Sign in to post your reply or Sign up for a free account.
Similar topics
by: Mike Turco |
last post by:
I like using the expression builder for a lot of different things but it
isn't always available when I want to use it, for example in the code
window, or in all of the control properties. I am...
|
by: Don |
last post by:
I'm trying to build a simple report. It will show debtors, budgeted amounts
and how much was actually paid to those debtors. I've tried using the
expression builder, though I've never used it...
|
by: Brian Kitt |
last post by:
I have a process where I do some minimal reformating on a TAB delimited
document to prepare for DTS load. This process has been running fine, but I
recently made a change. I have a Full Text...
|
by: AlexanderTodorovic |
last post by:
Hello Everyone,
I'm developing a client application in which the users need an
expression
builder as provided in MS Access 2003. I would like to use the
expression
builder in a C# application....
|
by: emajka21 |
last post by:
Access 2000, I am trying to add a "Summed" total to a report (in a grouped footer section). But I only want to sum the top 3 items. I know how to write this in sql but it seems I can't get a to a...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: ryjfgjl |
last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |