Need to create different files based on subtotal

  • Thread starter Thread starter emily.knick
  • Start date Start date
E

emily.knick

I need to create separate Microsoft Excel files with the data from a
query if the subtotal for a group goes over a certain amount.

For example, I have the following data:

Group Price
A $100
B $200
C $300
A $200
A $400
B $900
D $100

I'd like to output the A group to one report because their total
exceed my threshold of $500. I'd like to output the B group to
another report because it exceeds $500. Finally, I'd like one report
for C and D combined because neither group exceeds $500 (total can be
whatever it needs to be as long as the individual group doesn't exceed
$500). I need to export each line item to the MS Excel file.

I think I need some sort of loop, but I don't know.....
 
Hi Emily,

make a separate query for each of your conditions

you can then use the TransferSpreadsheet action if you want to make new
spreadsheets. If you want to append values to an existing spreadsheet,
it would be best to write code ... depending on how the other values
that are already there got there...

can you explain more about the relationship between your Access and
Excel data?


Warm Regards,
Crystal
remote programming and training

http://www.YouTube.com/user/LearnAccessByCrystal

Access Basics
http://www.AccessMVP.com/strive4peace
free 100-page tutorial that covers essentials in Access

*
(: have an awesome day :)
*
 
Back
Top