Kamis, 24 Mei 2012

Re: [MS_AccessPros] Finding "This Fiscal Year"

Dear John

Thanks for the advise

But the form is still not filtered I am getting this error "Can't find the
field "|" referred to in your expression."

On Thu, May 24, 2012 at 12:10 PM, Robin Chapple <robinski@mymail.net.au>wrote:

> **
>
>
>
> We have a fiscal year which runs from 1st July to 30th June. I need
> to find dates that are within "This Fiscal Year".
>
> I had a similar need and the group advised this SQL which works for
> the first requirement.
>
>
> >IIf(Month(Date())>=7,DateSerial(Year(Date()),7,1),DateSerial(Year(Date())-1,7,1))
>
> It is currently finding dates after 1/7/2012.
>
> What do I need to do to change it?
>
> Many thanks,
>
> Robin Chapple
>
>
>



--
Kind Regards,
Abdul Shakeel


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



------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/

Tidak ada komentar:

Posting Komentar