AnsweredAssumed Answered

Need Help...

Question asked by datacapture on Aug 17, 2009
Latest reply on Aug 18, 2009 by philmodjunk


Need Help...


I am running on Windows and have FM Pro 10 Advanced. 


I have 2 databases... Database A & Database B.


In Database A, I am acquiring data and storing it in Database B through scripts and Copy & Paste Commands.  This is working well.  My problem is, that I need to find out how many records occur during a certain time frame (lets say the last hour and the hour before that), and bring the total for each hour back into Database A for display purpose.  This also needs to be updating every hour.


Any suggestions, would be greatly appreciated.