View Single Post
 
Old 01-09-2016, 01:29 PM
PlausiblyDamp's Avatar
PlausiblyDamp PlausiblyDamp is offline
Ultimate Contributor

Forum Leader
* Expert *
 
Join Date: Nov 2003
Location: Newport, Wales
Posts: 2,058
Default

A more typical approach would be to store all the transactions in a single table and have a date / time stamp against each entry.

That way you could get the figures for a given day, week, month, range of days etc.
__________________
Intellectuals solve problems; geniuses prevent them.
-- Albert Einstein

Posting Guidelines Forum Rules Use the code tags
Reply With Quote