Recent content by m.shakeebahmed

build a macro with a DML update Statement... having where clause the row identifier of the equipment. then set the marco on onClick/onEnter event of issue date and return date.

I am presuming you are searching for getstring method for some other class. Have a look at the following link to see spec of getstring of recordset http://msdn2.microsoft.com/en-us/library/ms676975(vs.85).aspx Cheers

Hi members is there any way to list all the tables through sql statement in MS Access.... like in oracle we can use select * from all_tables ?? or select * form cat

yes it possible....for this what my understanding is you need to VBA... populate the records set and with each record, do the calculation and update the third field...

it depened how often you need to run this?? because with VBA it is a straight forward case of having a recordset and add on increment.... however it will not be certatinly the most effeicient solution as you have mentioned it is a heavy populated table....

it would be something like this PARAMETERS inputstr Text ( 255 ); SELECT Table.name FROM Table WHERE (((Table.name) Like '*' & [inputstr] & '*'));

queries -> New query -> design view -> close show table -> right click -> sql view and then paste the query....

yes this can be done with a gropu by query query would be like this SELECT datacode, Count(1) AS number of duplicate, Min(dup_date) AS MinOfdate, Max(dup_date) AS MaxOfdate, (Max(dup_date)-Min(dup_date)) AS Expr2 FROM Table GROUP BY datacode;

yes this can be done with a group by query query would be like this select datacode, count(datacode), min(dup_date) as first_dup_date, max (dup_date) as last_dup_date, (max(dup_date) - min(dup_date) ) daysbtw_first_Last from Table group by datacode

UPDATE dlb_tbl SET dlb_tbl.[type] = 'EDH01-RD00S101' WHERE dlb_tbl.[type] ='0RD00S101' as mentioned by MStel... make sure the length of column "type" is > 15

this require a macro... what my understanding is !! because the source table is in normalized form and that structure of new table is non-normalized. Possible solution is to go with group by and aggregate functions which will only provide the number of duplicate records, without any additional...

SELECT t1.date, Month(t1.date) AS Expr1, month(Now()) AS Expr2 FROM t1 WHERE Month(t1.date) = month(Now())

Brianwarnock !! in simple words..... do you have any better solution than what Jon came forward with ??

smart thinking... thanks Jon

in simple my query looks like SELECT Field1, Field2 from table1 where table1.Field2 in (1,2,3) and now i need to parameterize this query.... I tried with SELECT Field1, Field2 from table1 where table1.Field2 in ([Parameter]) Now the problem is... it is working fine with only one value For...