473,475 Members | 1,897 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Auto update form field to calculate number of days overdue

1 New Member
I'm trying to update a form field to calculate number of days overdue based on another projected training date field on my form.
This is what I have on my control source line:

=DateDiff("d",[Projected Training Date],Date())

I'm getting Name? in field. Any help appreciated
Oct 7 '15 #1
2 1910
Seth Schrock
2,965 Recognized Expert Specialist
Have you checked to make sure that your field name is spelled correctly?
Oct 8 '15 #2
hvsummer
215 New Member
you may have problem with datatype, first checking name as seth schrock suggestions. next, check your date's field data type.

you can use datevalue() to force access recognize value as date.

Expand|Select|Wrap|Line Numbers
  1. =DateDiff("d",datevalue([Projected Training Date]),Date())
Oct 8 '15 #3

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

Similar topics

3
2570
by: Chris | last post by:
Before I started to create table, etc to track unique form field record number assigments I thought I'd check to see if there is now a better way to do this in .NET. I have a parent form (table)...
1
3077
by: ainsley | last post by:
Hi this is going to sound like a very basic question, but I am creating a database in Access which is based on a number of unlimited tables. In my data entry form i have a number of combo boxes...
0
1788
by: letsgetsilly | last post by:
Hello all, I'm using MS SQL server. I'm trying to SELECT * FROM 4 different tables WHERE (DueDate < Today'sDate), and therefore overdue. I would like to display all of this information in a...
1
7075
by: Michael McGrew | last post by:
I have a asp form that has a dynamic drop-down box that a user selects a value from. Once the user makes a selection I use the onChange event to capture the selection and pass this value to a...
1
1975
by: kunal0101 | last post by:
Hi, I am a new user to access and am building a database to capture the rotation dates for employees. There is a table called "Rotation schedule" which contains "name", "Duration (in weeks) and...
1
2761
by: Phil | last post by:
Hello, I have a sales form, order details, that shows Product ID, quantity, Unit Price, etc. I have a Products table, Products, that has Product ID, Stock Level, Unit Price. What i would like...
17
4829
by: cmcdermo | last post by:
Ok my first post here so sorry if i mess something up. I have to edit a page that uses some javascript and not sure really. At the moment a user clicks on a button saying "black and white" and...
2
1908
by: Xaysana12345 | last post by:
Please help. I have been developing a financial database, now I have been in last bit to finish. i do not know much technical terms, but i am trying to explain what i need. so please be with me. ...
9
1394
by: blpierce76 | last post by:
I have a form I use to log in sample with the Lab ID as the tables primary key. Currently I have this form open to the last record for entering new samples. However if I type in or select an...
0
7026
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
6898
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7015
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
7059
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
6714
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
6822
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
1
4754
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
2967
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
157
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.