Search results

Thank you for that mate. That is exactly what I was thinking. As in my business (Courier service) anything can happen to the job. Have you any idea how I can go about assigning an invoice number to an invoice then?? I already have a database running that I designed first (i done it to see what...

Hello I want to assign each job done for every customer an Invoice Number. However I am not sure how to go about doing that?? The problem I am having is obviously I don't want duplicates. One invoice number for one invoice each month. However there may be a number of jobs to go on that invoice...

Thank you. Thank you. I really appreciate all of your ideas and help. My boss is getting me SAGE is that any good for invoicing and keeping track??? I am new to this but am willing to learn everything I need to learn about designing databases in access. Thank you for all your ideas. I would...

Well I suppose you are right. How would I go about setting this up then?? See I invoice some customers weekly but the majority monthly by the end of the month I have obviously done different jobs for each customer so could if I did what you said and added an Invoice number field would all the...

This is slightly different from every other database as I do not have orders. amount sold and things like that as I am designing it for a courier company. But I have a JobDetails table and I have a lot of fields in there. I really will have to add an invoice table won't i to solve this problem...

I have invoice numbers written down in my book and they generate from month and date anyway. but no they are not anywhere in the database but in my head sort of thing. So what do you reckon do you think I should have an Invoice table with the Invoice number field?? I was looking to have one...

Hello I have generated an invoice report from a parameter query and I want to put a Invoice Number in the Report. However I don't have an Invoice number field. If I was to make an Invoice table with an Invoice number field can I add it to the report now?? Or is there another way of doing it...

Thanks for the word on the book. I will definetly be getting that book its a bargain for £7.59. I am just about to ask another question but its about reports now so I will be jumping onto the Reports forum

Thank you so much sorry for taking so long to figure this out but I really so appreciate your help. I have learnt so much from this forum. I have actuall learnt everything that I know about access and now I have got my first step to learning SQL. Thanx alot. No doubt you will be hearing from...

So do I change the control source back to Weight ? Will that sort it out?? Thanx for the answers and at least I have learnt how to learn about SQL in the future. So will this fix it??

I have looked at the grouping and sorting on my report and there is nothing that I can see with reference to the Weight. See the field name is Weight and I changed it on the report to Wgt/Kg so that it would fit on the report. Thats when I started getting asked for the Wgt/Kg parameter. But I...

SELECT Customers.CustomerID, Customers.CompanyName, Customers.BillingAddress, Customers.BillingAddress1, Customers.[City/Town], Customers.[County/Region], Customers.PostalCode, [Job Details].[Job No], [Job Details].[REF NO], [Job Details].Date, [Job Details].[Pick up], [Job Details].Destination...

Please don't get technical on me:p I use this in the criteria in the design query. In the Date Field I use: Between[Enter Start Date]and[Enter End Date] In the CustomerID field I use: [Enter CustomerID] This is what I was told to do to generate the Invoice Report. The query runs fine I...

Hello peeps. Needing your help again. The problem I have is I have set up a parameter query to generate an invoice report. The parameters I ask are Start Date, End Date and Customer ID. However when I designed the report I changed the way Weight was written in the label so that it fitted in...

Returning queries with no prices. HOW? Hello all. Thanks for all of your help for 2003. Now I need help in 2004. The problem I have is: I am designing a database for a courier company that I work for. I want a query that brings me all the records I have from certain dates that have NO Prices...

Thanx for the answers. At the moment I am just wanting to open the file and I can't even do that??? Should I be able to open it to look at it if I convert the 97 database file to 2000?? See I got the impression that I could somehow open my whole Access program up in another version?? Forgive...

I actually tried this and my cat Links, (my helping icon) tells me he can't open and MDE file.?? What does that mean?? I didn't mean that you all knew that i had MS office xp. I meant that you all know that you can convert to 2000 and 2002 versions. So if I convert the 97 database to 2000 I...

Hello Switch here Hope everyone had a nice xmas and I wish you all the very best for the year 2004. Ok I do have a bit of a silly problem. I have tried to find the answer in a number of ways before posting this question and I can't find the answer that I want. Well I'm not even sure if it is...

Sorry for taking so long to reply had to get on with my work and then finished work and had to do the xmas family rounds thing. So sorry about that. I use Microsoft XP so I suppose thats Access 2002 however I do actually use Access 2000. Did start by using 97 is that one better then?? I will do...

Help Me again Hello I just tried to do the Customer labels again and now for some reason unbeknown to me it is not working. I copied the formula from the Northwind database and it doesn't work.???? Basically all I want to do is create a report with all our customer contact details on...