Search results

  1. J

    Not sure where to go next

    I have started a DB for a dance school. I have 4 tables and I have created the relationships I thought I needed. I am not getting what I want and hope that someone can guide me on the next steps. 1. I want to have a form that allows me to enter customer details 2. From these details, I want to...
  2. J

    How to expand current DB

    I have a database for a dance school that holds all customer info. I would like to try and add to this a payments section. Each person is billed £20 per month and what I would like to do is have £20 added to each persons bill at the beginning of each month and somewhere where I can enter...
  3. J

    Creating an Invoice

    I have asked this question a few times but I don't think I have explained myself properly. I have an order management database to enter all customer details and orders. I want to produce an invoice for each order, For example: Customer A orders, 2 cups & 1 brush. I want to show an invoice for...
  4. J

    Creating an Invoice with Order Management

    I am using the Order Management database in Access 2007. I have tried to create an invoice but to no avail. I would greatly appreciate help. The problems I have are that either all data appears in lines: 1 customer orders 3 items, the invoice shows 3 items with the customers name 3 times or Not...
  5. J

    Helping with a Query

    I have a query that shows customer orders. I have a check box to show if a customer has paid or the balance is still outstanding. I want to show in the query just the orders that are outstanding (haven't been paid) I am unsure of how to set this criteria in a query. Any help would be...
  6. J

    Creating an Invoice

    I am trying to generate an invoice for each customer order. I have created a query with all the information required. I am now trying to transfer that information into a report. The problem I have: When I create the report, it shows all customer orders. I realise I have to modify the design...
  7. J

    Name Query

    I am sorry this is such a basic question but I am stuck and require your expertise. I have 2 fields for customers: FirstName LastName I was trying to run a query that will give me the full name. Instead of having: John Smith I would like: John Smith I hope this makes sense. Thank you...
  8. J

    Creating an Invoice

    I would like to create an invoice for the orders in a database. I have tried but failed miserably to get a report that shows all items on the order form. I have attached the sheet I am getting info from to try to get the invoice. The details I am want are: Customers: Customer ID, Name...
  9. J

    Form Help

    I have a form that adds customer details. In the billing address it will not allow me to input anything. Nothing types at all. Does anyone have any posible solution for this. I have attached a picture to demonstrate Thank you
  10. J

    Order DB Help

    I am trying to build an orders database and I am using the access template as a guide. I hope someone can help with this query. It has "Extended price" in the orders subform. Firstly what is Extended price? This is what populates the Order Subtotal. I tried to put a calculation in there...
  11. J

    Calculation Query

    I have an inventory database and I would like to run a query that shows the value of stock I hold. I have not added the cost per item in the database. This is what I have: Item Current Stock level I now want to add: Cost of Item Total Value of Stock (Current Stock * Cost) Because I don't...
  12. J

    Question Orders Database

    I would like to build a very simple customer orders database. I have looked for examples of this and can't find one. If anyone can point me in the direction of a sample, it would be greatly appreciated. I think I need 4 tables: Customers Products OrderDetails Payment I am not sure which...
  13. J

    Form Design Help

    I have a datasheet that I want to include on a form. I would like the form to look like the datasheet and not just single entries. I have attached a sample from Northwind to explain how I would like the form to look. If anyone can offer any help I would be greatly appreciative. Thank you
  14. J

    Calculating a total

    I know there is probably a very simple solution, but I do require some help from the experts please. I want to add the 2 amounts in columns feesdue and feesoutstanding to give a total in "total". All help is greatly appreciated. I have attached a screenshot to show what I mean. Thanks
  15. J

    Report Help

    I have a DB with 150 customers. I would like to print a report each month that acts as their invoice. I am looking to get 2 customers details per page in the following format: CustID: 15 Month: Apr 10 Name Surname: John Smith AmountDue: £7.50 AmountOutstanding: £5.00 Total: £12.50...
  16. J

    Report Total

    I have 3 columns in my Report: AmountDue AmountOutstanding Total I have put in a Sum for the first 2 columns but it won't let me do the same for the Total column. I want to either have a total of the total column or add the totals of AmountDue + AmountOutstanding. Thank you in advance. I...
  17. J

    Calculating Total

    Please excuse this very simplistic question but I cannot work out what to do. I have a datasheet that has the fields: Amount Due Amount Overdue Total All I want to do is have the Total field adding the 2 amount fields. Any help would be greatly appreciated. Thank you
  18. J

    Calculating Total

    Please excuse this very simplistic question but I cannot work out what to do. I have a datasheet that has the fields: Amount Due Amount Overdue Total All I want to do is have the Total field adding the 2 amount fields. Any help would be greatly appreciated. Thank you
  19. J

    Importing Data

    I am trying to import data from excel. All the data imports perfectly, except the previous Customer ID autonumber is imported as a number and I cannot change it. Does anyone know if there is a simle solution to this problem. Thanks in advance
  20. J

    Question 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...
Back
Top Bottom