S
Steve The Ignorant \(but trying\)
I have a crosstab query that shows a two week period of
time (day of month across the top, name on left, and
attendance exceptions in the datafields). I have this
set up as a sub form and there is other information on
the form regarding department...
The problem is that it worked great yesterday when I made
it, the dates across the top started at 8 and the data
corresponded. Today it doesn't work. The dates across
the top are correct but the data does not correspond.
The first column shows the data from the 8th instead of
the 9th. Of course there is no data for the 8th and it
shows "Name?"
How can I input the current crosstab query, which is
correct into the form?
The data comes from a table with attributes Name,
Exception, and ScheduleDate if this helps. I'm thinking
that perhaps a crosstab query isn't the solution.
Thanks for the help.
time (day of month across the top, name on left, and
attendance exceptions in the datafields). I have this
set up as a sub form and there is other information on
the form regarding department...
The problem is that it worked great yesterday when I made
it, the dates across the top started at 8 and the data
corresponded. Today it doesn't work. The dates across
the top are correct but the data does not correspond.
The first column shows the data from the 8th instead of
the 9th. Of course there is no data for the 8th and it
shows "Name?"
How can I input the current crosstab query, which is
correct into the form?
The data comes from a table with attributes Name,
Exception, and ScheduleDate if this helps. I'm thinking
that perhaps a crosstab query isn't the solution.
Thanks for the help.