Weekly Schedule

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to make a crosstab query that will have a row heading of the
salesperson initials and the column headings will be monday through sunday.
for the values i want to insert the store that the salesperson is working in
on that day. i would also like to be able to reverse it and make the row
heading the store and the column headins monday - sunday and the initials the
value

the tables are

tbl_Schedule
-Id
-Salesperson (Number Relates To Employee Table)
-Date
-Store( number relates to Store Table)

tbl_Employees
-Id
-First
-Last
-Initials

tbl_Stores
-Id
-Name

how can i acheive this effect? is the Crosstab query the right way to go???

Thanks Again

WStoreyII
 
A crosstab should work well. You can use Format([Date],"dddd") as the column
heading and set the column headings property to all the days.

You can use "First" on the values column in the crosstab. Do you only have
one salesperson per date per store?
 
Duane,

That worked great, but i cant get the dates to be organized mon - friday
instead it is fri,mon,sat,sun,tue,thur,wed.
i already tried setting the date column to sort by ascending but no luck?
how do i fix this?

also how do i set the column headings property to all the days as you said
in your post?

Thanks Again

WStoreyII

Duane Hookom said:
A crosstab should work well. You can use Format([Date],"dddd") as the column
heading and set the column headings property to all the days.

You can use "First" on the values column in the crosstab. Do you only have
one salesperson per date per store?

--
Duane Hookom
MS Access MVP


WStoreyII said:
I am trying to make a crosstab query that will have a row heading of the
salesperson initials and the column headings will be monday through sunday.
for the values i want to insert the store that the salesperson is working in
on that day. i would also like to be able to reverse it and make the row
heading the store and the column headins monday - sunday and the initials the
value

the tables are

tbl_Schedule
-Id
-Salesperson (Number Relates To Employee Table)
-Date
-Store( number relates to Store Table)

tbl_Employees
-Id
-First
-Last
-Initials

tbl_Stores
-Id
-Name

how can i acheive this effect? is the Crosstab query the right way to go???

Thanks Again

WStoreyII
Click to expand...
Click to expand...
 
I doubt your columns are actually "fri,mon,sat,sun,tue,thur,wed". Column
Headings is a property of your crosstab query. Enter these values:
"Sunday", "Monday", "Tuesday",...
BTW: what difference does the order of the columns make? Aren't you
displaying this to your user in form or report?

--
Duane Hookom
MS Access MVP


WStoreyII said:
Duane,

That worked great, but i cant get the dates to be organized mon - friday
instead it is fri,mon,sat,sun,tue,thur,wed.
i already tried setting the date column to sort by ascending but no luck?
how do i fix this?

also how do i set the column headings property to all the days as you said
in your post?

Thanks Again

WStoreyII

Duane Hookom said:
A crosstab should work well. You can use Format([Date],"dddd") as the column
heading and set the column headings property to all the days.

You can use "First" on the values column in the crosstab. Do you only have
one salesperson per date per store?

--
Duane Hookom
MS Access MVP


WStoreyII said:
I am trying to make a crosstab query that will have a row heading of the
salesperson initials and the column headings will be monday through sunday.
for the values i want to insert the store that the salesperson is
Click to expand...
working
in
on that day. i would also like to be able to reverse it and make the row
heading the store and the column headins monday - sunday and the
Click to expand...
initials
the
value

the tables are

tbl_Schedule
-Id
-Salesperson (Number Relates To Employee Table)
-Date
-Store( number relates to Store Table)

tbl_Employees
-Id
-First
-Last
-Initials

tbl_Stores
-Id
-Name

how can i acheive this effect? is the Crosstab query the right way to go???

Thanks Again

WStoreyII
Click to expand...
Click to expand...
Click to expand...
 
Back
Top