QUERIES

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

Guest

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
 
Decent, D.

DJACKSON said:
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
Click to expand...

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
 
Sorry, new to discussion groups and access.

Wolfgang Kais said:
Decent, D.



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
Click to expand...
 
Back
Top