ACCESS FEED: RE: [MS_AccessPros] How do I establish the first day of "Next Fiscal Year"

Kamis, 14 Maret 2013

RE: [MS_AccessPros] How do I establish the first day of "Next Fiscal Year"

Robin-

Are you saying that July 1 of this year starts fiscal year 2014? What does
the user enter in "Next Fiscal Year" (I assume this is in a form), and what
do you expect to happen?

John Viescas, Author

Microsoft Access 2010 Inside Out

Microsoft Access 2007 Inside Out

Microsoft Access 2003 Inside Out

Building Microsoft Access Applications

SQL Queries for Mere Mortals

http://www.viescas.com/

(Paris, France)

From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Robin Chapple
Sent: Thursday, March 14, 2013 7:25 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] How do I establish the first day of "Next Fiscal
Year"

My organisation has a fiscal year that starts on 1st July.

I need the SQL for a query that will enter 1/7/'nextfiscalyear' when
we enter names for committees and other posts in the 'Next Fiscal Year'.

It has completely baffled me. That is not difficult as some of you
know already.

Many thanks,

Robin Chapple

[Non-text portions of this message have been removed]