Search results

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...

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)...

[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...

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...

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] &...

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)...

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...

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...

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...

i have a query which contains two tables linked with table1 and table2 table1 ( table name ) suppliers( field name ) months( another field name in table1 ) asd101xyz jan asd101xyz jul asd102xyz jan asd103xyz...

i have a form in which i have fieldname [resultnumbers] which is having the data Example : asd100xyz ,asd101xyz ... etc i have inserted a " Microsoft Office Spreadsheet 10.0 " in the same form when the record is " asd100xyz " i should have details for that record in the excel sheet and if...

i have a field name [monthofcal] and it contains data type as text and i store value like jan,feb,mar.... till dec. but the problem is iam not able to retrive this for calculation purpose like this <= Month(Date()) what should be the data type so that its value should be jan,feb,mar...

i have a query which has two fields one is "months" and other is "status" is it possible to get data column wise "months" ( jan,feb,mar....) and row wise "status" ( good, better, best ) these are the months field items months : jan feb mar apr may jun goodsum: 10 5 3 12 16 11 ( sum...

iam using in a query which has field [month] containing jan,feb,mar.... till dec for this [month] field the " data type " in table is " text" because when i open the query name " till this month " i want it to show the month names till current month that is till "oct" and should not show nov...