November 16th, 2005, 09:10 AM
|
|
Weekly Charts in Reports
did you have a look at it susan?
"Neil M" wrote in message
...
I have changed that but still getting the same error.
I have uploaded the database so you can physically have a look?
My reports don't seem to be in chart form just in list of room and dates,
etc..
Thanks,
Neil
"SusanV" wrote in message
...
Hi Neil,
For the "staff" problem, change the AS part of the query to whatever you
like - AS simply is giving the calculated field a name. Perhaps:
TRANSFORM First(TBL_Main.Staff) AS StaffName
SELECT TBL_Main.Date, TBL_Main.Room
FROM TBL_Main
GROUP BY TBL_Main.ID, TBL_Main.Date, TBL_Main.TimeIn, TBL_Main.Room
PIVOT TBL_Main.TimeOut;
"Neil M" wrote in message
...
Right here the layout -
I got a report named REPORT which is linked to "Qry_Report" query
Here is the SQL for the Query;
TRANSFORM First(TBL_Main.Staff) AS FirstOfStaff
SELECT TBL_Main.Date, TBL_Main.Room
FROM TBL_Main
GROUP BY TBL_Main.ID, TBL_Main.Date, TBL_Main.TimeIn, TBL_Main.Room
PIVOT TBL_Main.TimeOut;
Is there a special way to display the times, staff (names) and other
info
on
the REPORT, as it appears that if I select field list on the report
design
only the actual dates and data is shown and not the field names that I
can
recognise like Staff, TimeIn, TimeOut, etc..
Hope this explains it a little better.
"SusanV" wrote in message
...
Sorry should have stated what control in the report is using
"staff" -
not
field.
"SusanV" wrote in message
...
What field is using "Staff" as a record source (view via Properties
of
fields)? What is the equivalent field in your crosstab query?
Change
the
source to the appropriate field.
--
hth,
SusanV
"Neil M" wrote in message
...
thanks. got the crosstab query done and it appears to be running
ok
but
when i link it to my report it states that it doesn't recognise
'staff'
as a
valid field name or expression.
any suggestions on how (lame man's terms) i link it to the
report -
as
the
report field name list does not have staff on it.
Thanks,
Neil
"SusanV" wrote in message
...
Create a query containing all the data you will need to display,
either
from
a table or tables, or an existing query. Save it and while in
Design
View,
change it from a select query to a Crosstab query either in the
Query
Menu
or from the toolbar.
Choose "Row Heading" for the times
Choose "Column Heading" for the dates
Choose Value for the Name, and set the "Total" option from
GroupBy
to
Either
First or Last.
Open the query in datasheet view and you should see the layout
you
are
looking for. Save the query, and use that query as the data
source
for
your
report.
Here's a link to a site with a tutorial in case I wasn't clear:
http://www.jmu.edu/computing/ittrain...crosstab.shtml
--
hth,
SusanV
"Neil M" wrote in message
...
sorry can you eplain a bit more what you mean and how roughly
to
do
this.
thanks.
"SusanV" wrote in message
...
Hi Neil,
I think if you use as the report source a crosstab query
you'll
be
able
to
get the report you're looking for.
--
hth,
SusanV
"Neil M" wrote in message
...
Hiya all,
I have yet another problem I can't seem to get my head
around.
Here's the problem...
Part of the same database is a system to book of rooms
dependent
on
days.
The database works fine and I can print normal 'listing'
type
reports
which
will make do for now.
But what I really would like to do is print off a report
where
it
has
the
times and dates like a chart
(like below
ROOM (header)
DATE DATE DATE DATE DATE DATE
DATE
(Mon Sun)
TIMES
in hours NAME
here
from
8am to
8pm?
Get my drift, so the block of staff names appear in the
times
theyt
have
the
room booked.
Anyone got any suggestions on how to do this. I have found
an
example
database for this sort of thing (Doctors, etc) but I can't
seem
to
get
my
head around the rather complicated coding and reporting. I
need
to
understand how its done not just how to do it.
Thanks,
Neil
|