Search results

This is magic ! :) It's exactly what I want ! Very smart tip ! Thks a lot :) Guillaume

Hi MStef ! Please find enclosed a short example in Access 2000 (my version). The overall objective is to generate a report of data by month and I need a specific order for both category and data. As you can see in the report "Renta_Crosstab", I have the order I want. The next step is then...

Hello, I need as well to customize the row headings of my crosstab reports but not by category like the Diana post. My idea was to add a letter before the name of each row, ie aDeposits, bOther Securities, cFunds,...and to withdraw it in the report with Mid(data name,2,len(data name)) but I...

how to show data from different queries in a report? Hi, Following my previous post, how can I show data from different queries in a report? Thanks, Guillaume

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

Thanks that's a good idea but it doesn't work for AvgCash. I have the following message : "Subqueries cannot be used in the expression AvgCash" What should I do? Thanks Guillaume

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

Hey, It works perfectly. Thanks a lot Guillaume

Thank you very much it works very well to calculate the monhtly results of June. But what changes are needed in this code to calculate the monthly results of another month, i.e. how can I calculate the Monthly resullts(n) = YTD(n) - YTD(n-1) with n the processing month/year and not the current...

Hi there, Here is my existing SQL syntax : 1. Query Monthly data SELECT [YTD(n) data].[RM code], [YTD(n) data].[Net new cash_YTD]-[YTD(n-1) data].[Net new cash_YTD] AS [Monthly NNC] INNER JOIN [YTD(n-1) data] ON [YTD(n) data].[RM code] = [YTD(n-1) data].[RM code] GROUP BY [YTD(n)...

No this is not a school assignment. I am working on a marketing desk to create a database that performs queries on imported data to follow-up the commercial activity. I have therefore to find a solution to calculate the monthly result by the difference of the YTD results, i.e. Monthly...

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