Is it possible to create a report that looks like a table?

[mitch_pearce79]

Hi All,



Brand new to Access and to this Forum, so you can expect a few easy (stupid?) questions from me.

I'm planning the tables and relationships for a very basic project management tool to assist us at work. What I should end up with once its all done is three related tables as per below.

TRIP ID	Job ID	Task
Primary Key
eg. TRIP00001	JOB0001	Nest Marking

PERSON ID	Surname	Given Name(s)	Etc
Primary key
eg. PERSON00001	Pearce	Mitch

TRIP PERSON ID	Trip ID	Person ID	Start Date	End Date
Primary key
eg. TP0000001	TRIP00001	PERSON0001	11 Dec 2012	23 Dec 2012

Would it be possible, do you think, to generate a report using the data in the above tables to display as per below.

Date	Day	Mitch Pearce	Person2	Person 3	Etc
08 Dec 2012	Saturday
09 Dec 2012	Sunday
10 Dec 2012	Monday
11 Dec 2012	Tuesday	Nest Marking
12 Dec 2012	Wednesday	Nest Marking
13 Dec 2012	Thursday	Nest Marking
14 Dec 2012	Friday	Nest Marking
15 Dec 2012	Saturday	Nest Marking
16 Dec 2012	Sunday	Nest Marking

Hope the question makes sense!

Regards,

Mitch

[June7]

You want to show records that don't exist. You have a date range (begin/end) and want to show a record for each day within that range. Only method I can see would require VBA procedure and a 'temp table'. Not an easy task for someone new to databases and programming.

You might find this discussion of interest https://www.accessforums.net/databas...ses-18459.html

[mitch_pearce79]

Thanks... Possible is good. The report table above approximates the current practice (albeit in a MS Excel spread sheet) for the management of field scientists. Date down the side, names accross the top and field trip assignments or periods of unavailability in the table.

Can you recommend another way to display the data that would be easier from a MS Access perspective? (i.e. still allowing the user visibility across all field scientists for each day of the year). Maybe some kind of calendar view?

[June7]

Only way I know to manipulate the data for the output you want or like the examples in the referenced link will is with VBA.