Search results

Thanks Guus. This did work but the query took an extremely long time to load and was freezing the program. A crosstab won't work for me because I want to put in growth % next to each month. I think this type of report is better served by Excel.. unless anyone has a different idea?

So I am trying to get the sum of all "scriptamount" for each "practice" for the previous month in one field, and then add two more fields. One for 2 months ago and then one for 3 months ago. This will allow me to see the growth for each "practice" over the past 3 months. However, I am stuck on...

Thanks for your help. The switch function will be a helpful replacement for the IF function. However, I don't have an answer to my original question. Can I reference a calculated field in a totals query? I have a field named Invoice set to "group by" to consolidate all my invoices from my...

Thanks for the continued help. Now I realize that the reason I am having this problem is because I am trying to do this in a totals query. I have a field named Invoice set to "group by" to consolidate all my invoices from my invoicedetails table. I have a field named amount...

Thanks for the reply John. My question is can you add an additional field that uses the volume calculation. For example, to get half of the the volume can you create a calculated field: Half volume: [volume]*.5

I am an experienced Excel user trying to learn the ins and out of Access. One road block I am hitting is when I am trying to write an expression in a Query (or form) that needs to reference another calculated field in that same query. Thanks in advance for the help.