Search results for query: *

I was thinking you could just save the whole database (after compacting it of course)and send it to your client each month. But that wouldn't be just the new data, that would be the whole thing. DD

Simon, John Thanks for these ideas. Simon I liked the idea of using a Max sorting (actually sum I guess) and thought I would try that on the meter reading grouped by siteID, but that wouldn't work if the meter "rolled over" to 00000. I guess I will try using the date as you suggested...

I haven't used it myself, but you might want to check out "replication" in the help section of Access. This creates a master design of the database and then generates copies of the data. It syncronizes any new data between replicated copies. Hope this helps DD

HI fairly new to all this and am working on a database that will generate electrical billing. I need to figure out how to retrieve an electric meter reading from the previous month so that I can then subtract it from the current reading. So far I have: Table Meter Readings: ID (pk)...

Jeremy thanks for your insight. I like the idea of a rate table but in my situation, the rate changes on a monthly basis determined by 3 main meter readings. I will use the site charges as you suggest, I like that as well. I guess I will just have to muck around a bit and try things. Thanks...

I am relatively new at this, so I have been reading everything to the point I have gotten confused. My situation: I want to create a utility billing application for an RV campground. Electric meters are read for each site, once a month and the tenant is billed. So, I have a table for tentants...