Exporting query results to excel

  • Thread starter SHAWTY721 via AccessMonster.com
  • Start date
S

SHAWTY721 via AccessMonster.com

Okay I have a database that contains records of billing information. I have
created the queries I need to display the information but my issue is, is
there a way to take the total values that are being produced from the query
and separating them depending on amount for instance 0-30, 30-60, 60-90, …
690-720, 720+. I am just wondering is there a easier way than doing this by
hand since there are tons of records for each of the billing methods which
the information is being separated by.
 
S

strive4peace

you can use calculated fields:

D0_30: IIF([DaysDue_fieldname] >=0 and [DaysDue_fieldname] <30,
[Amount_fieldname],0)

D30_60: IIF([DaysDue_fieldname] >=30 and [DaysDue_fieldname] <60,
[Amount_fieldname],0)

etc

WHERE

[DaysDue_fieldname] is the fieldname for your days past due. This can
also be a calculation -- for instance:
Date() - [DateDue_fieldname]

[Amount_fieldname] is the fieldname for the amount

D0_30, D30_60, ... are the names of the columns for your calculated
fields; fieldnames should not start with a number so put a letter in
front of the range


Warm Regards,
Crystal

Access Basics
8-part free tutorial that covers essentials in Access
http://www.accessmvp.com/Strive4Peace/Index.htm

*
:) have an awesome day :)
*
 
Top