Custom Active Report Problem

May 12, 2006 1 Replies

Hi!



I would like to be able to generate a detailed sales report that is based on a date AND time combination, e.g



All transactions between '08/05/2006 19:00:00' and '09/05/2006



03:00:00'

Anyone got any ideas as to how I can achieve this?



Also, is there any help file associated with creating custom reports? The information seems woefully inadequate and it would be great if I could read something that explains to me just what you can do with Active Reports and how to customize them.



Many thanks Mark



This is a quick and dirty solution: Change: VBDataType = vbData to VBDataType = vbString

And in the Report you'll have to set the date twice

Date >= YYYYMMDD HH:MM:SS and Date Hi!

Join the Discussion

Have something to add? Share your thoughts — no account required.

Didn't find your answer?

Ask the community — no account required