Search results

OK got that, but wont this only give me one invoice number per delivery i enter what i need is say if i enter 15 deliveries for 1 customer i need 1 invoice number for all the deliveries what i am trying to acheive is simliar to sage

i have got these to link but how do i allocate the invoice number from the invoice table to the deliveries table

hi there these are the same customer not customers with same name i have got it to link customers and deliveries but what do i do in the invoice table and the relationship

i use a form based on a query which call all records that have not been invoiced what i want to do is query these then in the form i have a field that when i enter a number and click on a button it gives all the records below this number in the field invoice no any ideas

hi there thanks for reply i have done my job because i have been using my own database for 5 years its just the annoying part to get a funtion where i can generate invoice numbers as i have to do this manually by entering the details into the invoice table any advice thanks simon

i am trying to create the following database and have not really got a clue this is what i am trying to acheive i have a few customers that send out deliveries on a daily basis which are invoiced each month so each customer will have say about 20 deliveries per month. i want to call these...

it not doing nothing even though i have followed your steps what i want it to do is at the end of the month recall all the jobs for a given customer and store them somehow in the invoice table and give all the jobs 1 invoice number thanks any ideas

i am quite new to this so please go easy on me!!! i have looked at northwind but all looks a bit complicated at the moment right here goes! i am trying to create a database to enter multiple orders on and then print invoices on the program at a later date, these are the fields i am working...

I have been trying to get an answer for this for sometime now with no success any help would be much appreciated. I have tried to solve this with Northwind Database but also with no success. This is what i have: Query with the following fields date, customer, collect from town, delivery...

i am trying to create a form with a left hand frame on ite where i will create a few button commands it will basically be like having a header but vertical on the left hand side of pane any suggestions thanks

is there a way of accessing my database online i.e. i am trying to upload my database online so my customer can access it and enter job / order requests online then the iformation would be sent to us in some form

i am trying to creat an application using access that i can transfer / use on a smart phone using windows mobile any suggestions!!1 thanks simon

I am trying to create an expression of some sort to find values in my postcode file my postcode file consists of postcode like this AB43 3WJ AB1 1RU etc... etc i am trying to when results shown for AB* then i want something where i can put "SCOTLAND" in the all AB* county fields

i have a query that calls all postcodes beginning with AB what i then have is a form that shows these results i want something like a button that when clicked will replace current values in county to "scotland" maybe something like this: If me.county is not like "SCOTLAND" Then me.counuty...

can you give me some idea on this as i am fairly new to this and have never used the dmax funtion thanks

i have a table of invoice numbers and i have a form with a field for invoice numbers what i want to do is get the last or highest invoice number last used from the invoice table by default help!!! many thanks

thanks pbaldy this worked a treat simon

i would like to see this at the bottom of my report 8ft Tables = 3 6ft Tables = 1 10ft Tables = 1

I have a report that will show 3 different text values on a report as below 1st delivery is an 8ft 2nd delivery is an 8ft 3rd delivery is an 6ft 4th delivery is an 10ft What i want is an expression of somesort to count 8ft so this would look like this at the bottom of my report 8ft...

just a simple invoice number like 6543 and then 6544 etc etc... sorry to sound thick but how and where would i use selectmax