Re: A dynamic table in a report. Is it possible?

Tech-Archive recommends: Fix windows errors by optimizing your registry

I doubt it.

--
Duane Hookom
MS Access MVP

"Monkey_O" <MonkeyO@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:58D3183A-A650-4468-8B59-826D73C287A1@xxxxxxxxxxxxxxxx
I mean display the data*** results of the crosstab query in a report. I
know you can paste sub forms or sub reports, but can you do the same with
datasheets?

"Duane Hookom" wrote:

I don't know what you mean by "take a snapshot".

--
Duane Hookom
MS Access MVP

"Monkey_O" <MonkeyO@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5B22BB54-6A12-447C-97AB-4CB03B1C2FBA@xxxxxxxxxxxxxxxx
I just realized that it might be a lot easier to just take a snapshot,
so
to
speak, of the cross tab query tabke, and put that in the report. The
table
for the cross tab query dynamically adds columns for me.

Is this a better solution? Or is it even possible?

"Monkey_O" wrote:

Alright, I have been playing around using a form with my cross tab
query,
and
it displays fine now in a form at the moment. The problem is, if I
were
to
add a new employee, it would not show up on the form. Since my
employees
are
the column headers, the form won't dynamically draw a new column for
me,
meaning that whenever I want to add a new employee, the form needs to
be
modified.

The only way I can see this being solved is going into code, looping
through
the query, and create a new label for each column. This would be the
same
for
both a report and a form.

Is there an easier way to do this?

"Monkey_O" wrote:

I have a table with three columns, two of which are a joint primary
key. The
primary key consists of a column with a date, and the other is a
column
for
an employee ID (there is a seperate table that stores all the
employee's
information). The third column simply contains a number.

What I want is a report where it's kind of like a table: across the
top
are
all the employees, down the left are the dates, and where the two
values join
up is the number. Basically, it will look like an excel table.

Is this possible?





.

Quantcast