Recent content by PKJ

Hi! Welcome to AWF. It (= access knowledge) rains here anyday-anytime - draw out as much as u can. I say with my experience that if u clearly state ur problem then solution is definite here - thanks to senior members of AWF.

Hi Everybody !! I am Pawan Joshi from Jaipur, India. I am back here after a long time. I am not a professional programmer and am engaged in a non-IT job. Though Access, Excel and VBA programming are my favourite subjects, still I am a greenhorn in Access. This great forum has given me a lot...

I tried your queries in Access-2007 and both of them worked fine giving correct results. SELECT Account, Fac From ( SELECT Account, CInt(Left(account, 3)) as [Fac] from Accounts WHERE len(Account)=13 And isNumeric(left(Account,3)) ) as FacNos SELECT Account, [Fac] From ( SELECT Account...

Aha. you did miracle for me. Your advice worked perfect with following modification in RetirementDates_sq query - SELECT A.EmpCode, A.Name, A.Designation, A.OfficeCode, A.DateOfBirth, RetiringDate(DateOfBirth) AS RetDate FROM EmpList_Current_fqd AS A WHERE A.DateOfBirth IS NOT NULL; Dear...

Bob, Thanks for uploading a 2002-2003 format-file. Brian, I have also tried your suggestion of using PARAMETERS option in this problem causing query "RetirementDates_fq". PARAMETERS GivenDate DateTime; SELECT * FROM RetirementDates_sq WHERE RetDate<GivenDate; It is definetley of great use...

Ok Friend! Good Bye! I shall try to attach a .mdb file tommorrow.

Brian wrote: I am rather thankful and grateful for your help. But perhaps I need to learn this all from a standard text-book on this. Could you view the EmployeeDatabse that I attached. If your suggestion of PARAMETER option is directly related to my problem, I shall give it a try...

Brian said- Brian, I am poor in that - Parameter option - can you show an example. Thanks!

I tried saving the database in .mdb format but the queries and VBA module disappeared. So I have saved it in a ZIP folder and am attaching again.

Thanks Brianwarnock for the elegant RetDate function which is very instructive for me. raskew wrote: I have attach the database after deleting un-required objects for our present purpose - though required queries have been retained. In this database named Employees.accdb - the query...

Hi Bob, I am sorry for being poor in expressing the query code. In fact RetirementDates_sq and RetirementDates_fq are the names of the queries that I have mentioned in my problem-statement. The Query named "RetirementDates_fq" uses "RetirementDates_sq". "RetirementDates_sq" runs well but...

Hi banana! May I request you to view the thread - http://www.access-programmers.co.uk/forums/showthread.php?t=191929 It would be of extreme help if you can guide me to the solution. Regards - PKJoshi

highandwild wrote: Wouldn't that lead to unelegant-design problem.

Perhaps I have not been able to express the above problem clearly - may be the reason that no one took any interest in it. If anything more is to be revealed , kindly someone guide me to express it out. I solicit help from the knowledgeable members of the forum to solve this problem. Help...

Hi rasco22862, I admit that I did not care for elegancy and just put to words the idea that came to my mind without even trying that. After all I am a beginner and am not a professional programmer. Your suggestion/improvement is instructive for me. Thanks for that. Wish you good time. - PKJoshi.