Search results

where should i write this code at ? i got a button , i write it behind the button ?? sorry im quite new to MS Access, btw if i wanna it to export already and open the excel workbook when the button clicked , what code should i write ?

i have three Queries and i need to export three queries into one workbook but different worksheet , i google it and i cant find an answer :( currently im using ExportWithFormatting , but the result came out is three different workbook . is there anyway i can export to one workbook ...

in value the excel value is same as access , but in time it doesnt

this is the Extracted Excel

Actually what im doing is , i need to calculate the hours difference within the same date or some are different date. So i wrote this in Query Field and in the Criteria then i force change the Format to "Short Time"

Actually what im doing is , i need to calculate the hours difference within the same date or some are different date. So i wrote this in Query Field and in the Criteria then i change the Format to "Short Time"

I recreated but still the same problem ....

Result is still the same .....

Version 2010 ExportwithFormatting in MS Access Macro

i Tried to change the Time column to "time" but it doesnt work :/.....

The time difference in access query works very fine in 18:00 (Short Time) format , but when i export to excel it came out with "########" and the value is -0.14679132479 how to solve this problem , i keep trying but it doesnt work :( PLEASE HELP ME >< Thanks a LOT:)

previous post a reply for you :D , thanks a lot :)

after i read the website i wrote this in one field and i wrote this in the next field when i tick show for the Time field the result will come out , if i untick it , it will need me to "Enter parameter value for Time" , how come it will happen ? where goes wrong ?? and for the Time field...

All return 00:00 ....

It doesnt work , pop out with "The expression you entered contains invalid syntax" i change the Query field code from "," to ";" but it pop out with that msg :(

The Data type for [Up Time] and [Down Time] is "Date/Time"

ID Up Time Down Time John 18:00 15:00 Kelvin 08:00 08:05 Melisa 23:00 02:00 This is the Table , i need the Query result show IF [Up Time]-[Down Time] is >=3 hrs Like Below : ID Up Time Down Time John 18:00 15:00 Melisa 23:00 02:00 IDUp TimeDown TimeJohn18:0015:00Melisa23:0002:00...