I'd like to place a field on a form that displays a count of the number of new records created in a table in a given day. What would be the most sensible way of doing this?
Also, I'd like to produce a report for a date range 'all records between dateA and dateB. what would be the syntax for the criteria for this...
Hmmm come to think of it one last query... I catpture an initial record. RecordA in TableA. There are three tables related to TableA, tbl1, tbl2, tbl3. Each table containing 0 or greater number of records. I'd like to be able to generate a report that outputs all fields in RecordA and each related record in tbl1, 2 and 3. How might I do this?
Cheers in advance....
Also, I'd like to produce a report for a date range 'all records between dateA and dateB. what would be the syntax for the criteria for this...
Hmmm come to think of it one last query... I catpture an initial record. RecordA in TableA. There are three tables related to TableA, tbl1, tbl2, tbl3. Each table containing 0 or greater number of records. I'd like to be able to generate a report that outputs all fields in RecordA and each related record in tbl1, 2 and 3. How might I do this?
Cheers in advance....