473,470 Members | 1,972 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

Conditionaly Highlight an Expiry Date in a Form that is Due in 40 Days

1 New Member
How can I set the above, and create a report for all dates in a database that are due in 40 days?
Jul 12 '14 #1
2 1533
twinnyfo
3,653 Recognized Expert Moderator Specialist
What have you tried so far? Exactly what is it that you are looking for, because it looks like you are asking for two different things: One is a report for dates meeting that criterion, the other is conditionally formatting a date.

It is confusing as to exactly which you are asking for.
Jul 12 '14 #2
NeoPa
32,556 Recognized Expert Moderator MVP
Start by adding a calculated field into your query such as :
Expand|Select|Wrap|Line Numbers
  1. (DateAdd('d',40,Date())>[DueDate]) AS [NearlyDue]
Using Conditional Formatting is a matter of selecting it from the menu or ribbon and configuring it. You can use [NearlyDue] in your criteria.
Jul 12 '14 #3

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

Similar topics

1
by: khalid_uk | last post by:
hi can anyone please show me how to put current date in form (drop down) and it should gives the user an error if the want to choose an invalid dates (holidays and past days) and current month and...
8
by: Colleyville Alan | last post by:
I have been working on an Access app that takes info from a file and writes it to a spreadsheet on a form, simultaneously saving the spreadsheet to Excel. I got the idea that the same concept...
3
by: JingleBEV | last post by:
Hi all, I have a masked text control that would return a date in string format via the mask property like: "9/23/2004" and i have a calendar control that would pop up when I click a command...
3
by: rsbutterfly16 | last post by:
hi all, I have a front end access database (mdb) with a sql server backend for my tables. I have an form in which I have created a store procedure in sql server, and i have a form created and also...
0
by: rdemyan via AccessMonster.com | last post by:
I have a need to highlight a date range in a bar chart. If the "highlighting" is accomplished by changing the bar column color for the specific months in the date range, that would be great. ...
1
by: CoolFactor | last post by:
MY CODE IS NEAR THE BOTTOM I want to export this Access query into Excel using a command button on an Access form in the following way I describe below. Below you will find the simple query I am...
1
by: chrisdavies | last post by:
Hi I've got an Access form and I want the border of each control to be certain colour and width the control is active. I've done this by using ENTER and EXIT events for each one, but wondered if...
1
by: tmcjunkin | last post by:
I'm trying to back into this project by defining what the user needs to see when they open a form. I'm between beginner and intermediate with vba, but have been using access for years. When the...
2
by: beemomo | last post by:
hi everyone! i am using an active x control : date time picker in an access form that bound to date field in a table. Whenever it is displayed on my machine, the control can be displayed and...
2
by: eko99312 | last post by:
Dear All, As you know that input data on excel is easy than access, you can simple click the date that you prefer and input the value that you want. For example : Consider that the month that I...
0
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...
0
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
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...
0
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
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
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
0
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...
0
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

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.