Search results

  1. G

    How to group data per month in one page without repeating these data for each column?

    How to show data from different queries in a report? With subreports? Hi there, My objective is to create this simple report : January ... June Sales ... Revenues I created a query to calculate these data for each month. I want to show it in columns in my report and I have difficulty to...
  2. G

    Average of records in a field

    Hi there, I have a the following table : Cash Date 1000 December -2000 January . . 3000 Current month I want a query with the date of the current month and the average of the Cash field from Dec to the current month. It works with the Avg aggregate...
  3. G

    How to construct a subquery to make the difference between queries?

    Hi everybody ! I am new with Access and I hope I can find some help here with my issue. I have 3 queries : 1. One to select data from the current month 2. One to select data from the current month - 1 3. One to make the difference between these 2 queries/tables I have to insert the last...
Back
Top Bottom