Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » ms access training courses in london - Access Advanced

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

ms access training courses in london - Access Advanced

Resolved · Low Priority · Version Standard

Reply Fri 20 Apr 2007, 10:42Delegate Shola said...

Shola has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Excel Intermediate course
Excel Advanced course
Excel VBA Intro Intermediate course
Excel Advanced course

Access Advanced

Im trying to create an Aged Debt Report from a table in Access.

My fields are Customer Number, Invoice Number, Invoice Amount and Invoice Date. A customer would have multiple invoices created on various dates. E.g

Customer Number Invoice Number Invoice Amount Invoice Date
123 Inv454 200 2/1/07
123 Inv455 123 8/2/07
123 Inv456 320 12/3/07
456 Inv457 100 6/2/07
456 Inv458 342 2/3/07
789 Inv459 678 9/1/07

The user will enter a parameter (usually the last day of the month).

SO each cusomer will show in one line only, their current month invoices, invoices outstanding for 30 days and invoices outstanding for 60 days.

I need to create formulas:

1. That will calculate invoices that fall in the current month (pointing to the parameter).

2. That will calculate invoices that fall within 30 days from the invoice date

3. That will calculate invoices that fall within 60 days from the invoice date

If the user entered 31/3/07, the report should look tlike this

Customer Number Current 30 days 60 days
123 320 123 200
456 342 100 0
789 0 0 678

For upcoming training course dates see: Pricing & availability

Reply Mon 30 Apr 2007, 11:02Trainer David said...

RE: Access Advanced

Hi Shola

This is a little over complex for our forum and I suggest that you look into booking one of our trainers to come out and actually help you create this.

Please contact our enquiries team for more information.

Hope this helps
David

Reply Mon 30 Apr 2007, 11:07Delegate Shola said...

RE: Access Advanced

It's OK. I've created the formulas by using the DATEDIFF function and created the report by calculating a sum on the Customer Number group.

Reply Mon 30 Apr 2007, 11:13 Edited on Mon 30 Apr 2007, 11:13Trainer David said...

RE: Access Advanced

Thats good to know.

Access articles

· The Benefits of Certified Microsoft Training in Access
· Three Myths About Microsoft Access
· Supersizing your databases via Microsoft Access
· An Essential Guide To Using The Northwind Database In Access 2010
· How To Use The New Navigation Form In Access 2010

Access tip:

Create own ribbon tab - Access 2010

a. In Access click on the File tab
b. Select Options from left hand side
c. Choose the Customize Ribbon section
d. Click the New Tab button (below the list of tabs on the right hand side of the dialog box)
e. Select the New Tab (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
f. Select the New Group (Custom) and enter a name, by clicking the Rename button (below the list of tabs on the right hand side of the dialog box)
g. Add commands to your tab and group by locating them on the list on the right hand side (remembering that you can change the list using the drop down box at the top of the list of commands) and clicking the Add button between the two panes to add them to your tab and group
h. You can rearrange the commands in your group, the groups on any tab or the tabs, using the up and down arrow buttons beside the list of tabs.
i. Click OK to apply your changes

View all Access hints and tips