Search results

  1. Y

    MS Access 2010 export queries into one workbook but different worksheet

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

    Negative Time values when export Access Query to Excel

    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:)
  3. Y

    Calculate Time Different and Show Result under Certain Criteria in Query

    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...
Back
Top Bottom