A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Timetable



 
 
Thread Tools Display Modes
  #1  
Old September 21st, 2006, 08:15 PM posted to microsoft.public.access.reports
ir26121973
external usenet poster
 
Posts: 13
Default Timetable

Hi,

I don't even know whether this can be done, but I wonder if someone can help
please.

I have the following information in an access query:

Date Started Date Tested Date
Finished
Test 14/08/06 30/09/06 31/12/06
Live 01/01/06 31/10/06 31/01/07

I would like this to be able to be shown as a timetable, if you can imagine
looking like a hotel reservation screen, where there is a timeline across the
top and blocks of colour to highlight the paticular dates for the two
categories.

Can anyone help please. I'm not sure whether this may even be better in Excel.

Many thanks

Chris
  #2  
Old September 21st, 2006, 08:22 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 2,251
Default Timetable

Check the Calendar reports at http://www.access.hookom.net/Samples.htm.

--
Duane Hookom
MS Access MVP

"ir26121973" wrote in message
...
Hi,

I don't even know whether this can be done, but I wonder if someone can
help
please.

I have the following information in an access query:

Date Started Date Tested Date
Finished
Test 14/08/06 30/09/06
31/12/06
Live 01/01/06 31/10/06
31/01/07

I would like this to be able to be shown as a timetable, if you can
imagine
looking like a hotel reservation screen, where there is a timeline across
the
top and blocks of colour to highlight the paticular dates for the two
categories.

Can anyone help please. I'm not sure whether this may even be better in
Excel.

Many thanks

Chris



  #3  
Old September 21st, 2006, 09:01 PM posted to microsoft.public.access.reports
ir26121973
external usenet poster
 
Posts: 13
Default Timetable

Duane,

Thanks very much for this. I'll take a look at it.

Regards

Chris

"Duane Hookom" wrote:

Check the Calendar reports at http://www.access.hookom.net/Samples.htm.

--
Duane Hookom
MS Access MVP

"ir26121973" wrote in message
...
Hi,

I don't even know whether this can be done, but I wonder if someone can
help
please.

I have the following information in an access query:

Date Started Date Tested Date
Finished
Test 14/08/06 30/09/06
31/12/06
Live 01/01/06 31/10/06
31/01/07

I would like this to be able to be shown as a timetable, if you can
imagine
looking like a hotel reservation screen, where there is a timeline across
the
top and blocks of colour to highlight the paticular dates for the two
categories.

Can anyone help please. I'm not sure whether this may even be better in
Excel.

Many thanks

Chris




  #4  
Old September 22nd, 2006, 08:35 PM posted to microsoft.public.access.reports
ir26121973
external usenet poster
 
Posts: 13
Default Timetable

Duane,

As I said last night, thanks for this.

I've had a look at this today and it's not quite what I would like.

I'll try and explain a little better.

The report that you pointed me to shows the timeline across the top but what
I really need, if possible is for the dates for the relevant activities
against my categories, (which will be in a query in the background) to be
populated under the relevant date in the timeline. Almost as if you were
filling in cells in excel

I'm not even sure whether there is a way to export this into excel and for
that to create a table in Excel?

Hope this helps

Many thanks

Chris

"Duane Hookom" wrote:

Check the Calendar reports at http://www.access.hookom.net/Samples.htm.

--
Duane Hookom
MS Access MVP

"ir26121973" wrote in message
...
Hi,

I don't even know whether this can be done, but I wonder if someone can
help
please.

I have the following information in an access query:

Date Started Date Tested Date
Finished
Test 14/08/06 30/09/06
31/12/06
Live 01/01/06 31/10/06
31/01/07

I would like this to be able to be shown as a timetable, if you can
imagine
looking like a hotel reservation screen, where there is a timeline across
the
top and blocks of colour to highlight the paticular dates for the two
categories.

Can anyone help please. I'm not sure whether this may even be better in
Excel.

Many thanks

Chris




  #5  
Old September 22nd, 2006, 09:39 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 2,251
Default Timetable

