Report problem

[Guest]

This question deals with the report and the underlying table. I am entering
information in by Grid ID (ex. A25, A26, B5, C10). So, the report prompts
you for a Grid ID and everything about that grid shows up in the report.

My question is that in the Grid ID column, if I entered in "A25, A26, B10,
E5", how to I tell the report to pull just the information from A25 or A26.
How does it read the entire string of numbers and know I only want 1 part of
the information?

 

[Rick B]

To find a string in a field, you'd use...

Like "*" & [Enter desired grid] &"*"



But, the bigger issue here is that your data seems flawed. A field in a
record should contain exactly one piece of information. If you have three
"grid id's" then you should have three records - one for each grid id.

 

[Guest]

Rick

Thanks for the help. All the grids were collected together so the rest of
the information in the report deals with all those grids collected.

Where would I put the Like "*" & [Enter desired grid] &"*"....Does it go in
the query that the report is built off of?

To find a string in a field, you'd use...

Like "*" & [Enter desired grid] &"*"



But, the bigger issue here is that your data seems flawed. A field in a
record should contain exactly one piece of information. If you have three
"grid id's" then you should have three records - one for each grid id.



--
Rick B

This question deals with the report and the underlying table. I am
entering
information in by Grid ID (ex. A25, A26, B5, C10). So, the report prompts
you for a Grid ID and everything about that grid shows up in the report.

My question is that in the Grid ID column, if I entered in "A25, A26, B10,
E5", how to I tell the report to pull just the information from A25 or
A26.
How does it read the entire string of numbers and know I only want 1 part
of
the information?

 

[Rick B]

Yes. In the query.


--
Rick B

Rick

Thanks for the help. All the grids were collected together so the rest of
the information in the report deals with all those grids collected.

Where would I put the Like "*" & [Enter desired grid] &"*"....Does it go
in
the query that the report is built off of?

To find a string in a field, you'd use...

Like "*" & [Enter desired grid] &"*"



But, the bigger issue here is that your data seems flawed. A field in a
record should contain exactly one piece of information. If you have
three
"grid id's" then you should have three records - one for each grid id.



--
Rick B

This question deals with the report and the underlying table. I am
entering
information in by Grid ID (ex. A25, A26, B5, C10). So, the report
prompts
you for a Grid ID and everything about that grid shows up in the
report.

My question is that in the Grid ID column, if I entered in "A25, A26,
B10,
E5", how to I tell the report to pull just the information from A25 or
A26.
How does it read the entire string of numbers and know I only want 1
part
of
the information?

 

[Guest]

Rick-

Maybe you can help with my next problem! The Like clause works but in ther
report under Grid ID, the report lists the entire string. So when I enter
B5, the report shows "A5, B5, B6, C6". Is there a way to have the B5
highlighted or in a different font color?

Yes. In the query.


--
Rick B

Rick

Thanks for the help. All the grids were collected together so the rest of
the information in the report deals with all those grids collected.

Where would I put the Like "*" & [Enter desired grid] &"*"....Does it go
in
the query that the report is built off of?

To find a string in a field, you'd use...

Like "*" & [Enter desired grid] &"*"



But, the bigger issue here is that your data seems flawed. A field in a
record should contain exactly one piece of information. If you have
three
"grid id's" then you should have three records - one for each grid id.



--
Rick B



This question deals with the report and the underlying table. I am
entering
information in by Grid ID (ex. A25, A26, B5, C10). So, the report
prompts
you for a Grid ID and everything about that grid shows up in the
report.

My question is that in the Grid ID column, if I entered in "A25, A26,
B10,
E5", how to I tell the report to pull just the information from A25 or
A26.
How does it read the entire string of numbers and know I only want 1
part
of
the information?

 

[Rick B]

Probably, but I am not sure how. I guess you could simply put your user's
prompt there on the report instead of the data field.

Again, if it were me, I'd create one record for each, even if it means you
have to run some code to fix your existing records.

--
Rick B

Rick-

Maybe you can help with my next problem! The Like clause works but in
ther
report under Grid ID, the report lists the entire string. So when I enter
B5, the report shows "A5, B5, B6, C6". Is there a way to have the B5
highlighted or in a different font color?

Yes. In the query.


--
Rick B

Rick

Thanks for the help. All the grids were collected together so the rest
of
the information in the report deals with all those grids collected.

Where would I put the Like "*" & [Enter desired grid] &"*"....Does it
go
in
the query that the report is built off of?

:

To find a string in a field, you'd use...

Like "*" & [Enter desired grid] &"*"



But, the bigger issue here is that your data seems flawed. A field in
a
record should contain exactly one piece of information. If you have
three
"grid id's" then you should have three records - one for each grid id.



--
Rick B



This question deals with the report and the underlying table. I am
entering
information in by Grid ID (ex. A25, A26, B5, C10). So, the report
prompts
you for a Grid ID and everything about that grid shows up in the
report.

My question is that in the Grid ID column, if I entered in "A25,
A26,
B10,
E5", how to I tell the report to pull just the information from A25
or
A26.
How does it read the entire string of numbers and know I only want 1
part
of
the information?