Year Minus One

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

		Home » OfficeFrustration forum » Microsoft Access » Running & Setting Up Queries
Year Minus One

Home

« Previous Thread | Next Thread »

Thread Tools

Display Modes

December 1st, 2009, 02:32 PM posted to microsoft.public.access.queries

ann

external usenet poster

Posts: 462

Year Minus One

I am using Access 2002 and have a two character text field [txtDRSYear] that
holds the last to characters of the current year, (example 09). I want to
retrieve all the records for the current year minus one so I can archive all
the 2009 data in 2010 but I can't figure out how to do that using Date().
Thanks in advance.

Report this post as spam, offensive or inappropriate

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is Off HTML code is Off

Forum Jump

All times are GMT +1. The time now is 04:46 PM.