Recent content by whitebear
-
W
Aesthetics of database
Hi I would like the database to look professional, but all of the themes i've seen on access are quite generic and block colour. Can anyone suggest any tips to improve how it looks? Thanks WB -
W
Producing an Invoice
Yeah thats correct. Now i need to create a report which will be the invoice. I need it to calculate all the different prices (job details and order details). Do i need to write any scripting in the query or is this all done via the report? -
W
Producing an Invoice
no, when i leave the field blank. If i put 2 in there it brings up invoice 2, 3 brings up invoice 3 and so on... -
W
Why is this report not generating the data?
thanks thats great. I did feel i was being rapetative in creating many queries. WB -
W
Producing an Invoice
ok, i've added data to the work orders table and removed the calculated values from my work order details. My query now brings up all the invoicez -
W
Producing an Invoice
but i have resolved that using the totals button. Even so, just one tupple of data appears? -
W
Producing an Invoice
no, however when i leave it blank, only one invoice appears over and over again?? -
W
Why is this report not generating the data?
Hi On the "CustomerReport" form, the bottom two combo boxes are not generating the report. It is linked to the query "CustomersViaCustomerName" and have put the scripting into the criteria box under the Last name collum, but the report is blank. Thanks -
W
Producing an Invoice
So for my query i've added "Work Orders", "Order Details" (Which takes stock item prices from "stock Items" table), and "Job Detail" (Which takes employee ID from "Labourers" table, which in turn takes hourly rate from "Labourer rates" table). As they are both have a relationship with "Work... -
W
Producing an Invoice
Yeah thats pretty much it. There will also be forms where the user will input "Labourer Costs" again linked thorugh the Invoice number. -
W
Producing an Invoice
Hi I want to produce an invoice based on a number of tables. The issue im having is that for each invoice there may be several "Order Details". Order details consists of: > Invoice Number > Item Number > Quantity Each item corrosponding to each item number has a price. Theefore how do...