Date

Sassy

Guest

Posts: n/a

4th Jun 2010

I have a table with a start date column. I have created a query where I
include the start date from my table, I have created an expression to add 24
months to the start date but what I would like to also have is either the
specific date or the closest month of May.
for example Start date is July 1, 2008 if I add 24 months it will show July
1, 2010
What I would like to see is May 2010 as this the month that we identify
individuals that need to start a secondary process.

Very new to access and not that great with formulas
--
Thank You
Sassy

« where can I find a 2010 attendance tracker | macro help »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
what method to use to add 1 day to a date (hotel reservation for one night by clicking on calender) and get it displayed in date formate in a textbox for departure date?	Amanda	Microsoft VB .NET	2	10th Oct 2006 06:52 AM
Link date to a table with Date Range (Eff Date and term date)	=?Utf-8?B?S2V2aW4gUmVlZA==?=	Microsoft Access	1	31st Aug 2006 04:23 PM
i have two date fileds Opend date Due date, can i set default on due date so, its always = to open date on my data entry form1 Urgent	Mike Saifie	Microsoft Access Form Coding	1	9th Mar 2006 01:08 AM
Run Query from date to date, Print the from date to date in the header of the report?	Dustin Swartz	Microsoft Access Queries	1	25th Jan 2005 07:06 PM
Date fields automatically changing when today date matches date field entry.Help!	Brian Cassin	Microsoft Access Forms	1	15th Nov 2003 01:51 PM