Recent content by larrynew

How do I hire a programmer for a very small project? I run a small business and I've never hired anyone to help with anything computer related so I don't know where to start. I sort of get Access and was able to do a very very small project (UNION ALL, 30 Excel spreadsheets, etc.) with help...

Thanks! Works great. Larry

Another thanks for the help with UNION ALL and the 31 Excel spreadsheets from last week. Working great. I hope I can ask my next question well enough to be understood. Here goes. I upload a spreadsheet file (their required format) to my website to update the price, description, etc. It...

Paul, I don't have any control over the downloaded spreadsheets and they change so often that manupilating them would be much too time consuming. My next chore will be finding the MIN price but only from the locations that have the item in-stock. Thanks again, Larry

Paul & Bob, Great, works like a champ! Thanks! I'm starting to understand the whole Normalization of data thing vs. spreadsheet thinking. After playing with UNION ALL, I scrapped my ugly method of getting the sum of inventory from the other 31 spreadsheets and switched to UNION ALL. Much...

Bob, Here are 3 of the files. I only included the first 800 or so items of each file to keep the file sizes small. Thanks, Larry

First, a quick thanks to those on this forum that helped me last July get started switching from Excel to Access. Progress has been made and I'm now tracking inventory quantities daily in my Access file that's linked to 31 Excel spreadsheets. All I know I've learned from reading this forum and...

Paul, Thanks to the advice here and more reading I've done, I think I'll put off switching to Access for another month while I study more of the basics of table design. I can see now that I need to break-up my flat earth spreadsheet into smaller tables. If I don't have time to do it right now...

Thanks George, Paul, I've got some homework to do! At least now I have a direction. I was really feeling confident with the switch from Excel to Access until I got to MIN(). Everything else (iff, &, +-/*) was straight forward. Paul, the microsoft link may be what I need. I'll work on it for a...

Brian, George, Yes, I am retaining the layout of my Excel file...for now, just to keep everything simple during the transition. It is a very large flat file with many attributes of my products like weight, cube, etc. I also have fields for the prices from my different suppliers and several...

Thanks for quick reply, George. Is the "group by clause" where I reference the multiple columns? I know if I just have an example or can find one in my "Excel Bible", I can use the same syntax for all the places where I currently use =MIN(B2,C2,D2) in Excel. Thanks, Larry

I am converting a large Excel spreadsheet (128MB) to Access 2003 where it should have been from the beginning. I'm good with Excel Functions but a beginner with Access. My spreadsheet includes data like this: master_id vender1price vender2price vender3price lowestprice ABC123 $10 $9 $11 $9...