Recent content by Sridharanmb

THx...but if i change period then again i need to great a another QUery? example if i change the period in the first query to 02(2018-02 vs 2019-02), then how can i create dynamic second query?

Hi I have created a query and output is like this Merchant ID Merc. Name 2019-01 2018-01 100700000005 XXXXX 88.16 1000 I have attached query design view, i would like to have the result between two periods

Thx...but how we can do that...really i don't have knowledge on the access. just now starting understanding

I Have Table 1. YYYY_MM (2018 and 2019) 2. Merchant ID 3. Merchant Name 4. Sales Value Revenue based on the above i have created query by providing the enter parameter for Period, i get the report but i would like to have the query in below format ID Name 2018-01 201901...

Hi All I am Sridharan, working as Financial controller based in Netherlands. I joined the forum to learn more about access so that i can use the tool for reporting purposes.