Search results

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

In DatePart() how to use to get month and year it gives only month or year

i have two fields or expressions sysduedate date format ( mm/dd/yyyy ) it has 04/28/2011 ( apr/28/2011 ) and Nextduedate date format ( mm/dd/yyyy ) it has 04/08/2011 ( apr/08/2011 ) both are tables are joined by a query now i am not able to match because days are different how to...

Thanks vbaInet I combined all of them to one thanks for motivation and helping calibtaion due date will be based on the month procured that will be registered date so problem if any month this is the formual allformulajoined: DateAdd("m",(Fix(DateDiff("m",[REGDATE],([Monthofcal] &...

THANKS vbaInet Re: Help : merge functions to one circular Reference i think it may come if i use one formula but not sure a guess On a side note, what will happen if [Monthofcal] is April here? --> it calculates for apr and monthofcal does not change in table its fixed NewDateField...

Thanks vbaInet : Re: Help : merge functions to one you are right the thing is i have a field in table imtemaster: [regdate] and [freq] and exp: [mfg] in form to input year 2011 if the [regdate] is 10/dec/2006 and freq is 24(months) this means every 24 months it should have a date and if...