Search results for query: *

Why is it the simple solution is so elusive? Thanks Skip - I feel like a real dummy-head for not thinking of the custom number format!!! Scott

I have an Excel spreadsheet with a long list of numbers on it, (over 1500). Some of the numbers are less than four digits (ie - 23) and I need them to all be converted to four digit numbers with leading zeroes (ie - 0023). Yes, I have already converted that column to text so it will display...

First an appology if this is not the correct forum. I am not sure exactly where is the best place for my question. The goup I work with has a common shared folder which is a huge mess. There is years of engineering data in it, but not a lot of rhyme or reason, and finding information from...

Hello - I have a database to track various pieces of equipment and their status. Information I am tracking includes manufacture, part number, specific serial number, location. I got a lot of help in here getting my tables normalized, and am testing with some small samples of data now - it...

Hello - I have read the Access MVP article about the evils of lookup fields, and have not strayed from the path of righteous database design. However, the problem I am having does make look far off to the left to the evil land of lookup fields and wonder, "Are they really all that bad? They...

Hello - I have been seeking an application for a few years, have tried several commercial apps, none have done the trick for me. I have a job where my my function is fixing things, a variety of things. In addition I also prepare reports (who doesn't anymore??) including weekly and monthly...

Thank you both, Remou and Golom for your great inputs. I have made some changes regarding history. Remou - I had initially thought perhaps I could do something like run reports and use that date/time stamp to track my history. That of course would lead to having to save a bunch of reports...

Hello - This is a lengthy post, and I appologize beforehand. I have looked at many posts on this web site, and went to http://r937.com/relational.html and read/re-read that quite a bit. I have asked all the users of my database some questions regarding what information they want to obtain...