I'm fairly sure all the information is there in one of the reports. You just
have to understand how to apply it. You want dates across the top, my sample
has dates across the top. You want records to be displayed under specific
dates, my sample prints record information under specific dates.

Can you draw out your desired display in Paint Brush or Excel or whatever
and post it on the web somewhere so we can understand what you mean?


--
Duane Hookom
MS Access MVP

"ir26121973" wrote in message
...
Duane,

As I said last night, thanks for this.

I've had a look at this today and it's not quite what I would like.

I'll try and explain a little better.

The report that you pointed me to shows the timeline across the top but
what
I really need, if possible is for the dates for the relevant activities
against my categories, (which will be in a query in the background) to be
populated under the relevant date in the timeline. Almost as if you were
filling in cells in excel

I'm not even sure whether there is a way to export this into excel and for
that to create a table in Excel?

Hope this helps

Many thanks

Chris

"Duane Hookom" wrote:

Check the Calendar reports at http://www.access.hookom.net/Samples.htm.

--
Duane Hookom
MS Access MVP

"ir26121973" wrote in message
...
Hi,

I don't even know whether this can be done, but I wonder if someone can
help
please.

I have the following information in an access query:

Date Started Date Tested Date
Finished
Test 14/08/06 30/09/06
31/12/06
Live 01/01/06 31/10/06
31/01/07

I would like this to be able to be shown as a timetable, if you can
imagine
looking like a hotel reservation screen, where there is a timeline
across
the
top and blocks of colour to highlight the paticular dates for the two
categories.

Can anyone help please. I'm not sure whether this may even be better in
Excel.

Many thanks

Chris






  #6  
Old September 23rd, 2006, 04:36 PM posted to microsoft.public.access.reports
ir26121973
external usenet poster
 
Posts: 13
Default Timetable

Duane,

There's no doubt in my mind that your database samples can point me in the
right direction, like you said it just how to apply them to what i need. I do
have a limited knowledge of access, but my experience is getting better as
time goes on.

I've obviously got a file of how I want the report to look but haven't got a
clue where to post it. Not done this sort of thing before.

Any ideas?

Regards

Chris


"Duane Hookom" wrote:

I'm fairly sure all the information is there in one of the reports. You just
have to understand how to apply it. You want dates across the top, my sample
has dates across the top. You want records to be displayed under specific
dates, my sample prints record information under specific dates.

Can you draw out your desired display in Paint Brush or Excel or whatever
and post it on the web somewhere so we can understand what you mean?


--
Duane Hookom
MS Access MVP

"ir26121973" wrote in message
...
Duane,

As I said last night, thanks for this.

I've had a look at this today and it's not quite what I would like.

I'll try and explain a little better.

The report that you pointed me to shows the timeline across the top but
what
I really need, if possible is for the dates for the relevant activities
against my categories, (which will be in a query in the background) to be
populated under the relevant date in the timeline. Almost as if you were
filling in cells in excel

I'm not even sure whether there is a way to export this into excel and for
that to create a table in Excel?

Hope this helps

Many thanks

Chris

"Duane Hookom" wrote:

Check the Calendar reports at http://www.access.hookom.net/Samples.htm.

--
Duane Hookom
MS Access MVP

"ir26121973" wrote in message
...
Hi,

I don't even know whether this can be done, but I wonder if someone can
help
please.

I have the following information in an access query:

Date Started Date Tested Date
Finished
Test 14/08/06 30/09/06
31/12/06
Live 01/01/06 31/10/06
31/01/07

I would like this to be able to be shown as a timetable, if you can
imagine
looking like a hotel reservation screen, where there is a timeline
across
the
top and blocks of colour to highlight the paticular dates for the two
categories.

Can anyone help please. I'm not sure whether this may even be better in
Excel.

Many thanks

Chris






  #7  
Old September 24th, 2006, 04:20 AM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 2,251
Default Timetable

If you can't adequately describe your desired display then you might want to
find a site that would host an image for free. I google this and got lots of
hits.

--
Duane Hookom
MS Access MVP

"ir26121973" wrote in message
...
Duane,

