Chat with a LIVE Microsoft Access Expert!
 
       
 

         

   

Go Back   Access World Forums > Microsoft Access Discussion > General

 
 
Chat with a LIVE Microsoft Access Expert!
Reply
 
Thread Tools Rate Thread Display Modes
  #1  
Old 02-17-2010, 06:29 AM
jimd1768 jimd1768 is offline
jimd1768
 
Join Date: May 2007
Location: Ireland
Posts: 58
jimd1768 is on a distinguished road
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
Reply With Quote
Sponsored Links
  #2  
Old 02-18-2010, 01:12 AM
Trevor G Trevor G is offline
Registered User
 
Join Date: Oct 2009
Location: England
Posts: 680
Trevor G will become famous soon enough
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
Reply With Quote
Sponsored Links
Reply

Tags
reports, tables

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

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


All times are GMT -8. The time now is 09:39 AM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2010, Jelsoft Enterprises Ltd.
(c) copyright 2009 Access World