Recent content by Senor Penguin

Ok so it wont create duplicate entries with this but can I also make it overwrite existing entries or can they only be ignored? Thanks

This is what I was thinking! Yes there is only 1 total sales per day, per location, so I could add a column combing these and each of these values would be unique. Would this allow me to easily import the table again and just set it to allow overwrite of duplicate primary keys? Or would I...

:banghead: I need to watch more Youtube videos, this gives me something to research though, Thanks

Ok that makes sense but one last thing. I have to manage too many locations, sales for about 200 locations everyday so rather than figuring out what locations and days need to be updated I run a MTD report everyday and replace all sales everyday, would you suggest basically just deleting all...

Thanks, That's what I thought but my concern is that I will need to go back and update some of this information. Our Sales numbers may change and need to be re-updated for a previous day, so how could I re-import an Excel file and have it replace the previous days sales rather than just create...

Hey Guys, I am a complete newb in Access so please go easy on me. I am trying to create a sales Database by importing an Excel sheet but it gets a little bit tricky because the report I want to upload is for many locations and many days so a lot of the values are duplicated. I was trying to...