I was wondering if a new Access query can be built to replicate the sample Excel report attached (sheet name: "US"). The working Excel report cannot handle a large number of transactions involved and I am forced to do everything in Access.
My challenge is linking the existing sample Access queries that should give me the same results as I had it in Excel.
Attached, please find the functional Access database and queries all linked with Excel that can give you an idea what I am trying to achieve here. Please let me know if further explanation is needed.
Thank you for all who can help me with this challenge.
Peter
My challenge is linking the existing sample Access queries that should give me the same results as I had it in Excel.
Attached, please find the functional Access database and queries all linked with Excel that can give you an idea what I am trying to achieve here. Please let me know if further explanation is needed.
Thank you for all who can help me with this challenge.
Peter
Last edited:
