Columns vrs rows

  • Thread starter Thread starter an
  • Start date Start date
A

an

Hello!

I'm completely confused...
I have a Report based on Query with field Parameter.
In Detail Section all fields are repeated in rows and only
one data in each text box in different row.
I would like to have all text boxes in same row but I
don't know to do.
I writed in each text box the similar formulae:
=IIf([Text11]="SDT";[Value];"")
where "SDT" is one Parameter of the field.
But don't work fine...
Any help is welcome.
Thanks in advance.
an
 
Please take the time to enter about 10-12 sample records and also what you
would like your final display to look like.
 
Thanks for your fast reply.

My query is:

SELECT T_All.IdPoint, T_All.Param, T_All.Date, T_All.Hora,
T_All.FreqRead, T_All.Value, T_All.Lab, T_All.InspVisual,
T_All.MedField, T_All.Unit, T_All.IdGeneral, T_All.Obs, *
FROM T_All
WHERE (((T_All.IdPoint) Like 1041 & "*") AND
((T_All.FreqRead)="Week"))
ORDER BY T_All.IdPoint, T_All.Param;

where [Lab], [InspVisual] and [MedField] are Y/N data
fields. Another fields are alphanumeric data.

I know construct Report with fields in columns but I would
like to change columns to rows to the best reading.

Thanks in advance.
an

-----Original Message-----
Please take the time to enter about 10-12 sample records and also what you
would like your final display to look like.

--
Duane Hookom
MS Access MVP


Hello!

I'm completely confused...
I have a Report based on Query with field Parameter.
In Detail Section all fields are repeated in rows and only
one data in each text box in different row.
I would like to have all text boxes in same row but I
don't know to do.
I writed in each text box the similar formulae:
=IIf([Text11]="SDT";[Value];"")
where "SDT" is one Parameter of the field.
But don't work fine...
Any help is welcome.
Thanks in advance.
an
Click to expand...


.
Click to expand...
 
I guess I don't see the sample records and desired final display?
I'm not sure why you select individual fields and then include "*". You may
want to check the query properties to see if you have Output All Fields
selected. Also, if isn't good practice to combine a number value with a
string:
1041 & "*"
I would think you might want
"1041*"

--
Duane Hookom
MS Access MVP


an said:
Thanks for your fast reply.

My query is:

SELECT T_All.IdPoint, T_All.Param, T_All.Date, T_All.Hora,
T_All.FreqRead, T_All.Value, T_All.Lab, T_All.InspVisual,
T_All.MedField, T_All.Unit, T_All.IdGeneral, T_All.Obs, *
FROM T_All
WHERE (((T_All.IdPoint) Like 1041 & "*") AND
((T_All.FreqRead)="Week"))
ORDER BY T_All.IdPoint, T_All.Param;

where [Lab], [InspVisual] and [MedField] are Y/N data
fields. Another fields are alphanumeric data.

I know construct Report with fields in columns but I would
like to change columns to rows to the best reading.

Thanks in advance.
an

-----Original Message-----
Please take the time to enter about 10-12 sample records and also what you
would like your final display to look like.

--
Duane Hookom
MS Access MVP


Hello!

I'm completely confused...
I have a Report based on Query with field Parameter.
In Detail Section all fields are repeated in rows and only
one data in each text box in different row.
I would like to have all text boxes in same row but I
don't know to do.
I writed in each text box the similar formulae:
=IIf([Text11]="SDT";[Value];"")
where "SDT" is one Parameter of the field.
But don't work fine...
Any help is welcome.
Thanks in advance.
an
Click to expand...


.
Click to expand...
Click to expand...
 
Ok.
Your question:
I have a numeric group with IdPoint of the 104100 to
104180.
In IdPoint column query I wrote "1041*" but Access assume
Like "1041*" (The query work fine).

If to construct a "normal" Report, it work fine too,
similary to Form in Single Form. One field with data
fields.

In my Report I have:

IdPoint 10410
Param Lab Unit Value
H2O

Param Lab Unit Value
Y

Param Lab Unit Value
Y/N

Param Lab Unit Value
-

etc...

But I would like the Report next sample:

IdPoint Param Lab Unit Value
104101 H2O Y Y/N -
104102 H2SO4 Y Y/N -
104103 SDT N mg/l 25
.... Conduct Y mS/cm 100
104180 Cu N Y/N -

I don't know if my explanation is possible understand.
Thanks
an


-----Original Message-----
I guess I don't see the sample records and desired final display?
I'm not sure why you select individual fields and then include "*". You may
want to check the query properties to see if you have Output All Fields
selected. Also, if isn't good practice to combine a number value with a
string:
1041 & "*"
I would think you might want
"1041*"

--
Duane Hookom
MS Access MVP


Thanks for your fast reply.

My query is:

SELECT T_All.IdPoint, T_All.Param, T_All.Date, T_All.Hora,
T_All.FreqRead, T_All.Value, T_All.Lab, T_All.InspVisual,
T_All.MedField, T_All.Unit, T_All.IdGeneral, T_All.Obs, *
FROM T_All
WHERE (((T_All.IdPoint) Like 1041 & "*") AND
((T_All.FreqRead)="Week"))
ORDER BY T_All.IdPoint, T_All.Param;

where [Lab], [InspVisual] and [MedField] are Y/N data
fields. Another fields are alphanumeric data.

I know construct Report with fields in columns but I would
like to change columns to rows to the best reading.

Thanks in advance.
an

-----Original Message-----
Please take the time to enter about 10-12 sample
Click to expand...
records
and also what you
would like your final display to look like.

--
Duane Hookom
MS Access MVP


Hello!

I'm completely confused...
I have a Report based on Query with field Parameter.
In Detail Section all fields are repeated in rows and only
one data in each text box in different row.
I would like to have all text boxes in same row but I
don't know to do.
I writed in each text box the similar formulae:
=IIf([Text11]="SDT";[Value];"")
where "SDT" is one Parameter of the field.
But don't work fine...
Any help is welcome.
Thanks in advance.
an


.
Click to expand...
Click to expand...


.
Click to expand...
 
Ok.
Your question:
I have a numeric group with IdPoint of the 104100 to
104180.
In IdPoint column query I wrote "1041*" but Access assume
Like "1041*" (The query work fine).

If to construct a "normal" Report, it work fine too,
similary to Form in Single Form. One field with data
fields.

In my Report I have:

IdPoint 10410
Param Lab Unit Value
H2O

Param Lab Unit Value
Y

Param Lab Unit Value
Y/N

Param Lab Unit Value
-

etc...

But I would like the Report next sample:

IdPoint Param Lab Unit Value
104101 H2O Y Y/N -
104102 H2SO4 Y Y/N -
104103 SDT N mg/l 25
.... Conduct Y mS/cm 100
104180 Cu N Y/N -

I don't know if my explanation is possible understand.
Thanks
an


-----Original Message-----
I guess I don't see the sample records and desired final display?
I'm not sure why you select individual fields and then include "*". You may
want to check the query properties to see if you have Output All Fields
selected. Also, if isn't good practice to combine a number value with a
string:
1041 & "*"
I would think you might want
"1041*"

--
Duane Hookom
MS Access MVP


Thanks for your fast reply.

My query is:

SELECT T_All.IdPoint, T_All.Param, T_All.Date, T_All.Hora,
T_All.FreqRead, T_All.Value, T_All.Lab, T_All.InspVisual,
T_All.MedField, T_All.Unit, T_All.IdGeneral, T_All.Obs, *
FROM T_All
WHERE (((T_All.IdPoint) Like 1041 & "*") AND
((T_All.FreqRead)="Week"))
ORDER BY T_All.IdPoint, T_All.Param;

where [Lab], [InspVisual] and [MedField] are Y/N data
fields. Another fields are alphanumeric data.

I know construct Report with fields in columns but I would
like to change columns to rows to the best reading.

Thanks in advance.
an

-----Original Message-----
Please take the time to enter about 10-12 sample
Click to expand...
records
and also what you
would like your final display to look like.

--
Duane Hookom
MS Access MVP


Hello!

I'm completely confused...
I have a Report based on Query with field Parameter.
In Detail Section all fields are repeated in rows and only
one data in each text box in different row.
I would like to have all text boxes in same row but I
don't know to do.
I writed in each text box the similar formulae:
=IIf([Text11]="SDT";[Value];"")
where "SDT" is one Parameter of the field.
But don't work fine...
Any help is welcome.
Thanks in advance.
an


.
Click to expand...
Click to expand...


.
Click to expand...
 
You stated "In my Report I have:"... Do your records look like this with
fields Param, Lab, Unit, Value,... And then you have multiple records with
the same IdPoint value but only one of the previously mentioned fields has a
value? If so, you could create a totals query that groups by IdPoint and has
the Max of Param, Lab, Unit, and Value.

If this is wrong, you might want to answer my question regarding " sample
records ".

--
Duane Hookom
MS Access MVP
--

an said:
Ok.
Your question:
I have a numeric group with IdPoint of the 104100 to
104180.
In IdPoint column query I wrote "1041*" but Access assume
Like "1041*" (The query work fine).

If to construct a "normal" Report, it work fine too,
similary to Form in Single Form. One field with data
fields.

In my Report I have:

IdPoint 10410
Param Lab Unit Value
H2O

Param Lab Unit Value
Y

Param Lab Unit Value
Y/N

Param Lab Unit Value
-

etc...

But I would like the Report next sample:

IdPoint Param Lab Unit Value
104101 H2O Y Y/N -
104102 H2SO4 Y Y/N -
104103 SDT N mg/l 25
... Conduct Y mS/cm 100
104180 Cu N Y/N -

I don't know if my explanation is possible understand.
Thanks
an


-----Original Message-----
I guess I don't see the sample records and desired final display?
I'm not sure why you select individual fields and then include "*". You may
want to check the query properties to see if you have Output All Fields
selected. Also, if isn't good practice to combine a number value with a
string:
1041 & "*"
I would think you might want
"1041*"

--
Duane Hookom
MS Access MVP


Thanks for your fast reply.

My query is:

SELECT T_All.IdPoint, T_All.Param, T_All.Date, T_All.Hora,
T_All.FreqRead, T_All.Value, T_All.Lab, T_All.InspVisual,
T_All.MedField, T_All.Unit, T_All.IdGeneral, T_All.Obs, *
FROM T_All
WHERE (((T_All.IdPoint) Like 1041 & "*") AND
((T_All.FreqRead)="Week"))
ORDER BY T_All.IdPoint, T_All.Param;

where [Lab], [InspVisual] and [MedField] are Y/N data
fields. Another fields are alphanumeric data.

I know construct Report with fields in columns but I would
like to change columns to rows to the best reading.

Thanks in advance.
an


-----Original Message-----
Please take the time to enter about 10-12 sample records
and also what you
would like your final display to look like.

--
Duane Hookom
MS Access MVP


message
Hello!

I'm completely confused...
I have a Report based on Query with field Parameter.
In Detail Section all fields are repeated in rows and
only
one data in each text box in different row.
I would like to have all text boxes in same row but I
don't know to do.
I writed in each text box the similar formulae:
=IIf([Text11]="SDT";[Value];"")
where "SDT" is one Parameter of the field.
But don't work fine...
Any help is welcome.
Thanks in advance.
an


.
Click to expand...


.
Click to expand...
Click to expand...
 
Ok.
It's a good idea!
I think is solved my problem.
Many thanks for your help.
an
-----Original Message-----
You stated "In my Report I have:"... Do your records look like this with
fields Param, Lab, Unit, Value,... And then you have multiple records with
the same IdPoint value but only one of the previously mentioned fields has a
value? If so, you could create a totals query that groups by IdPoint and has
the Max of Param, Lab, Unit, and Value.

If this is wrong, you might want to answer my question regarding " sample
records ".

--
Duane Hookom
MS Access MVP
--

Ok.
Your question:
I have a numeric group with IdPoint of the 104100 to
104180.
In IdPoint column query I wrote "1041*" but Access assume
Like "1041*" (The query work fine).

If to construct a "normal" Report, it work fine too,
similary to Form in Single Form. One field with data
fields.

In my Report I have:

IdPoint 10410
Param Lab Unit Value
H2O

Param Lab Unit Value
Y

Param Lab Unit Value
Y/N

Param Lab Unit Value
-

etc...

But I would like the Report next sample:

IdPoint Param Lab Unit Value
104101 H2O Y Y/N -
104102 H2SO4 Y Y/N -
104103 SDT N mg/l 25
... Conduct Y mS/cm 100
104180 Cu N Y/N -

I don't know if my explanation is possible understand.
Thanks
an


-----Original Message-----
I guess I don't see the sample records and desired
Click to expand...
final
display?
I'm not sure why you select individual fields and then include "*". You may
want to check the query properties to see if you have Output All Fields
selected. Also, if isn't good practice to combine a number value with a
string:
1041 & "*"
I would think you might want
"1041*"

--
Duane Hookom
MS Access MVP


Thanks for your fast reply.

My query is:

SELECT T_All.IdPoint, T_All.Param, T_All.Date, T_All.Hora,
T_All.FreqRead, T_All.Value, T_All.Lab, T_All.InspVisual,
T_All.MedField, T_All.Unit, T_All.IdGeneral,
Click to expand...
T_All.Obs,
*
FROM T_All
WHERE (((T_All.IdPoint) Like 1041 & "*") AND
((T_All.FreqRead)="Week"))
ORDER BY T_All.IdPoint, T_All.Param;

where [Lab], [InspVisual] and [MedField] are Y/N data
fields. Another fields are alphanumeric data.

I know construct Report with fields in columns but I would
like to change columns to rows to the best reading.

Thanks in advance.
an


-----Original Message-----
Please take the time to enter about 10-12 sample records
and also what you
would like your final display to look like.

--
Duane Hookom
MS Access MVP


message
Hello!

I'm completely confused...
I have a Report based on Query with field Parameter.
In Detail Section all fields are repeated in rows and
only
one data in each text box in different row.
I would like to have all text boxes in same row but I
don't know to do.
I writed in each text box the similar formulae:
=IIf([Text11]="SDT";[Value];"")
where "SDT" is one Parameter of the field.
But don't work fine...
Any help is welcome.
Thanks in advance.
an


.



.
Click to expand...
Click to expand...


.
Click to expand...
 
Back
Top