Reset of daily Meter

[hboisteau]

Morning,
I'm still thinking about my database creation and I really struggle to see how.
Let me explain, I have one table or daily basis I write the meters of slot machines. this table looks like this:

Id Slots Date Meter1 Meter2
1 1000 01/01/12 120 450
2 1001 01/01/12 78 98
3 1000 02/01/12 142 453
4 1001 02/01/12 78 98

After that I make a meters difference by a query. Until the it is ok!
my problem occurs when, for technical reasons, I have to do a reset of the meters.
Should I go through a table?
should I go through the VBA in the query?
do I create a new query?
in short I do not know where to take it.
Thank you in advance.
HB

 

[pr2-eugin]

When you say you want to reset the meter readings, does it apply for only certain records or all?
You can use an Update Query to do it, Create an Update Query via the Query Builder and then you can either run the Query through VBA or just on its own..

 

[hboisteau]

Yes I forgot to say that this only applies for some slots.
For the rest I do not really understand what you mean.
You can specify.
Thank you again.
HB

 

[pr2-eugin]

Well what I am saying is, you can have a Query as

UPDATE [COLOR=Blue]tblName[/COLOR] SET Meter1 = 0, Meter2 = 0 WHERE [COLOR=Blue]Slots>1001[/COLOR];

(Highlights needs to change as per your needs) and then you can save this query with some name say "UpdateMeter_Qry" call this query via VBA as

DoCmd.OpenQuery "UpdateMeter_Qry"

 

[jdraw]

You should research Normalization and get your tables designed.
Fields like meter1, meter2 indicate a non - normalized structure.

Here's on link, but there are many
http://en.wikipedia.org/wiki/Database_normalization

 

[hboisteau]

hi,
Please I need more precision on my problem.
I have to do a meter management of slot machines and for that I read the daily meters, unfortunately it may be that we were wrong about entering meter (reversing digits) and also for technical reasons that meters be provided to zero.
In both cases the results will be false but the process must be different:
Meter error, we should make a meters correction recorded, it works no problem.
Reset of meters,??? knowing that we can have a single slot machine has been reset and that the delta counters the day before should remain the same.
thank you again for your help.
I attached an excel file to see what I'd like.
HB