Recent content by homer.favenir

hi to all, can anyone please tell me how to split 1 column and sort it by splitted column. i have 1 table with address column. The address column contains strt # and strt name. e.g. ADDRESS 123 main st. 123 10th avenue. because i need to sort first the strt name before the strt # and...

hi to all, can anyone please tell me how to split 1 column and sort it by splitted column. i have 1 table with address column. The address column contains strt # and strt name. e.g. ADDRESS 123 main st. 123 10th avenue. because i need to sort first the strt name before the strt # and...

156976 != 00156976 great!thanks!!! anyway, i have a followup question. how about if both columns is different e.g. table1.column1 = 156976 and table2.column1 = 00156976 how can i match this two columns? 156976 is different from 00156976 can i use wildcards so that all 156976 = 00156976...

hi, i have a problem... the query is if table1.column1 = table2.column1 and table1.column2 = table2.column2,delete. only column1 and column2 of both tables should match and delete the records. the query above is for all columns. correction for the query above? thanks

could not delete from table delete table1.* from table1 inner join table2 ON table1.artid = table2.artid where (((table1.artid) = table2.artid)) the error is: could not delete from specified table. i cant see my error here....:D

is it okey if the table2 is from mysql?

i have a table1 in my msaccess and i linked another table in mysql to ms access, (table2). when table1 matches the record in table2, it will delete the record in table1. my query is delete * FROM Table1 where table1.artid = table2.artid; but it always ask me the value of tbl2.artid, the value...

i have two running Total Fields Sum of Total Keyed and Sum of TOtal MBD how can i add them? thanks :confused:

how can i make a crystal report with mysql? how can i connect them? any help would be appreciated.

thanks ajetrumpet for the reply!!! ill figure that out. thanks again

thank you very much john!!! it helps me a lot and solve my problem... thanks!!! homer

when i exported to excel the data changes. e.g. the batch range is 1-20 and the time is 23:00 but when i exported it it becomes a different figure. is my report has the problem? thanks :confused:

when i export the data to excel the "Answer" becomes decimal and not time. i already change the properties of the "Answer" in the report, but it didnt work. what should i do? tnx

kewl!!! thanks again!!!

thanks John A!!! thank you very much! your good! how did you get that? can you please explain me. you added another field in query "answer", right? and how can i add it on my report? should i add a text box and copy the formula from the form? thanks a lot again. homer