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"

Thanks John,

The form is on a remote server.

Our next fiscal year is 1/7/2013 -30/6/2014.

I need the query to add 1/7/2013 by default when anyone adds a new name.

Many thanks,

Robin

At 14/03/2013 06:18 PM, you wrote:
>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]
>
>
>
>------------------------------------
>
>Yahoo! Groups Links
>
>
>