Recent content by Rebel

Ahhh, ok. I understand now. I have an inkling as to what you're talking about here; a sort of fuzzy understanding. I would definitely need to see some examples to get a better handle on it. Unfortunately, I think that solution might be far out of skill range at the moment, so I'll have to note...

Oh, I realize I am not paying anyone here and I am therefor extremely grateful for the help I receive, and especially for links to other sites with good information to further my Access education. If you take a second look at the dates of my two posts, you will see that I waited the requested...

Is this something that can't be done? Am I wording my question incorrectly?

To expound a little bit, if you want a pop-up box asking for the criteria, enter the following in the criteria field of your query: LIKE [Enter first 3 letters: ] & "*"

I have a table that archives hour meter readings for my equipment. You sharp folks here helped me set it up and it works great. Thanks! I am at the point now where I want to do some studies and calculations on this data. The first project I’m working on is equipment utilization over a period of...

Hey, no problem. I'm just glad I could finally contribute something instead of just being a leech. With any luck, one of the gurus around will have an easier and more elegant solution.

I'm pretty new at this stuff, so this might sound like a goofy work-around... I took a report that I have that is similar to what you are describing yours is like. In the query that goes with this report I added a field that I just called "Filler." In the Sorting and Grouping section of my...

Thanks Thanks, Saifon, for posting this question. I have the same problem, but just the opposite: I want to leave out the current date. You saved me the time of typing my question out. :) And a big "Thank You" to you, Jon, for a nice simple answer.

Well, I'll be darned. Who woulda thought something that simple would mess things up? Thanks a bunch, Rich. That did the trick.

I have a fleet of equipment at a factory that is divided into groups (e.g. fork lift, dump truck, etc.) belonging to certain departments. I have a report that shows all of the equipment ordered by Departments then by Groups. However, I often get asked to provide just a list for one Department or...

Success! Well, after rasslin' with it all day today, I finally got the Archive table and base query set up to do what I want it to do. Eureka! The Archive table is holding all the meter readings and the Append query is adding all the new readings properly. Once my data was all installed I tried...

Negatory, there, Rubber Duck. I can assure that it does not store any historical meter data. I just double checked with the admin. Yes, I have; no, it doesn't.

That's what I'm pretty much trying to do, Dan. The Oracle db where the original tables reside stores all the Equipment info in one table with a field for MeterReading (current reading) and LastRead (the reading before the current one). It only stores those two readings, but I want to keep all of...

That's what I was afraid of. I was hoping that there was some sort of built-in function in Access that would do it. Luckily, my database is small enough that, while a bit time-consuming, it won't be too terrible to go through each individual Table/Query/Report to find what links to what...

Hmmm… If I understand you correctly, what you are saying is have tblMeterArchive with three fields (Equip#, MeterRead, ArchiveDate) and just keep tacking the new meter data onto it? For instance, this… Equip# | MeterRead | ArchiveDate 12345 | 65.5 | 5/2/05 12346 | 1288 |...