There's no doubt in my mind that your database samples can point me in the
right direction, like you said it just how to apply them to what i need. I
do
have a limited knowledge of access, but my experience is getting better as
time goes on.

I've obviously got a file of how I want the report to look but haven't got
a
clue where to post it. Not done this sort of thing before.

Any ideas?

Regards

Chris


"Duane Hookom" wrote:

I'm fairly sure all the information is there in one of the reports. You
just
have to understand how to apply it. You want dates across the top, my
sample
has dates across the top. You want records to be displayed under specific
dates, my sample prints record information under specific dates.

Can you draw out your desired display in Paint Brush or Excel or whatever
and post it on the web somewhere so we can understand what you mean?


--
Duane Hookom
MS Access MVP

"ir26121973" wrote in message
...
Duane,

As I said last night, thanks for this.

I've had a look at this today and it's not quite what I would like.

I'll try and explain a little better.

The report that you pointed me to shows the timeline across the top but
what
I really need, if possible is for the dates for the relevant activities
against my categories, (which will be in a query in the background) to
be
populated under the relevant date in the timeline. Almost as if you
were
filling in cells in excel

I'm not even sure whether there is a way to export this into excel and
for
that to create a table in Excel?

Hope this helps

Many thanks

Chris

"Duane Hookom" wrote:

Check the Calendar reports at
http://www.access.hookom.net/Samples.htm.

--
Duane Hookom
MS Access MVP

"ir26121973" wrote in message
...
Hi,

I don't even know whether this can be done, but I wonder if someone
can
help
please.

I have the following information in an access query:

Date Started Date Tested
Date
Finished
Test 14/08/06 30/09/06
31/12/06
Live 01/01/06 31/10/06
31/01/07

I would like this to be able to be shown as a timetable, if you can
imagine
looking like a hotel reservation screen, where there is a timeline
across
the
top and blocks of colour to highlight the paticular dates for the
two
categories.

Can anyone help please. I'm not sure whether this may even be better
in
Excel.

Many thanks

Chris








  #8  
Old September 24th, 2006, 12:05 PM posted to microsoft.public.access.reports
ir26121973
external usenet poster
 
Posts: 13
Default Timetable

Duane, thanks for hanging in there with me and taking the time to read my
posts it is greatly appereciated.

I'm going to try and explain what i would like, hopefully better

The database is used to collate tests which are carried out on e-forms that
I use.

These tests can be carried out on anyday throughout the financial year.

Within the database I have use a data entry form where I fill out the
description of each e-form along with the dates that these tests are carried
out.

For the ease of explaining I will use e-form 1 and e-form 2 as an example,
although there are more. For these forms there is a total of 2 tests, again
for ease, I'll call these test 1 and test 2.

What I need is a report if you imagine marked out like a grid with every day
in the year going across the top and then the names of the e-forms running
down the left hand side.

I would like the dates of the tests that I have entered to be shown in the
relevant dates on the report as different coloured blocks, so e.g. test 1
will be red and test 2 green.

Does this give you a better idea?

Regards

Chris
"Duane Hookom" wrote:

If you can't adequately describe your desired display then you might want to
find a site that would host an image for free. I google this and got lots of
hits.

--
Duane Hookom
MS Access MVP

"ir26121973" wrote in message
...
Duane,

There's no doubt in my mind that your database samples can point me in the
right direction, like you said it just how to apply them to what i need. I
do
have a limited knowledge of access, but my experience is getting better as
time goes on.

I've obviously got a file of how I want the report to look but haven't got
a
clue where to post it. Not done this sort of thing before.

Any ideas?

Regards

Chris


"Duane Hookom" wrote:

I'm fairly sure all the information is there in one of the reports. You
just
have to understand how to apply it. You want dates across the top, my
sample
has dates across the top. You want records to be displayed under specific
dates, my sample prints record information under specific dates.

Can you draw out your desired display in Paint Brush or Excel or whatever
and post it on the web somewhere so we can understand what you mean?


--
Duane Hookom
MS Access MVP

"ir26121973" wrote in message
...
Duane,

As I said last night, thanks for this.

I've had a look at this today and it's not quite what I would like.

