Re: $$Excel-Macros$$ Need formula for Current Date Access

2011-07-11 Thread Sanjib Chatterjee
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 repl

Re: $$Excel-Macros$$ Need formula for Current Date Access

2011-07-09 Thread Sanjib Chatterjee
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 wrote: > * my pleasure > * > Have A Nice Time & Enjoy Life > > Regards: > CMA Ankur Pandey > (Someone Different) > > I'm not the

Re: $$Excel-Macros$$ Need formula for Current Date Access

2011-07-06 Thread ankur
* 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 wrote: > Dear Ankur, > > Its working fine. Thank you very much. > > Regards, > Idhrees. > > On Tue, Jul 5, 201

Re: $$Excel-Macros$$ Need formula for Current Date Access

2011-07-06 Thread Idhrees Mohamed
Dear Ankur, Its working fine. Thank you very much. Regards, Idhrees. On Tue, Jul 5, 2011 at 3:46 PM, ankur 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 fil

$$Excel-Macros$$ Need formula for Current Date Access

2011-07-05 Thread Idhrees Mohamed
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