Hello All,
I have field as a string
2022-07-06 01:54:44.000
2022-06-10 20:43:59.609
1- I want to remove after space ( 01:54:44.000)
2- change the 2022-07-06 to date format
how can I do this in Access query ?
Thank you
Yes access table is populating by almost 60 persons ,.then at the end of month,we transfere it to oracle table for reporting on powerbi.
So I have no choice ...
I have a table in access is the same as table in oracle .
We update oracle tables with this table in access . We want to update oracle table with updated records in access ,not all records be updated . Just those has been changed .
I don't know which records ..
I have a update date trigger to see which records has been updated
If I update all records ,Update date doesn't make sense any more ..
Thank you , I did this update to update table 2 from table 1 when there is a change in fields
but I need just update records was changed .
I added inner join and <> in criteria but ,...
Hello
I have two tables with the same structure and data .
I want to have a query to update only records from table2 from table 1 where changed .
both tables have the same fields
Hello
I've added this line in my macro to ask user to input the date. It repeat two times in my macro .!!
I 've changed it many many times .but ... .I have the same code in another database which comes up one time !
could you help me what is wrong ?( the correct date should be 2022-01-01 ...
I really appropriate that.... yes you were right,I saw that ,Access adds a [ ] for table name in the append query sql ..
my problem solve till here .
thank you very much for all helps .I have to study more about VBA debugging..
Yes you are right........ bracket helped ....
the code is working now .. but I don't know how !!!
I tried to test it by append query and it added a bracket for table name in SQL code !!!
I appropriate all your help and advice ...i have to study more how to debug VBA codes ....
This is the sample database .it seems work here ,but when I add the code to my file which has the same structure tables ,I have a syntax error (3131)????
why ????? same code ,same tables??? I lost ....
I am confused .In Fact , Sval is the name of table which is chosen in a drop list and wants to append its data to a main table .
shouldn't it be a string ? the name of the selected table ?
I have a drop list in my from which shows a list of tables .when user chooses one by clicking append wants to append data to a main table(OSFinal)
sval refers to the name of selected table.