| Chat with a LIVE Microsoft
Access Expert! |
||||
|
||||
|
#1
|
|||
|
|||
|
Help me to resolve a problem
I have a table with customer details.
I want to produce a bill every month to the customer. It is a standard £5 fee but can vary. I will also have to be able to add any outstanding payments to give a new total. How do I produce the bills each month from the customer details. Thanks for any assistance |
| Sponsored Links |
|
#2
|
|||
|
|||
|
Re: Help me to resolve a problem
You would need to use a query to do this, you can create an expression to add the £5 or percentage to the payment field and also set an expression to determine the month.
Then create a report (If printing) to use the query where you can specify which month to run off. Trevor |
| Sponsored Links |
![]() |
| Tags |
| reports, tables |
| Thread Tools | |
| Display Modes | Rate This Thread |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Check-in/Check-out problem and afterupdate problem | AccessInitiate | Forms | 2 | 04-09-2009 05:43 AM |
| network image print report problem | Davros | Forms | 7 | 02-26-2008 11:02 PM |
| merging and shift-bypassing problem | TjS | Modules & VBA | 4 | 10-18-2007 03:30 AM |
| conversion problem | marc01 | General | 1 | 01-01-2007 02:58 AM |
| Math Problem.. | mission2java_78 | General | 3 | 08-28-2002 10:24 AM |