Recent content by jimd1768

I have got a few steps further. Thank you. I may need to post for more help. Thank you for your help

Thank you Ridders. I have spent so long on this, I can't seem to get the basics right. This example is a shortened version of customer details. I have all the details of parents and children. That table is fine. My issues really come when I try to do the payments. If I give you an example: a...

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...

Ranman256, Are these the only 3 tables you have?

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...

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...

Thank you Trevor. I will work through your directions and see what I can come up with. Jim

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...

Thank you very much for your help.

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...

Thank you for the response. This doesn't work on the report but does work on the query. The report still gives me a list of that customers orders and not individual orders. Example: Cust1 has 2 orders - Order1 & Order6 The report is showing both orders insted of 1 order per report

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...

Thank you very much. Sorry for such a simple question. Greatly appreciated

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...

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...