Recent content by atzdgreat

  1. A

    Join expression not supported in join query Access

    Hi @plog and @The_Doc_Man thank you for reply. so this is a sample of my raw data KPI_qryMain KPICodeKPICode1KPITaskChildKPICodeChildKPICode1 SRSMRT01SRSMRT01Washing PlatesSRSMRT02SRSMRT02 SRSMRT02SRSMRT02Cleaning Bedroom SRSMRT03SRSMRT03Laundry KPI...
  2. A

    Join expression not supported in join query Access

    i tried to change the my query to LEFT JOIN KPI AS t3 ON (t3.UserID = t1.UserID) AND (t3.KPICode = t1.KPICode)) but still gets the same error. the specified field 't1.UserID' could refer to more thn one table. @Eugene-LS thank you for your reply. i'm not sure how the query outputs 'UserID'...
  3. A

    Join expression not supported in join query Access

    HI @MajP thank you for your reply. i'm not quite sure but i already specify the table which is KPI_qryMain as t0.
  4. A

    Join expression not supported in join query Access

    Hi i would like to ask for your assistance why i'm getting error. "JOIN expression not supported." Code: SELECT t2.KPICode1 AS OrigCode, t0.KPITask AS OrigTask, t2.ID AS TimID, t2.Score AS OrigScore, t3.ID AS AccID, t3.Score AS DepScore, t1.KPICode AS DepCode...
  5. A

    Pivot Query cant get the correct result

    Hi all im trying to achieve the below result with my pivot query but it seems not correct. TO ACHIEVE: KPIScore UserID KPICode July 2024 June 2024 $4.50 XXX000035 FRACRT04 $4.00 $5.00 $0.00 XXX000172 FSACRT01 $0.00 $0.00 $0.00 XXX000172 FSACRT07 $0.00 $0.00 CODE: TRANSFORM...
  6. A

    Filter Properties cannot be empty.

    yes you are right. i dont know the reason why it doesnt delete the filter at runtime.
  7. A

    Filter Properties cannot be empty.

    Hi everyone. have you ever encountered that your filter properties in continuous form cannot be empty even though you already created code to empty filter. i experienced this when my form encountered error and the last query will automatically saved in filter properties. Private Sub Form_Load()...
  8. A

    How to have sub total and grandtotal of Pivoted SQL Query

    thank you @Pat Hartman
  9. A

    How to have sub total and grandtotal of Pivoted SQL Query

    hi @theDBguy and @Pat Hartman. thank you for your reply. header will be the cost center that has been pivot. meaning there's no specific columns for this. depends on user's search. i already got the pivot table of cost centers. knowledge has been learned from other sources. what i want to do...
  10. A

    How to have sub total and grandtotal of Pivoted SQL Query

    TO ACHIEVE: Dept = total amt of cost center per dept Div = total amt of department per division BU = total amt of Div per BU TABLE: BU Div Dept CostCenter Amt Corporate Finance Financial Control XXFC0101 1,500.00 Corporate Finance Financial Control XXFC0102 1,000.00 Corporate Finance...
  11. A

    Solved Code not save when at runtime

    Hi all thank you for your replys and comments.
  12. A

    opening builtin attachments dialog box in access

    Hi All, good day. may i know if possible to open attachment dialog box using command button? something like this: Private Sub BtnAttach_Click() Attachment.Open End Sub
  13. A

    Solved Code not save when at runtime

    hi thank you for your reply. Yes @The_Doc_Man you're right when i implement a code fix then switching to view mode and then close the form, all the code changes are not saving. so currently what i'm doing right now is to close my access and recode before switching to view mode
  14. A

    Solved Code not save when at runtime

    Hi all does anyone experience about losing their codes even though it was already saved once the form runs or even close. it's like once closing the form, its doing undo.
  15. A

    Listview will becomes empty when i disable it

    no worries. thank you.. by the way maybe you can help me out how can i change the fore color of the specific row in listbox?
See more
Back
Top Bottom