Recent content by LizJohnson

I have finally been able to get a stripped down version of my database and have attached that. There are some forms that are there that I'm not using, but I don't want to delete those yet because they may be attached to something. I've tried so many things, I forgot what I've done on some...

That didn't work either. I used the # code. I also copied/pasted. I've attached a word doc that has a print screen of what I'm talking about. I hope this helps. I've had to zip the attachment.

qry73A421SalesandUseTaxNumberTobaccoLicenseNumberNumberofLocationsSells...

The example doesn't look anything like what it did in my message. Sorry.

Here is my SQL: SQL SELECT DISTINCT tblCigaretteDataCollection.SalesandUseTaxNumber, tblCigaretteDataCollection.TobaccoLicenseNumber, tblCigaretteDataCollection.NumberofLocations, tblCigaretteDataCollection.[Sells Cigarettes], tblCigaretteDataCollection.Stamper...

I just did that. I did eliminate a lot of them but still kept 8 duplicate records. So, for example, I had one account that should be showing 2 times because I have two different tobacco license #'s but the same sales tax number. It was originally showing 8 times (repeating the info 4 times)...

So I set up a payment table, like suggested. I have now had to adjust my query to pull from the payment table instead of the original table where I had my payments coming from. Now when I look at the numbers in my query, instead of it showing just one time, it is showing twice and sometime 4...

Thanks for the info. I'll have to look into this further. The first table I update does have a unique identifier and it is only adding the new records that are not there, but I am getting additional email addresses for this table that is not uploading that I would like to have in the table...

Ok, even if I can get the payments to work where they will sum based on the main number on a separate table, this is still not answering my initial question. Is it possible to upload the information from the excel spreadsheet without duplicating the data. There is other data that is uploaded...

I wish!!! I have been working with this database for ever! (At least it seems that way). I have been working on it for over a month. Originally couldn't get it to populate the query or forms correctly. I was going to put the payments on a separate table and have the payments post...

I am going to be importing data from an Excel file into Access on a daily basis. The programmer of the information that is being sent to me on the Excel spreadsheet is sending "all" the information every day. What this means is that I will be getting duplicate information every day, along...

Thank you for your suggestion. I'm not sure how that would be easier to do on a daily basis than hitting a hot key to run a Macro? I do appreciate the help, though.

So, what I do is get all of my information on just 1 tab in Excel. I then copy all of that information 3 times onto 3 separate tabs in Excel because when I load the information into Access, they have to go onto 3 separate tables. I am making sure that when I name my sheets that they are in the...

I set up an Access database. I am going to be getting up loads from our IT department that I will have to upload into my Access database on a daily basis. This is going to upload tax information that the tax payer is going to file on-line. The upload will be from an Excel file to Access...

Thank you for your help on this. So, instead of making a 2nd query and then tying that back to the 1st query, which seems tedious, I changed my Total expression. I just made this expression mimic what was in the other two expression and adding them together. Since the expressions were so...