I'll try and explain a little better.

The report that you pointed me to shows the timeline across the top but
what
I really need, if possible is for the dates for the relevant activities
against my categories, (which will be in a query in the background) to
be
populated under the relevant date in the timeline. Almost as if you
were
filling in cells in excel

I'm not even sure whether there is a way to export this into excel and
for
that to create a table in Excel?

Hope this helps

Many thanks

Chris

"Duane Hookom" wrote:

Check the Calendar reports at
http://www.access.hookom.net/Samples.htm.

--
Duane Hookom
MS Access MVP

"ir26121973" wrote in message
...
Hi,

I don't even know whether this can be done, but I wonder if someone
can
help
please.

I have the following information in an access query:

Date Started Date Tested
Date
Finished
Test 14/08/06 30/09/06
31/12/06
Live 01/01/06 31/10/06
31/01/07

I would like this to be able to be shown as a timetable, if you can
imagine
looking like a hotel reservation screen, where there is a timeline
across
the
top and blocks of colour to highlight the paticular dates for the
two
categories.

Can anyone help please. I'm not sure whether this may even be better
in
Excel.

Many thanks

Chris









  #9  
Old September 25th, 2006, 06:17 AM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 2,251
Default Timetable

Sounds like the crew rotation schedule in the Calendar Report samples.

--
Duane Hookom
MS Access MVP

"ir26121973" wrote in message
...
Duane, thanks for hanging in there with me and taking the time to read my
posts it is greatly appereciated.

I'm going to try and explain what i would like, hopefully better

The database is used to collate tests which are carried out on e-forms
that
I use.

These tests can be carried out on anyday throughout the financial year.

Within the database I have use a data entry form where I fill out the
description of each e-form along with the dates that these tests are
carried
out.

For the ease of explaining I will use e-form 1 and e-form 2 as an example,
although there are more. For these forms there is a total of 2 tests,
again
for ease, I'll call these test 1 and test 2.

What I need is a report if you imagine marked out like a grid with every
day
in the year going across the top and then the names of the e-forms running
down the left hand side.

I would like the dates of the tests that I have entered to be shown in the
relevant dates on the report as different coloured blocks, so e.g. test 1
will be red and test 2 green.

Does this give you a better idea?

Regards

Chris
"Duane Hookom" wrote:

If you can't adequately describe your desired display then you might want
to
find a site that would host an image for free. I google this and got lots
of
hits.

--
Duane Hookom
MS Access MVP

"ir26121973" wrote in message
...
Duane,

There's no doubt in my mind that your database samples can point me in
the
right direction, like you said it just how to apply them to what i
need. I
do
have a limited knowledge of access, but my experience is getting better
as
time goes on.

I've obviously got a file of how I want the report to look but haven't
got
a
clue where to post it. Not done this sort of thing before.

Any ideas?

Regards

Chris


"Duane Hookom" wrote:

I'm fairly sure all the information is there in one of the reports.
You
just
have to understand how to apply it. You want dates across the top, my
sample
has dates across the top. You want records to be displayed under
specific
dates, my sample prints record information under specific dates.

Can you draw out your desired display in Paint Brush or Excel or
whatever
and post it on the web somewhere so we can understand what you mean?


--
Duane Hookom
MS Access MVP

"ir26121973" wrote in message
...
Duane,

As I said last night, thanks for this.

I've had a look at this today and it's not quite what I would like.

I'll try and explain a little better.

The report that you pointed me to shows the timeline across the top
but
what
I really need, if possible is for the dates for the relevant
activities
against my categories, (which will be in a query in the background)
to
be
populated under the relevant date in the timeline. Almost as if you
were
filling in cells in excel

I'm not even sure whether there is a way to export this into excel
and
for
that to create a table in Excel?

Hope this helps

Many thanks

Chris

"Duane Hookom" wrote:

Check the Calendar reports at
http://www.access.hookom.net/Samples.htm.

--
Duane Hookom
MS Access MVP

"ir26121973" wrote in
message
...
Hi,

I don't even know whether this can be done, but I wonder if
someone
can
help
please.

