Search results

thanks the report is working the change is done in report name txtstatuscer thankyou very much and aslo thanks for responding my other query in table

thanks for the reply boss i tried but i think i was wrong if possible pls say the procedure to do or change in db if no time no issues i will try in the way you told once again

Yes [statuscer] & [NEXTCALDUEDATE] contains null value data of [statuscer] = text format [statuscer] ok ng scrap pending missing data of = [NEXTCALDUEDATE] = date/time format data of = [SYSNEXTDUEDATE] = date/time format

thanks john i got it as iam still learning thanks for patience and help

how can the i merge many expression to one query field names regdate and freq and form input value mfg 02/apr/2009 and 6 and form input is 2011 then it works and gets the result 1st expr TOTMON: DateDiff("m",[REGDATE],[newdatefield]) 2nd expr NewDateField: [Monthofcal] &...

psl tell me how to use it in table design because i want to compare the two dates whose month and year will be same but day will be different like 12/dec/2011 compare with 15/dec/2011 and result to be same like it matches and return 1

thanks for reply : Help :split 1 field data into 3 fields in same table thanks for reply i want to split date as ex: 12/dec/2011 to day seperate and monthyear seperate 12 and dec/2011 because i want to compare the two dates whose month and year will be same but day will be different...

i have a table containing date i want to split the data field name : singledate example : 12/Dec/2011 answer to be 1stdate 2nd date ( format date/time) 12 dec/2011 table view singledate 1stdate 2nd date ( format date/time)...

duechek expression field in query code format is general number duecheck: IIf([NEXTCALDUEDATE]=[SYSNEXTDUEDATE],1,0)

duecheck is a expression inserted i have not given any data type it may be default data type

thanks for help vbaInet : help iif condition in report thanks for help vbaInet but this is not working as some data for statsucer is "ok" duechek field in query code duecheck: IIf([NEXTCALDUEDATE]=[SYSNEXTDUEDATE],1,0) it shows pending but this #error is not desplayed but shows...

i have report which opens by aform there is field in a query named duecheck if its value is 1 then in report it should show statucer value or else pending this is the formula =IIf([duecheck]=1,[STATUSCER],"pending") it shows this error if the value is true #Error instead of showning...

thanks for the reply query on iff condition true thanks for the reply dhamdard can you just tell me how to write the code for that this is the condition if mfgdate<caldate and field "statuscer" = scrap then it should not get in the list value if 2011<2009 and statuscer=scrap no in list

i have a query which has two tables imtemaster and calibrationcertificate i have joined based on imtenumber field of both tables SQL VIEW SELECT DISTINCTROW IMTEMASTER.IMTENUMBER, CALIBRATIONCERTIFICATE.IMTENUMBER, CALIBRATIONCERTIFICATE.CALDATE, CALIBRATIONCERTIFICATE.STATUSCER, FROM...

thanks for the reply you are right thanks for the reply you are right but i cannot put the text box to take the data because the user does not know this so he has to only select through year that means if the user is selecting year 2010 what ever are scraped before 2010 should not appear in...

Trevor G thanks for the reply thanks for the reply the problem is if the mfgdate =2009 and statuscer = scrap then it should come in list when we enter 2009 since it shows the list where it is "OK" or "NOT GOOD" or "scrap" but the same should not come when the mfgdate = 2010 because...

thanks for the reply its showing the data as per the query but i have one more problem that is the date should be the selected from form " mfgdate " and "STATUSCER" field should not contain scrap as field value like if date is >>[Forms]![REPORTFORM]![mfgdate] and statuscer should not be...

I have two tables imtemaster and calibrationcertificate i have joined based on imtenumber field of both tables SQL VIEW SELECT DISTINCTROW IMTEMASTER.IMTENUMBER, CALIBRATIONCERTIFICATE.IMTENUMBER, CALIBRATIONCERTIFICATE.CALDATE, CALIBRATIONCERTIFICATE.STATUSCER, FROM IMTEMASTER LEFT JOIN...

if you open the database open reportform select : p1 qd jan and click the button calibration month status then in the report form Q09427f51 appear twice it should appear only once because for this record in calibration certificate table there are two records in which next cal due...

in the attached database Q09427F51 is repeating twice if i select in reportform plant (p1) shop (qd) month(jan) it should show only jan value (in table calibraiton certificate the next cal due date) should be and if i select plant (p1) shop (qd) month(jul) it should show only jul value