Dear Friend, Would you please send a formula of MS Access regarding FIFO Thanking you
Sanjib On Sat, Jul 9, 2011 at 12:46 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > Dear Friend, > Can you please send a formula how to use a FIFO method in MS ACCESS? > > Waiting for your reply > > Thanking you > > Sanjib > > > > On Thu, Jul 7, 2011 at 11:50 AM, ankur <ankurpande...@gmail.com> wrote: > >> * my pleasure >> * >> Have A Nice Time & Enjoy Life >> >> Regards: >> CMA Ankur Pandey >> (Someone Different) >> >> I'm not the best but i'm not like the rest~~ >> >> >> On Wed, Jul 6, 2011 at 7:04 PM, Idhrees Mohamed <idhrees...@gmail.com>wrote: >> >>> Dear Ankur, >>> >>> Its working fine. Thank you very much. >>> >>> Regards, >>> Idhrees. >>> >>> On Tue, Jul 5, 2011 at 3:46 PM, ankur <ankurpande...@gmail.com> wrote: >>> >>>> *You can create a form, by using the IIF function in Control Source >>>> property...Of the field which required >>>> >>>> =IIf([Valid date]=Date(),"valid","expired") >>>> >>>> one sample file is attached... >>>> >>>> >>>> *Have A Nice Time & Enjoy Life >>>> >>>> Regards: >>>> CMA Ankur Pandey >>>> (Someone Different) >>>> >>>> I'm not the best but i'm not like the rest~~ >>>> >>>> >>>> >>>> On Tue, Jul 5, 2011 at 12:35 PM, Idhrees Mohamed >>>> <idhrees...@gmail.com>wrote: >>>> >>>>> Dear Friends, >>>>> >>>>> I need a help to access query for current date. >>>>> >>>>> I have an column with name valid date. I need a formula for validity >>>>> date less than current date, its shown "valid otherwise "expired" like >>>>> that. >>>>> Please help me the ms access fuction for this. >>>>> >>>>> -- >>>>> Thanks & Regards, >>>>> >>>>> Mohamed Idhrees. S. >>>>> >>>>> -- >>>>> >>>>> ---------------------------------------------------------------------------------- >>>>> Some important links for excel users: >>>>> 1. Follow us on TWITTER for tips tricks and links : >>>>> http://twitter.com/exceldailytip >>>>> 2. Join our LinkedIN group @ >>>>> http://www.linkedin.com/groups?gid=1871310 >>>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>>> >>>>> To post to this group, send email to excel-macros@googlegroups.com >>>>> >>>>> <><><><><><><><><><><><><><><><><><><><><><> >>>>> Like our page on facebook , Just follow below link >>>>> http://www.facebook.com/discussexcel >>>>> >>>> >>>> -- >>>> >>>> ---------------------------------------------------------------------------------- >>>> Some important links for excel users: >>>> 1. Follow us on TWITTER for tips tricks and links : >>>> http://twitter.com/exceldailytip >>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>>> >>>> To post to this group, send email to excel-macros@googlegroups.com >>>> >>>> <><><><><><><><><><><><><><><><><><><><><><> >>>> Like our page on facebook , Just follow below link >>>> http://www.facebook.com/discussexcel >>>> >>> >>> >>> >>> -- >>> Thanks & Regards, >>> >>> Mohamed Idhrees. S. >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/discussexcel >>> >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel