Search results

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

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

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

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

Thank you. Basic error on the = 11 (doh) The validation has now been deleted, don't know why it wouldn't before. Sorry to take up time.

Hope someone can assist. I have created my table. My validation rules are obviously wrong. I set the field size for phone numbers as 11 and set the validation rule to: =11 Whenever I enter 11 characters it gives my validation text. I can't delete the validation rule. Do I have to start...

Perfect. Thank you so much

This doesn't seem to work either. Not sure if I am doing exactly what you say.

I have tried that and all boxes still resize. Any other assistance would be great. Thanks

This is an incredibly basic question, so apologies in advance. I have my form in design view. I want to resize all input field boxes individually. When I try, all boxes are resized. Can someone help me with this please. I am using 2007. Thank you in advance.

I am currently running a billing system in Excel. That was ok when I sent out 45 invoices per month. I now do 600+ and thought Access might be easier. I have a table with all my customers details. I want to be able to generate their invoices each month with a default value of £25. I also...

I am trying to find a simple inventory database. The ones on Microsoft templates are too detailed and have no price per item. Can someone help me with this please.

I know this is probably very simple but I do not know how to do it. I have: Table 1 - customers Table 2 - Orders At the moment, when a customer orders 2 items, I have to create 2 seperate order numbers. I would like to have both items under one order number. Can anyone help with an easy...

I have asked this before but could not work out the answer i got(sorry). I need things in very simple terms. I hope someone can assist me. I have customer table and an order table. Customer table obviously holds all customer info. my problem is orders. I would like a table/form that allows me...

Thank you all very much

i have both 2000 & 2003 How do i set a subform. Sorry for being so uneducated in access. This is my first attempt

I have asked this question before but cannot put the answer into practice. I currently have 2 tables: tbl 1 - customers customer ID Customer Address etc tbl 2 - Orders Order ID Customer ID Item Quantity Size Price Postage Total Currently if customer x orders 3 items,I have 3 order numbers...

Thank you very much.

Thanks Thanks for the advice but i need to clarify (sorry for being a pain): table 1: Order No Customer ID Items ordered Qty Cost etc Table 2: Product ID Product Cost VAT Total Is this what you mean? Thanks again

I am new to access and have a form set for processing orders. How do I process multiple orders i.e a customer orders an onion and a pepper. Currently I have to create 2 orders and would like 1 order with 2 items. I am sure this is very simple. Hope someone can help