Search results

i have built a report on top of a query. the query is on customer orders with the criteria "customer no". when i run the query the results are fine, but when i run the report based on it, it repeats al the listings several times. is it the way the report is formed or something else?. I have...

the calaculationa are done in the form using the expression builder. all i want is the results to show in my invoice table. i know it is because in the properties the control source does not show as the relevant field, but as the calculation eg =[Subtotal]*0.175

how is that done?

i have created an invoice form based on my tblInvoice. the fields include subtotal, vat, total in both the table and the form. to get the form to calculate vat and subsequently the total, i built the expression in the properties of the two fields. therefore the problem is that their control...

this is what i have got so far. could somebody please give me a critical review, bearing in mind i am not a db expert but somebody who is on a very steep learning curve with all your collective help. For this I thank you all in advance. At this stage I am not sure of my success so far and if it...

so does this mean i create the DN via a query on the order? and if so is the invoice created via a likewise query?

to give a background, this is for a suit hire company. the suits are hired out through a franchisee, who is then invoiced for the suit. so the flow is 1. the customer places order with franchisee 2. the franchisee forwards the order to the hire company 3. the order is delivered to franchisee...

this is for entering data for a customer who is serviced through a franchisee. basic flow diagram would be customer------franchisee-----orderheader-----orderdetail-----measurementheader-----measurementdetail. the repeating fields would be CustomerID and FranchiseeID. both become foreign keys...

I have a series of tables: Customer,OrderHeader, OrderDetails, MeasurementHeader,MeasurementDetails,InvoiceHeader, InvoiceDetails. is there any way (apart from update query) by which data entered into say the customer table will update the same fields in the other tables (eg customer no)...

While you are here, is there anyway to get subdata sheets to update fields from the previous parent/child, to save having to repeat data input?

I will try that

i would like to link the delivery note table to the invoice table so that each delivery note will automatically create an invoice. how can i do this?

thnx I will do that

i have a db in development, but it will have a starting stock which will be rented out and returned. i know the calculation is by query, but there would need to be a record of an opening stock from which the calculations will be done. where do i place the opening stock? here is the original...

Hi again here is the revised version if this seems ok, i would like to build the queries and the forms. thx again your advice has been invaluable Harps

try this please

i have the tables done to what i hope are the correct fields and built the relationships, unfortunately the file is too big to attach

Thanks for your time all this is extremely useful. I think what I am trying to get at here regarding stock is where would I keep my opening stock against which all hire and returns are set against. This would be a useful tool to know when i have reached a low stock level so there can be no...

on tblorders the stock items are listed in a drop down list from which the person placing the order selects the required one. each one has an individual name. are these lifted from the stock table? For measurements, there is a lookup there also for all measurements available. Do I keep those...

i am trying to set up a database to record details of a suit rental hire franchise. I am a bit of a novice but the tables i have constructed so far are as follows: tblcustomer customerno (pk) title forename surname address 1 address 2 address 3 address 4 postcode telephone tblorders...