I have the following information in an access query:

Date Started Date Tested
Date
Finished
Test 14/08/06 30/09/06
31/12/06
Live 01/01/06 31/10/06
31/01/07

I would like this to be able to be shown as a timetable, if you
can
imagine
looking like a hotel reservation screen, where there is a
timeline
across
the
top and blocks of colour to highlight the paticular dates for the
two
categories.

Can anyone help please. I'm not sure whether this may even be
better
in
Excel.

Many thanks

Chris











  #10  
Old September 25th, 2006, 06:26 PM posted to microsoft.public.access.reports
ir26121973
external usenet poster
 
Posts: 13
Default Timetable

OK Duane,

I'll have a look at it.

Many thanks once again

Chris

"Duane Hookom" wrote:

Sounds like the crew rotation schedule in the Calendar Report samples.

--
Duane Hookom
MS Access MVP

"ir26121973" wrote in message
...
Duane, thanks for hanging in there with me and taking the time to read my
posts it is greatly appereciated.

I'm going to try and explain what i would like, hopefully better

The database is used to collate tests which are carried out on e-forms
that
I use.

These tests can be carried out on anyday throughout the financial year.

Within the database I have use a data entry form where I fill out the
description of each e-form along with the dates that these tests are
carried
out.

For the ease of explaining I will use e-form 1 and e-form 2 as an example,
although there are more. For these forms there is a total of 2 tests,
again
for ease, I'll call these test 1 and test 2.

What I need is a report if you imagine marked out like a grid with every
day
in the year going across the top and then the names of the e-forms running
down the left hand side.

I would like the dates of the tests that I have entered to be shown in the
relevant dates on the report as different coloured blocks, so e.g. test 1
will be red and test 2 green.

Does this give you a better idea?

Regards

Chris
"Duane Hookom" wrote:

If you can't adequately describe your desired display then you might want
to
find a site that would host an image for free. I google this and got lots
of
hits.

--
Duane Hookom
MS Access MVP

"ir26121973" wrote in message
...
Duane,

There's no doubt in my mind that your database samples can point me in
the
right direction, like you said it just how to apply them to what i
need. I
do
have a limited knowledge of access, but my experience is getting better
as
time goes on.

I've obviously got a file of how I want the report to look but haven't
got
a
clue where to post it. Not done this sort of thing before.

Any ideas?

Regards

Chris


"Duane Hookom" wrote:

I'm fairly sure all the information is there in one of the reports.
You
just
have to understand how to apply it. You want dates across the top, my
sample
has dates across the top. You want records to be displayed under
specific
dates, my sample prints record information under specific dates.

Can you draw out your desired display in Paint Brush or Excel or
whatever
and post it on the web somewhere so we can understand what you mean?


--
Duane Hookom
MS Access MVP

"ir26121973" wrote in message
...
Duane,

As I said last night, thanks for this.

I've had a look at this today and it's not quite what I would like.

I'll try and explain a little better.

The report that you pointed me to shows the timeline across the top
but
what
I really need, if possible is for the dates for the relevant
activities
against my categories, (which will be in a query in the background)
to
be
populated under the relevant date in the timeline. Almost as if you
were
filling in cells in excel

I'm not even sure whether there is a way to export this into excel
and
for
that to create a table in Excel?

Hope this helps

Many thanks

Chris

"Duane Hookom" wrote:

Check the Calendar reports at
http://www.access.hookom.net/Samples.htm.

--
Duane Hookom
MS Access MVP

"ir26121973" wrote in
message
...
Hi,

I don't even know whether this can be done, but I wonder if
someone
can
help
please.

I have the following information in an access query:

Date Started Date Tested
Date
Finished
Test 14/08/06 30/09/06
31/12/06
Live 01/01/06 31/10/06
31/01/07

I would like this to be able to be shown as a timetable, if you
can
imagine
looking like a hotel reservation screen, where there is a
timeline
across
the
top and blocks of colour to highlight the paticular dates for the
two
categories.

Can anyone help please. I'm not sure whether this may even be
better
in
Excel.

Many thanks

Chris












 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 11:44 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.