Report Examples

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

chickalina - 19 Dec 2006 01:43 GMT

Does anyone have an example of a query & report that is user defined monetary
amounts calculating current quarter and also previous quarters as a total?
(showing all records and not listing each quarter separately)
I really need help... I created a db and this is the only hold up to
completion.

Reply to this Message

Duane Hookom - 19 Dec 2006 04:11 GMT

If you really need help, you should provide some table/record source
structure and possibly sample records with desired display in your report.
I'm not sure what you mean by "user defined monetary amounts".

Signature

Duane Hookom
Microsoft Access MVP

> Does anyone have an example of a query & report that is user defined monetary
> amounts calculating current quarter and also previous quarters as a total?
> (showing all records and not listing each quarter separately)
> I really need help... I created a db and this is the only hold up to
> completion.

Reply to this Message

chickalina - 19 Dec 2006 04:28 GMT

OK Here goes:
Thanks in advance!

tbl_Issues
IssueID
IssueDescription
IssueType

tbl_ReserveSchedule
IssueID (dual Primary key with Change Date)
ChangeDate
TaxAccrual - this is a number
TaxAccrual - this is a number
TaxInterest - number
(18 fields all together)

qry_Issues_Log_Reserve1
IssueID
IssueDescription
TaxPeriod
ChangeDate
Quarter: using Format [ChangeDate] for qyyyy in the Field: with [Enter Date]
for user prompt to enter quarter they want to run the report for
TAXACC - IIF statement to account for Nulls
TaxInterest - number
TAXINT - IIF
(incidentally there are 28 fields plus their IIF statements)
TAXTTOTAL: to total up all the tax
INTTOTAL: to total up all the Interest

What I want the report to look like

Country
PriorBalance Quarter Selected Info
QtrTOT
Tax Interest TaxAcc TaxInt OtherTax OtherInt TotTax
TotaInt TOTAL
Issue 1 2 1 1 1 1
2 2 11
Issue 2 1 1 1 1 1
1 1 9
Cntry 3 3 2 2 2 2
3 3 20

I couldnt' fit one more column, but there would be the previous balance +
the current quarter for the Actual Balance
Then the report would total at the end for a grand total of everything.

> If you really need help, you should provide some table/record source
> structure and possibly sample records with desired display in your report.
[quoted text clipped - 6 lines]
> > I really need help... I created a db and this is the only hold up to
> > completion.

Reply to this Message

Duane Hookom - 19 Dec 2006 05:45 GMT

Sorry, this is just too much for me to digest. In addition to issues with
wrapping, you seem to have 2 fields in a table with the same name.

Can you narrow your question down to a single (or maybe two) small issues
that might provide a method to resolve the remainder of your issues?

Signature

Duane Hookom
Microsoft Access MVP

> OK Here goes:
> Thanks in advance!
[quoted text clipped - 54 lines]
> > > I really need help... I created a db and this is the only hold up to
> > > completion.

Reply to this Message

chickalina - 19 Dec 2006 05:59 GMT

Here's a smaller version

Country
prvbal curbal
tax int 1tax 1int 2tax 2int txtot inttol currtot
actbal
issue1 1 1 1 1 1 1 2 2 4
6
issue2 2 2 2 2 2 2 2 2 12
16
country 3 3 3 3 3 3 3 3 16
24

> Sorry, this is just too much for me to digest. In addition to issues with
> wrapping, you seem to have 2 fields in a table with the same name.
[quoted text clipped - 60 lines]
> > > > I really need help... I created a db and this is the only hold up to
> > > > completion.

Reply to this Message