Recent content by HelpNeeded

thanks for all the advice, I got it to do what I needed in the end. BUt had to have two seperate queries, one to give me current month total sales. the other two give me previous month sales and then in the form i just minus one from the other. it works fine, and gives me a little more...

Hi the only problem is that the results for the prevmonth doesnt give me the sum of the sale for the previous month

Hi, I did that using the first way you suggested MOnth sum of sales PrevMonth 9 100 10 75 11 50 BUt the results give this with nothing in the prevmonth what am I doing wrong to two bits...

Hi thanks for the prompt response. I can do the first part of what you say so I have Sum of Sales Month £30,000 10 £29,000 9 But for the second part, how do I put month 9 in one field and month 10 in another field?

I have a database which holds sales data. Date of Sale Sale Price I want to do is create a report that allows meto enter a select a month and the results would show the a sum of the month selected minue a sum of the previous month so for example it go like this...I select Oct-09 The report...