Recent content by eddii

Thanks vbaInet :Re: HELP : IN Duplicaiting record in query based on condition thanks vbaInet your are right i have stored all calibration details in a table which has calibration date and next calibraiton date but the problem is i cannot connect based on calibration date because some times...

Thanks vabInet :Re: HELP : IN Duplicaiting record in query based on condition Thanks vabInet for the patience and listening to me i was out of office so could not reply sorry i am preparing a calibration database in which i have a list of instruments which are entered once in the table and...

Thanks jdraw Re: HELP : IN Duplicaiting record in query based on condition Thanks jdraw for reply the filed named [freq] contains month intervals and the field named [monthofcal] contains the start of month example : FREQ-------monthofcal------FREQMONTH 6------------JAN------...

THANKS vbaInet : HELP : IN Duplicaiting record in query based on condition THANKS vbaInet : for checking the thread as you suggest i have created a duplicate freq table I have crude idea but i dont know how to put the formula in the query i have created a new table called...

thanks but i dont know how to write the code can you tell what change has to be done so that i will update the code Private Sub Calibration_MonthSTATUS_Click() Dim strPlantmonth As String Dim strShopmonth As String Dim strmonthofcal As String Dim StrWhere As String strPlantmonth =...

Thanks vbaInet the code is working but the total is not comming if i export to excel format the reports =Count(IIf([STATUSCER]="ok",1,Null)) File = export = save as excel sorry to disturb

i have a query named : {imtemasterqry} in which i have record entered only once for calculation purpose i want to duplicate the records based on [freq] and change [monthofcal] Sqlview SELECT IMTEMASTER.IMTENAME, IMTEMASTER.IMTENUMBER, IMTEMASTER.SHOP, IMTEMASTER.PLANT...

Thanks for the reply: HELP : query error (Error 3071) Thanks MSAccessRookie Thanks vbaInet of the reply i was late in replying as i was out of office and could not reply MSAccessRookie i will come back as soon as i get check you code vbaInet iam sorry i have not seen that i will find out...

Thanks jdraw Re: HELP : query error (Error 3071) Thanks for the reply jdraw i have two tables which are connected using join properties iam able to get report using the query named (final) sql view of link query: FROM imtemasterqry LEFT JOIN calibcertiqry ON...

i have connected two queries i get this error This expression is typed incorrectly, or it is too complex to be evaluated. For example, a numeric expression may contain too many complicated elements. Try simplifying the expression by assigning parts of the expression to variables. (Error 3071)...

THANKS vbaInet : Re: help to add :the values in field THANKS vbaInet :

thanks vbaInet thanks for teaching, now iam able to understand things how they work as old was in text format

[STATUSCER] Field name STATUSCEROKNGCASCRAPPENDINGBREAK DOWNMISSING i want to add the contents of the above filed which has many texts right now iam using these to add or count OK_Count: IIf([STATUSCER]="ok",1,0) ng_Count: IIf([STATUSCER]="ng",1,0) pending_Count...

Thank you very much Re: Help Match two dates as same vbaInet & John Big Booty Thanks you very much i have used formatfor: Format([nextcalduedate],"mm/yyyy") i got the problem solved by using format function but will it work if i give in query properties format directly to [nextcalduedate]

thanks : Re: Help Match two dates as same thanks vbaInet thanks John Big Booty i will do it and get back to you tomorrow thank you once again for the fast response