how to create a week planning?

[laghetto]

Hi!
i need to create an access file that show a "week planning" based on a table of this type:
ID_event
Data_event
Text_event

e.g.
09/01/2012 meeting
09/01/2012 dinner with Kate
11/01/2012 gym
25/01/2012 meeting
....

i want to see in a form something like this:

mon tue wed thu fri sat sun
meeting gym
dinner wi..

can i do this using a crossed field query?
some day have no event, other have more than one.

I have to filter by week (e.g. "this week, this week+1...)

have you got any ideas?

best regards

al

 

[Privateer]

At the risk of sounding crass, have you tried doing this in Outlook? Why in a database?

 

[RainLover]

can i do this using a crossed field query?

At the risk of stating the obvious.

Have you tried and if so what was the result.

 

[RainLover]

Privateer

At the risk of sounding crass, have you tried doing this in Outlook? Why in a database?

Outlook is a Database. In fact in may be the world's largest collection of Data. Outlook just does things a little differently to Access.

 

[laghetto]

Hi!,

why access and not Outlook?

Because my file will have more function (it is not only a week planning), and because it have to be more customizable.

bye!

 

[RainLover]

laghetto

I did ask a serious question.

Do you have a responce, or have you found a solution.