Search results

  1. H

    repeated entries in report

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

    control source

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

    delivery notes/invoice tables

    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?
  4. H

    setting up a stock table?

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

    franchisee setup tables

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