Report design Access 2010 / 2007

5 pts.
Tags:
Microsoft Access
Microsoft Access 2007
Report format

I do not know how to design a report that will display the data the way I need. It is hard to describe here, but I will try with a simple example.

Each record is based on a date. On each date there are entries to 0-200 accounts for various $$ amounts.

IE: on 1/1/12. acct 120100 for $5, acct 120202 for $10; on 1/3/12 acct 120100 for $50; acct 120202 for $1, acct 120700 for $100, etc. The number of accounts per day can vary. The report I need would list the date down the left of the page and the account number (a-z) across the top for a date range specified (ie 1/1/12 to 1/10/12). Only the accounts that have activity on any of the dates in the query would display along the top (showing blank or zero for the account amount on the dates for which there is no activity on that account.) I am not concerned with how wide this could make the report (it is not printed out). I am using ACCESS 2007 /2010



Software/Hardware used:
Windows XP MS Office 2010 Access 2007

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following