Search results

Ok folks! I am really close now! :) The following crosstab query gives me what I need but for all years - how can I make it select only the chosen year?? TRANSFORM First(qryCompleteList.RevenueValue) AS FirstOfRevenueValue SELECT Year([MonthEnding]) AS STYear, qryCompleteList.RevenueCategory...

I am sorry folks but I am having a difficult time with the crosstab. I have the dates listed like this: 31.01.2011 28.02.2011 31.03.2011 30.04.2011 For each month I have RevenueCategory field and RevenueValue field so I need the crosstab to give me the following: Jan Feb Mar ....... Dec...

Thanks to all for your comments! I tackled the first two parts of the problem - I created a main query which basically lists all the data that I needed to access. And then I created 4 queries that use the main query to give me the statistics for (1) CurrentMonth, (2) CurrentMonthLastYear...

Gemma-The-Husky! Thank you once again! It is really strange all the info I get from the net shows to use commas, but in my Access commas are replaced by ';' symbol. Not sure why? JANRs recommendation worked perfectly to solve the Month problem. Now I will experiment this with the rest of the...

JANR thank you! It worked! :) I have 'grouped' the field so it only shows one time each month. Now to experiment with the rest of the queries.

Just an update to understand the issue with the Month/Date fields: Assuming that I have a Short-Date field in the table that stores the Month-Ending date (i.e. 31.01.2011): I have created a form which has a combo that points to the existing Month-Ending dates in the table that I mentioned...

Gemma-The-Husky! Thank you! I am working on this right now - but just a related question - how would you advise I create and use the Month/Date fields? In Table One - should I create it as a 'Date Ending' field so that for the month of January 2011 the user inserts 31.01.2011 ? And then on...

Hiya folks! Heres the problem - would appreciate any help: I have three tables related in a one-to-many relationship: TABLE ONE: StatisticPeriod TABLE TWO: StatisticProperty TABLE THREE: StatisticRevenue Table One is where I insert the Month and Year. Table Two is where I insert the Property...