Data by Day

[Halliarse]

CR10
SQL database

I need to be able to create a table based on multiple 'people' records which holds a daily record of particular pieces of data against an existing transaction file which includes the dates of the transaction.

i.e. The output file needs to be keyed by Master_Number and contain a record per day from 01/10/2007 to today. It needs to include a code that was valid for each day. The default code from day 1 will be AA1 and then whenever the code changes against a specific date within the transaction file, the code changes until the next valid transaction.

The layout of the output data should be as follows:

Master_Number, Date, Code

I am having issues in determining the best way forward so any assistance would be greatly appreciated!

Many thanks

Steve

 

[Madawc]

I think you could get it by grouping by Master-Number and then Code, maybe also date within code.

Try it and see what you get. Use the 'Wizard', that's what most of us do at first.

Madawc Williams (East Anglia, UK). Using Crystal 10 & 11.5 with Windows XP