Hi all
I have an Access database which has been used for 7 years and one of the Tables is used to store all our staff itineraries, it was based on one activity per day per person, until now! Some work we have just recently undertaken for a customer has required a system change to allow for half days. I have had to change the key to include a TimeFrame of Whole, AM or PM. I have a report which produces a weekly plan for set dates, it is based on a crosstab query grouped on date, so it only prints one of the Activities since this change. If I add in the TimeFrame field to group on I get three pages of the report instead of one, one page per group data (whole, AM or PM).
I need to basically combine the description if two dates exist (i.e. an AM and a PM record) so it shows the activity for both records on one line. Please can anyone suggest the best way of doing this? Would I need to use code to write to a temp table and check if there are duplicate dates somehow to combine the two records into one, or am I over-complicating this?? Hope this makes sense... thanks!
I have an Access database which has been used for 7 years and one of the Tables is used to store all our staff itineraries, it was based on one activity per day per person, until now! Some work we have just recently undertaken for a customer has required a system change to allow for half days. I have had to change the key to include a TimeFrame of Whole, AM or PM. I have a report which produces a weekly plan for set dates, it is based on a crosstab query grouped on date, so it only prints one of the Activities since this change. If I add in the TimeFrame field to group on I get three pages of the report instead of one, one page per group data (whole, AM or PM).
I need to basically combine the description if two dates exist (i.e. an AM and a PM record) so it shows the activity for both records on one line. Please can anyone suggest the best way of doing this? Would I need to use code to write to a temp table and check if there are duplicate dates somehow to combine the two records into one, or am I over-complicating this?? Hope this makes sense... thanks!
