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