Duplicates in report
Hi All,
I need some help with a report.
My budget in the database has three levels. Main Heading 1 Account 1.1 Item 1.1.1 etc
From the Dbase, I am supposed to run four reports quarterly.
One a detail of all transactions by item, account and main heading
One a total expense by Main heading
One summary expense by all levels showing previous and current expenses with balances.
The fourth is a detail of previous and current expenses. This is where I am having problems, as it duplicates data.
I would be grateful for your assistance.
Thanks
This is is a small sample of the report I did in excel, as when I try to run in access it duplicate the data.
Title Budget Previous records Current record Sum total of records Available balance 2 OPEREXPENSES 2.1 Supplies Scotia Bank €3.94 Christopher Williams €1,850.87 People's Store €117.43 The Stationery House €1,234.41 €5,000.00 €1,854.81 €1,351.84 €3,206.65 €1,793.35 2.2 Office space Adrian Escalante €2,776.31 Adrian Escalante €925.44 Adrian Escalante €925.44 Adrian Escalante €925.44 €6,000.00 €3,701.75 €1,850.87 €5,552.62 €447.38 2.8 Bank Charges Atlantic Bank €2.78 Scotia Bank €4.07 Scotia Bank €14.34 Scotia Bank €4.53 Scotia Bank €0.28 Scotia Bank €4.07 €500.00 €21.19 €8.88 €30.07 €0.00 €11,500.00 €5,577.75 €3,211.59 €8,789.34 €2,240.73
el
Good day,
Yesterday I posted a thread asking for help with a report.. Maybe I did not explain the problem properly.
I have a database with accounting info. A budget with three levels. Main heading, accounting heading, and Item Code.
I need to run four reports quartely. Three I am able to do.
1 - A report with summary expenses by Main heading
2 - A summary of expenses By Main Heading, Accounting, and Item code
3 - A summary of expenses as in #2, but showing previous and current quarter expenses seperately. with budget allocated and a balance eg
Budget Previous Current Balance % spent
4. Report as above but showing detail expenses.
What I did was at the end of a reporting period, copy the data in a seperate table. So I am able to run summary data from both tables. But when I try running the detail I get duplication of data.
Grateful for some assistance
PS I dont know any SQL or VBA I just work with queries etc in Access
Cristina
Hi All,
I need some help with a report.
My budget in the database has three levels. Main Heading 1 Account 1.1 Item 1.1.1 etc
From the Dbase, I am supposed to run four reports quarterly.
One a detail of all transactions by item, account and main heading
One a total expense by Main heading
One summary expense by all levels showing previous and current expenses with balances.
The fourth is a detail of previous and current expenses. This is where I am having problems, as it duplicates data.
I would be grateful for your assistance.
Thanks
This is is a small sample of the report I did in excel, as when I try to run in access it duplicate the data.
Title Budget Previous records Current record Sum total of records Available balance 2 OPEREXPENSES 2.1 Supplies Scotia Bank €3.94 Christopher Williams €1,850.87 People's Store €117.43 The Stationery House €1,234.41 €5,000.00 €1,854.81 €1,351.84 €3,206.65 €1,793.35 2.2 Office space Adrian Escalante €2,776.31 Adrian Escalante €925.44 Adrian Escalante €925.44 Adrian Escalante €925.44 €6,000.00 €3,701.75 €1,850.87 €5,552.62 €447.38 2.8 Bank Charges Atlantic Bank €2.78 Scotia Bank €4.07 Scotia Bank €14.34 Scotia Bank €4.53 Scotia Bank €0.28 Scotia Bank €4.07 €500.00 €21.19 €8.88 €30.07 €0.00 €11,500.00 €5,577.75 €3,211.59 €8,789.34 €2,240.73
el
Good day,
Yesterday I posted a thread asking for help with a report.. Maybe I did not explain the problem properly.
I have a database with accounting info. A budget with three levels. Main heading, accounting heading, and Item Code.
I need to run four reports quartely. Three I am able to do.
1 - A report with summary expenses by Main heading
2 - A summary of expenses By Main Heading, Accounting, and Item code
3 - A summary of expenses as in #2, but showing previous and current quarter expenses seperately. with budget allocated and a balance eg
Budget Previous Current Balance % spent
4. Report as above but showing detail expenses.
What I did was at the end of a reporting period, copy the data in a seperate table. So I am able to run summary data from both tables. But when I try running the detail I get duplication of data.
Grateful for some assistance
PS I dont know any SQL or VBA I just work with queries etc in Access
Cristina
Last edited by a moderator: