QUERIES

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DJACKSON - 25 Oct 2007 20:19 GMT

I HAVE A QUERY IN ACCESS 97 THAT RETURNS 30 OPERATIONS (OPERATIONS IS A
FIELD) FOR ONE JOB (JOB IS A FIELD) IS THERE A WAY TO HAVE THE 30 DIFERENT
OPERATIONS BECOME FIELDS? SO I GET 1 RECORD INSTEAD OF 30

Reply to this Message

Wolfgang Kais - 25 Oct 2007 20:45 GMT

Decent, D.

> I HAVE A QUERY IN ACCESS 97 THAT RETURNS 30 OPERATIONS (OPERATIONS
> IS A FIELD) FOR ONE JOB (JOB IS A FIELD) IS THERE A WAY TO HAVE
> THE 30 DIFERENT OPERATIONS BECOME FIELDS? SO I GET 1 RECORD INSTEAD
> OF 30

Using capitals means shouting at us. Was that your intention?
I suppose not.

Well, you have to decide what value to display for a combination of
job and operation, for example the count of operations.
You then would crate a crosstab query that has three fields in the
query design window:
job - grouping, row heading
operations - grouping, column heading
operaations - count, value

Signature

Regards,
Wolfgang

Reply to this Message

DJACKSON - 25 Oct 2007 20:59 GMT

Sorry, new to discussion groups and access.

> Decent, D.
>
[quoted text clipped - 13 lines]
> operations - grouping, column heading
> operaations - count, value

Reply to this Message