Report weirdness....

  • Thread starter Thread starter Sue
  • Start date Start date
S

Sue

I've tried to insert a field in my report.
The field is drawn from a query.
The field in the query is pulled from a table that contains these fields:
PtID (autonumber, primary key)
LastName (text)
FirstName (text)
MRN (text)

I want to include LastName, FirstName, & MRN on my report. My preference
would be to use a cancatenated expression:
Patient: [lastname] & ", " & [firstname] & " " & [MRN]
I have created that expression as a field, Pt, in my query, and have tried a
variety of ways to get it to display in my report. Finally, using a combo
box, it displays correctly. BUT... when I run the report, the following
"enter parameter value" dialog box pops up:
Lookup_Pt_ID.Pt
If I blow by that (say OK), the report looks just like I want it.

I've seen this phenomenon before & it puzzles me - I'm getting this dialog
box & (a) don't know how to get rid of it and (b) don't know why, if it's
asking for a parameter value, the darn thing WORKS.

Any help would be hugely appreciated.
 
I did something similar in my report. I have the query with the items I want
to show in the report i.e. [lastname],[firstname],[MRN]

then in the report i put something like the following as the control souce
of my text box:

=[lastname]+", "+[firstname]+" "+[MRN]

I hope this helps.
 
Thanks for the suggestion, but I'm still getting the parameter query,
probably because the expression comes from fields in a table or something.
I'm hoping one of the MVPs will pick up on this thread & let me know why
this seems to happen sometimes - I can't figure out what I'm doing that leads
to this situation.
--
Thanks for your time!


ATSBC03 said:
I did something similar in my report. I have the query with the items I want
to show in the report i.e. [lastname],[firstname],[MRN]

then in the report i put something like the following as the control souce
of my text box:

=[lastname]+", "+[firstname]+" "+[MRN]

I hope this helps.


Sue said:
I've tried to insert a field in my report.
The field is drawn from a query.
The field in the query is pulled from a table that contains these fields:
PtID (autonumber, primary key)
LastName (text)
FirstName (text)
MRN (text)

I want to include LastName, FirstName, & MRN on my report. My preference
would be to use a cancatenated expression:
Patient: [lastname] & ", " & [firstname] & " " & [MRN]
I have created that expression as a field, Pt, in my query, and have tried a
variety of ways to get it to display in my report. Finally, using a combo
box, it displays correctly. BUT... when I run the report, the following
"enter parameter value" dialog box pops up:
Lookup_Pt_ID.Pt
If I blow by that (say OK), the report looks just like I want it.

I've seen this phenomenon before & it puzzles me - I'm getting this dialog
box & (a) don't know how to get rid of it and (b) don't know why, if it's
asking for a parameter value, the darn thing WORKS.

Any help would be hugely appreciated.
Click to expand...
Click to expand...
 
Do you have this field/expression in the sorting and grouping dialog? Have
you checked all control sources and the Filter property?

BTW: it is most proper to use "&" (as you have) rather than "+" to
concatenate text values.

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


Sue said:
Thanks for the suggestion, but I'm still getting the parameter query,
probably because the expression comes from fields in a table or something.
I'm hoping one of the MVPs will pick up on this thread & let me know why
this seems to happen sometimes - I can't figure out what I'm doing that leads
to this situation.
--
Thanks for your time!


ATSBC03 said:
I did something similar in my report. I have the query with the items I want
to show in the report i.e. [lastname],[firstname],[MRN]

then in the report i put something like the following as the control souce
of my text box:

=[lastname]+", "+[firstname]+" "+[MRN]

I hope this helps.


Sue said:
I've tried to insert a field in my report.
The field is drawn from a query.
The field in the query is pulled from a table that contains these fields:
PtID (autonumber, primary key)
LastName (text)
FirstName (text)
MRN (text)

I want to include LastName, FirstName, & MRN on my report. My preference
would be to use a cancatenated expression:
Patient: [lastname] & ", " & [firstname] & " " & [MRN]
I have created that expression as a field, Pt, in my query, and have tried a
variety of ways to get it to display in my report. Finally, using a combo
box, it displays correctly. BUT... when I run the report, the following
"enter parameter value" dialog box pops up:
Lookup_Pt_ID.Pt
If I blow by that (say OK), the report looks just like I want it.

I've seen this phenomenon before & it puzzles me - I'm getting this dialog
box & (a) don't know how to get rid of it and (b) don't know why, if it's
asking for a parameter value, the darn thing WORKS.

Any help would be hugely appreciated.
Click to expand...
Click to expand...
Click to expand...
 
My sorting/grouping expression is "Pt" - no table mentioned (sorry if I said
something misleading).
And thanks for pointing out the obvious (duh)... There's a blank space under
"filter" in the properties for the report.

Again, thanks for your time.

--
Thanks for your time!


Duane Hookom said:
Why isn't your sorting and grouping expression just the field name
[pt]
You shouldn't need any table names unless you had two fields in your
report's field list with the same name (never a good idea).

You will find the report's Filter property in the report's properties (how's
that for stating the obvious)?
--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


Sue said:
Yes, Duane, the field/expression is in the sorting & grouping & "points" to
where I'd expect it to there (ie to Pt).
I've double-checked the control sources, and they seem fine.
I haven't checked the filter property & don't know how to do so.
And thanks for the reassurance on the &/+ issue.

Thanks for your help & time!


--
Thanks for your time!


Duane Hookom said:
Do you have this field/expression in the sorting and grouping dialog? Have
you checked all control sources and the Filter property?

BTW: it is most proper to use "&" (as you have) rather than "+" to
concatenate text values.

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


:

Thanks for the suggestion, but I'm still getting the parameter query,
probably because the expression comes from fields in a table or something.
I'm hoping one of the MVPs will pick up on this thread & let me know why
this seems to happen sometimes - I can't figure out what I'm doing that leads
to this situation.
--
Thanks for your time!


:

I did something similar in my report. I have the query with the items I want
to show in the report i.e. [lastname],[firstname],[MRN]

then in the report i put something like the following as the control souce
of my text box:

=[lastname]+", "+[firstname]+" "+[MRN]

I hope this helps.


:

I've tried to insert a field in my report.
The field is drawn from a query.
The field in the query is pulled from a table that contains these fields:
PtID (autonumber, primary key)
LastName (text)
FirstName (text)
MRN (text)

I want to include LastName, FirstName, & MRN on my report. My preference
would be to use a cancatenated expression:
Patient: [lastname] & ", " & [firstname] & " " & [MRN]
I have created that expression as a field, Pt, in my query, and have tried a
variety of ways to get it to display in my report. Finally, using a combo
box, it displays correctly. BUT... when I run the report, the following
"enter parameter value" dialog box pops up:
Lookup_Pt_ID.Pt
If I blow by that (say OK), the report looks just like I want it.

I've seen this phenomenon before & it puzzles me - I'm getting this dialog
box & (a) don't know how to get rid of it and (b) don't know why, if it's
asking for a parameter value, the darn thing WORKS.

Any help would be hugely appreciated.
Click to expand...
Click to expand...
Click to expand...
 
Why isn't your sorting and grouping expression just the field name
[pt]
You shouldn't need any table names unless you had two fields in your
report's field list with the same name (never a good idea).

You will find the report's Filter property in the report's properties (how's
that for stating the obvious)?
--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


Sue said:
Yes, Duane, the field/expression is in the sorting & grouping & "points" to
where I'd expect it to there (ie to Pt).
I've double-checked the control sources, and they seem fine.
I haven't checked the filter property & don't know how to do so.
And thanks for the reassurance on the &/+ issue.

Thanks for your help & time!


--
Thanks for your time!


Duane Hookom said:
Do you have this field/expression in the sorting and grouping dialog? Have
you checked all control sources and the Filter property?

BTW: it is most proper to use "&" (as you have) rather than "+" to
concatenate text values.

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


Sue said:
Thanks for the suggestion, but I'm still getting the parameter query,
probably because the expression comes from fields in a table or something.
I'm hoping one of the MVPs will pick up on this thread & let me know why
this seems to happen sometimes - I can't figure out what I'm doing that leads
to this situation.
--
Thanks for your time!


:

I did something similar in my report. I have the query with the items I want
to show in the report i.e. [lastname],[firstname],[MRN]

then in the report i put something like the following as the control souce
of my text box:

=[lastname]+", "+[firstname]+" "+[MRN]

I hope this helps.


:

I've tried to insert a field in my report.
The field is drawn from a query.
The field in the query is pulled from a table that contains these fields:
PtID (autonumber, primary key)
LastName (text)
FirstName (text)
MRN (text)

I want to include LastName, FirstName, & MRN on my report. My preference
would be to use a cancatenated expression:
Patient: [lastname] & ", " & [firstname] & " " & [MRN]
I have created that expression as a field, Pt, in my query, and have tried a
variety of ways to get it to display in my report. Finally, using a combo
box, it displays correctly. BUT... when I run the report, the following
"enter parameter value" dialog box pops up:
Lookup_Pt_ID.Pt
If I blow by that (say OK), the report looks just like I want it.

I've seen this phenomenon before & it puzzles me - I'm getting this dialog
box & (a) don't know how to get rid of it and (b) don't know why, if it's
asking for a parameter value, the darn thing WORKS.

Any help would be hugely appreciated.
Click to expand...
Click to expand...
Click to expand...
 
Yes, Duane, the field/expression is in the sorting & grouping & "points" to
where I'd expect it to there (ie to Pt).
I've double-checked the control sources, and they seem fine.
I haven't checked the filter property & don't know how to do so.
And thanks for the reassurance on the &/+ issue.

Thanks for your help & time!


--
Thanks for your time!


Duane Hookom said:
Do you have this field/expression in the sorting and grouping dialog? Have
you checked all control sources and the Filter property?

BTW: it is most proper to use "&" (as you have) rather than "+" to
concatenate text values.

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


Sue said:
Thanks for the suggestion, but I'm still getting the parameter query,
probably because the expression comes from fields in a table or something.
I'm hoping one of the MVPs will pick up on this thread & let me know why
this seems to happen sometimes - I can't figure out what I'm doing that leads
to this situation.
--
Thanks for your time!


ATSBC03 said:
I did something similar in my report. I have the query with the items I want
to show in the report i.e. [lastname],[firstname],[MRN]

then in the report i put something like the following as the control souce
of my text box:

=[lastname]+", "+[firstname]+" "+[MRN]

I hope this helps.


:

I've tried to insert a field in my report.
The field is drawn from a query.
The field in the query is pulled from a table that contains these fields:
PtID (autonumber, primary key)
LastName (text)
FirstName (text)
MRN (text)

I want to include LastName, FirstName, & MRN on my report. My preference
would be to use a cancatenated expression:
Patient: [lastname] & ", " & [firstname] & " " & [MRN]
I have created that expression as a field, Pt, in my query, and have tried a
variety of ways to get it to display in my report. Finally, using a combo
box, it displays correctly. BUT... when I run the report, the following
"enter parameter value" dialog box pops up:
Lookup_Pt_ID.Pt
If I blow by that (say OK), the report looks just like I want it.

I've seen this phenomenon before & it puzzles me - I'm getting this dialog
box & (a) don't know how to get rid of it and (b) don't know why, if it's
asking for a parameter value, the darn thing WORKS.

Any help would be hugely appreciated.
Click to expand...
Click to expand...
Click to expand...
 
Are you still experiencing "weirdness" in your report or is it behaving? You
may need to work with a copy and start deleting controls and/or sections to
see if it makes a difference.
--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


Sue said:
My sorting/grouping expression is "Pt" - no table mentioned (sorry if I said
something misleading).
And thanks for pointing out the obvious (duh)... There's a blank space under
"filter" in the properties for the report.

Again, thanks for your time.

--
Thanks for your time!


Duane Hookom said:
Why isn't your sorting and grouping expression just the field name
[pt]
You shouldn't need any table names unless you had two fields in your
report's field list with the same name (never a good idea).

You will find the report's Filter property in the report's properties (how's
that for stating the obvious)?
--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


Sue said:
Yes, Duane, the field/expression is in the sorting & grouping & "points" to
where I'd expect it to there (ie to Pt).
I've double-checked the control sources, and they seem fine.
I haven't checked the filter property & don't know how to do so.
And thanks for the reassurance on the &/+ issue.

Thanks for your help & time!


--
Thanks for your time!


:

Do you have this field/expression in the sorting and grouping dialog? Have
you checked all control sources and the Filter property?

BTW: it is most proper to use "&" (as you have) rather than "+" to
concatenate text values.

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


:

Thanks for the suggestion, but I'm still getting the parameter query,
probably because the expression comes from fields in a table or something.
I'm hoping one of the MVPs will pick up on this thread & let me know why
this seems to happen sometimes - I can't figure out what I'm doing that leads
to this situation.
--
Thanks for your time!


:

I did something similar in my report. I have the query with the items I want
to show in the report i.e. [lastname],[firstname],[MRN]

then in the report i put something like the following as the control souce
of my text box:

=[lastname]+", "+[firstname]+" "+[MRN]

I hope this helps.


:

I've tried to insert a field in my report.
The field is drawn from a query.
The field in the query is pulled from a table that contains these fields:
PtID (autonumber, primary key)
LastName (text)
FirstName (text)
MRN (text)

I want to include LastName, FirstName, & MRN on my report. My preference
would be to use a cancatenated expression:
Patient: [lastname] & ", " & [firstname] & " " & [MRN]
I have created that expression as a field, Pt, in my query, and have tried a
variety of ways to get it to display in my report. Finally, using a combo
box, it displays correctly. BUT... when I run the report, the following
"enter parameter value" dialog box pops up:
Lookup_Pt_ID.Pt
If I blow by that (say OK), the report looks just like I want it.

I've seen this phenomenon before & it puzzles me - I'm getting this dialog
box & (a) don't know how to get rid of it and (b) don't know why, if it's
asking for a parameter value, the darn thing WORKS.

Any help would be hugely appreciated.
Click to expand...
Click to expand...
Click to expand...
 
Yes, same thing is still happening.
I've tried removing JUST the control involved, & the report works fine.
I've tried putting the control back in as a combo box & still get the prompt
to enter parameter value.
I've tried putting the control back in as a text box & still get the prompt
to enter parameter value.
Now here's the REALLY strange thing - I try it without having this field at
ALL (neither as a text box nor as a combo box) & STILL get the prompt to
enter parameter value.
Please help???

--
Thanks for your time!


Duane Hookom said:
Are you still experiencing "weirdness" in your report or is it behaving? You
may need to work with a copy and start deleting controls and/or sections to
see if it makes a difference.
--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


Sue said:
My sorting/grouping expression is "Pt" - no table mentioned (sorry if I said
something misleading).
And thanks for pointing out the obvious (duh)... There's a blank space under
"filter" in the properties for the report.

Again, thanks for your time.

--
Thanks for your time!


Duane Hookom said:
Why isn't your sorting and grouping expression just the field name
[pt]
You shouldn't need any table names unless you had two fields in your
report's field list with the same name (never a good idea).

You will find the report's Filter property in the report's properties (how's
that for stating the obvious)?
--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


:

Yes, Duane, the field/expression is in the sorting & grouping & "points" to
where I'd expect it to there (ie to Pt).
I've double-checked the control sources, and they seem fine.
I haven't checked the filter property & don't know how to do so.
And thanks for the reassurance on the &/+ issue.

Thanks for your help & time!


--
Thanks for your time!


:

Do you have this field/expression in the sorting and grouping dialog? Have
you checked all control sources and the Filter property?

BTW: it is most proper to use "&" (as you have) rather than "+" to
concatenate text values.

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


:

Thanks for the suggestion, but I'm still getting the parameter query,
probably because the expression comes from fields in a table or something.
I'm hoping one of the MVPs will pick up on this thread & let me know why
this seems to happen sometimes - I can't figure out what I'm doing that leads
to this situation.
--
Thanks for your time!


:

I did something similar in my report. I have the query with the items I want
to show in the report i.e. [lastname],[firstname],[MRN]

then in the report i put something like the following as the control souce
of my text box:

=[lastname]+", "+[firstname]+" "+[MRN]

I hope this helps.


:

I've tried to insert a field in my report.
The field is drawn from a query.
The field in the query is pulled from a table that contains these fields:
PtID (autonumber, primary key)
LastName (text)
FirstName (text)
MRN (text)

I want to include LastName, FirstName, & MRN on my report. My preference
would be to use a cancatenated expression:
Patient: [lastname] & ", " & [firstname] & " " & [MRN]
I have created that expression as a field, Pt, in my query, and have tried a
variety of ways to get it to display in my report. Finally, using a combo
box, it displays correctly. BUT... when I run the report, the following
"enter parameter value" dialog box pops up:
Lookup_Pt_ID.Pt
If I blow by that (say OK), the report looks just like I want it.

I've seen this phenomenon before & it puzzles me - I'm getting this dialog
box & (a) don't know how to get rid of it and (b) don't know why, if it's
asking for a parameter value, the darn thing WORKS.

Any help would be hugely appreciated.
Click to expand...
Click to expand...
Click to expand...
 
What does your sql look like? It should look like:

SELECT PtID, 'Patient: ' & [Lastname] &', '& [Firstname] &' ' & MRN as
PatientName
FROM PatientInfo
ORDER BY [Lastname];

This will give you two columns in your combo box. Make sure that in the
properties for the combo box you set the "Number of Columns" to "2" and
adjust the column widths to not display the the "PtID" column, ie "Column
Widths: 0";1.25".

Also if in your query you have placed a criteria to filter the data and the
query cannot find the location of that information, ie, referenceing a field
Yes, same thing is still happening.
I've tried removing JUST the control involved, & the report works fine.
I've tried putting the control back in as a combo box & still get the prompt
to enter parameter value.
I've tried putting the control back in as a text box & still get the prompt
to enter parameter value.
Now here's the REALLY strange thing - I try it without having this field at
ALL (neither as a text box nor as a combo box) & STILL get the prompt to
enter parameter value.
Please help???

--
Thanks for your time!


Duane Hookom said:
Are you still experiencing "weirdness" in your report or is it behaving? You
may need to work with a copy and start deleting controls and/or sections to
see if it makes a difference.
--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


Sue said:
My sorting/grouping expression is "Pt" - no table mentioned (sorry if I said
something misleading).
And thanks for pointing out the obvious (duh)... There's a blank space under
"filter" in the properties for the report.

Again, thanks for your time.

--
Thanks for your time!


:

Why isn't your sorting and grouping expression just the field name
[pt]
You shouldn't need any table names unless you had two fields in your
report's field list with the same name (never a good idea).

You will find the report's Filter property in the report's properties (how's
that for stating the obvious)?
--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


:

Yes, Duane, the field/expression is in the sorting & grouping & "points" to
where I'd expect it to there (ie to Pt).
I've double-checked the control sources, and they seem fine.
I haven't checked the filter property & don't know how to do so.
And thanks for the reassurance on the &/+ issue.

Thanks for your help & time!


--
Thanks for your time!


:

Do you have this field/expression in the sorting and grouping dialog? Have
you checked all control sources and the Filter property?

BTW: it is most proper to use "&" (as you have) rather than "+" to
concatenate text values.

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


:

Thanks for the suggestion, but I'm still getting the parameter query,
probably because the expression comes from fields in a table or something.
I'm hoping one of the MVPs will pick up on this thread & let me know why
this seems to happen sometimes - I can't figure out what I'm doing that leads
to this situation.
--
Thanks for your time!


:

I did something similar in my report. I have the query with the items I want
to show in the report i.e. [lastname],[firstname],[MRN]

then in the report i put something like the following as the control souce
of my text box:

=[lastname]+", "+[firstname]+" "+[MRN]

I hope this helps.


:

I've tried to insert a field in my report.
The field is drawn from a query.
The field in the query is pulled from a table that contains these fields:
PtID (autonumber, primary key)
LastName (text)
FirstName (text)
MRN (text)

I want to include LastName, FirstName, & MRN on my report. My preference
would be to use a cancatenated expression:
Patient: [lastname] & ", " & [firstname] & " " & [MRN]
I have created that expression as a field, Pt, in my query, and have tried a
variety of ways to get it to display in my report. Finally, using a combo
box, it displays correctly. BUT... when I run the report, the following
"enter parameter value" dialog box pops up:
Lookup_Pt_ID.Pt
If I blow by that (say OK), the report looks just like I want it.

I've seen this phenomenon before & it puzzles me - I'm getting this dialog
box & (a) don't know how to get rid of it and (b) don't know why, if it's
asking for a parameter value, the darn thing WORKS.

Any help would be hugely appreciated.
Click to expand...
Click to expand...
Click to expand...
 
My query works fine, Joseph - it's the report based on the query I'm getting
this weirdness on. I'm not sure what you mean by having a filter in a query -
but since I don't know how to do this, I'm assuming I haven't done so.

Any other thoughts?

--
Thanks for your time!


Joseph said:
What does your sql look like? It should look like:

SELECT PtID, 'Patient: ' & [Lastname] &', '& [Firstname] &' ' & MRN as
PatientName
FROM PatientInfo
ORDER BY [Lastname];

This will give you two columns in your combo box. Make sure that in the
properties for the combo box you set the "Number of Columns" to "2" and
adjust the column widths to not display the the "PtID" column, ie "Column
Widths: 0";1.25".

Also if in your query you have placed a criteria to filter the data and the
query cannot find the location of that information, ie, referenceing a field
Yes, same thing is still happening.
I've tried removing JUST the control involved, & the report works fine.
I've tried putting the control back in as a combo box & still get the prompt
to enter parameter value.
I've tried putting the control back in as a text box & still get the prompt
to enter parameter value.
Now here's the REALLY strange thing - I try it without having this field at
ALL (neither as a text box nor as a combo box) & STILL get the prompt to
enter parameter value.
Please help???

--
Thanks for your time!


Duane Hookom said:
Are you still experiencing "weirdness" in your report or is it behaving? You
may need to work with a copy and start deleting controls and/or sections to
see if it makes a difference.
--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


:

My sorting/grouping expression is "Pt" - no table mentioned (sorry if I said
something misleading).
And thanks for pointing out the obvious (duh)... There's a blank space under
"filter" in the properties for the report.

Again, thanks for your time.

--
Thanks for your time!


:

Why isn't your sorting and grouping expression just the field name
[pt]
You shouldn't need any table names unless you had two fields in your
report's field list with the same name (never a good idea).

You will find the report's Filter property in the report's properties (how's
that for stating the obvious)?
--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


:

Yes, Duane, the field/expression is in the sorting & grouping & "points" to
where I'd expect it to there (ie to Pt).
I've double-checked the control sources, and they seem fine.
I haven't checked the filter property & don't know how to do so.
And thanks for the reassurance on the &/+ issue.

Thanks for your help & time!


--
Thanks for your time!


:

Do you have this field/expression in the sorting and grouping dialog? Have
you checked all control sources and the Filter property?

BTW: it is most proper to use "&" (as you have) rather than "+" to
concatenate text values.

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


:

Thanks for the suggestion, but I'm still getting the parameter query,
probably because the expression comes from fields in a table or something.
I'm hoping one of the MVPs will pick up on this thread & let me know why
this seems to happen sometimes - I can't figure out what I'm doing that leads
to this situation.
--
Thanks for your time!


:

I did something similar in my report. I have the query with the items I want
to show in the report i.e. [lastname],[firstname],[MRN]

then in the report i put something like the following as the control souce
of my text box:

=[lastname]+", "+[firstname]+" "+[MRN]

I hope this helps.


:

I've tried to insert a field in my report.
The field is drawn from a query.
The field in the query is pulled from a table that contains these fields:
PtID (autonumber, primary key)
LastName (text)
FirstName (text)
MRN (text)

I want to include LastName, FirstName, & MRN on my report. My preference
would be to use a cancatenated expression:
Patient: [lastname] & ", " & [firstname] & " " & [MRN]
I have created that expression as a field, Pt, in my query, and have tried a
variety of ways to get it to display in my report. Finally, using a combo
box, it displays correctly. BUT... when I run the report, the following
"enter parameter value" dialog box pops up:
Lookup_Pt_ID.Pt
If I blow by that (say OK), the report looks just like I want it.

I've seen this phenomenon before & it puzzles me - I'm getting this dialog
box & (a) don't know how to get rid of it and (b) don't know why, if it's
asking for a parameter value, the darn thing WORKS.

Any help would be hugely appreciated.
Click to expand...
Click to expand...
Click to expand...
 
Do any of your control sources use the table and field name like
"Lookup_Pt_ID.Pt"? Did you begin removing controls/sections from a copy of
the report until the issue goes away?

If you can't figure this out, you may need to rebuild the report.

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


Sue said:
My query works fine, Joseph - it's the report based on the query I'm getting
this weirdness on. I'm not sure what you mean by having a filter in a query -
but since I don't know how to do this, I'm assuming I haven't done so.

Any other thoughts?

--
Thanks for your time!


Joseph said:
What does your sql look like? It should look like:

SELECT PtID, 'Patient: ' & [Lastname] &', '& [Firstname] &' ' & MRN as
PatientName
FROM PatientInfo
ORDER BY [Lastname];

This will give you two columns in your combo box. Make sure that in the
properties for the combo box you set the "Number of Columns" to "2" and
adjust the column widths to not display the the "PtID" column, ie "Column
Widths: 0";1.25".

Also if in your query you have placed a criteria to filter the data and the
query cannot find the location of that information, ie, referenceing a field
Yes, same thing is still happening.
I've tried removing JUST the control involved, & the report works fine.
I've tried putting the control back in as a combo box & still get the prompt
to enter parameter value.
I've tried putting the control back in as a text box & still get the prompt
to enter parameter value.
Now here's the REALLY strange thing - I try it without having this field at
ALL (neither as a text box nor as a combo box) & STILL get the prompt to
enter parameter value.
Please help???

--
Thanks for your time!


:

Are you still experiencing "weirdness" in your report or is it behaving? You
may need to work with a copy and start deleting controls and/or sections to
see if it makes a difference.
--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


:

My sorting/grouping expression is "Pt" - no table mentioned (sorry if I said
something misleading).
And thanks for pointing out the obvious (duh)... There's a blank space under
"filter" in the properties for the report.

Again, thanks for your time.

--
Thanks for your time!


:

Why isn't your sorting and grouping expression just the field name
[pt]
You shouldn't need any table names unless you had two fields in your
report's field list with the same name (never a good idea).

You will find the report's Filter property in the report's properties (how's
that for stating the obvious)?
--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


:

Yes, Duane, the field/expression is in the sorting & grouping & "points" to
where I'd expect it to there (ie to Pt).
I've double-checked the control sources, and they seem fine.
I haven't checked the filter property & don't know how to do so.
And thanks for the reassurance on the &/+ issue.

Thanks for your help & time!


--
Thanks for your time!


:

Do you have this field/expression in the sorting and grouping dialog? Have
you checked all control sources and the Filter property?

BTW: it is most proper to use "&" (as you have) rather than "+" to
concatenate text values.

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


:

Thanks for the suggestion, but I'm still getting the parameter query,
probably because the expression comes from fields in a table or something.
I'm hoping one of the MVPs will pick up on this thread & let me know why
this seems to happen sometimes - I can't figure out what I'm doing that leads
to this situation.
--
Thanks for your time!


:

I did something similar in my report. I have the query with the items I want
to show in the report i.e. [lastname],[firstname],[MRN]

then in the report i put something like the following as the control souce
of my text box:

=[lastname]+", "+[firstname]+" "+[MRN]

I hope this helps.


:

I've tried to insert a field in my report.
The field is drawn from a query.
The field in the query is pulled from a table that contains these fields:
PtID (autonumber, primary key)
LastName (text)
FirstName (text)
MRN (text)

I want to include LastName, FirstName, & MRN on my report. My preference
would be to use a cancatenated expression:
Patient: [lastname] & ", " & [firstname] & " " & [MRN]
I have created that expression as a field, Pt, in my query, and have tried a
variety of ways to get it to display in my report. Finally, using a combo
box, it displays correctly. BUT... when I run the report, the following
"enter parameter value" dialog box pops up:
Lookup_Pt_ID.Pt
If I blow by that (say OK), the report looks just like I want it.

I've seen this phenomenon before & it puzzles me - I'm getting this dialog
box & (a) don't know how to get rid of it and (b) don't know why, if it's
asking for a parameter value, the darn thing WORKS.

Any help would be hugely appreciated.
Click to expand...
Click to expand...
Click to expand...
 
Duane - rebuilding did the trick. I then experimented a bit to see if I could
replicate the problem. If I built a report on a query, then decided to
eliminate a certain field from both the query and the report, the report
continued to search for the field even though it wasn no longer asked to do
so.
Hopefully someone will find that tidbit helpful!
--
Thanks for your time!


Duane Hookom said:
Do any of your control sources use the table and field name like
"Lookup_Pt_ID.Pt"? Did you begin removing controls/sections from a copy of
the report until the issue goes away?

If you can't figure this out, you may need to rebuild the report.

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


Sue said:
My query works fine, Joseph - it's the report based on the query I'm getting
this weirdness on. I'm not sure what you mean by having a filter in a query -
but since I don't know how to do this, I'm assuming I haven't done so.

Any other thoughts?

--
Thanks for your time!


Joseph said:
What does your sql look like? It should look like:

SELECT PtID, 'Patient: ' & [Lastname] &', '& [Firstname] &' ' & MRN as
PatientName
FROM PatientInfo
ORDER BY [Lastname];

This will give you two columns in your combo box. Make sure that in the
properties for the combo box you set the "Number of Columns" to "2" and
adjust the column widths to not display the the "PtID" column, ie "Column
Widths: 0";1.25".

Also if in your query you have placed a criteria to filter the data and the
query cannot find the location of that information, ie, referenceing a field
on a form (Criteria: Forms.Patients.PtID) it will show that error that you
are getting.


:

Yes, same thing is still happening.
I've tried removing JUST the control involved, & the report works fine.
I've tried putting the control back in as a combo box & still get the prompt
to enter parameter value.
I've tried putting the control back in as a text box & still get the prompt
to enter parameter value.
Now here's the REALLY strange thing - I try it without having this field at
ALL (neither as a text box nor as a combo box) & STILL get the prompt to
enter parameter value.
Please help???

--
Thanks for your time!


:

Are you still experiencing "weirdness" in your report or is it behaving? You
may need to work with a copy and start deleting controls and/or sections to
see if it makes a difference.
--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


:

My sorting/grouping expression is "Pt" - no table mentioned (sorry if I said
something misleading).
And thanks for pointing out the obvious (duh)... There's a blank space under
"filter" in the properties for the report.

Again, thanks for your time.

--
Thanks for your time!


:

Why isn't your sorting and grouping expression just the field name
[pt]
You shouldn't need any table names unless you had two fields in your
report's field list with the same name (never a good idea).

You will find the report's Filter property in the report's properties (how's
that for stating the obvious)?
--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


:

Yes, Duane, the field/expression is in the sorting & grouping & "points" to
where I'd expect it to there (ie to Pt).
I've double-checked the control sources, and they seem fine.
I haven't checked the filter property & don't know how to do so.
And thanks for the reassurance on the &/+ issue.

Thanks for your help & time!


--
Thanks for your time!


:

Do you have this field/expression in the sorting and grouping dialog? Have
you checked all control sources and the Filter property?

BTW: it is most proper to use "&" (as you have) rather than "+" to
concatenate text values.

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


:

Thanks for the suggestion, but I'm still getting the parameter query,
probably because the expression comes from fields in a table or something.
I'm hoping one of the MVPs will pick up on this thread & let me know why
this seems to happen sometimes - I can't figure out what I'm doing that leads
to this situation.
--
Thanks for your time!


:

I did something similar in my report. I have the query with the items I want
to show in the report i.e. [lastname],[firstname],[MRN]

then in the report i put something like the following as the control souce
of my text box:

=[lastname]+", "+[firstname]+" "+[MRN]

I hope this helps.


:

I've tried to insert a field in my report.
The field is drawn from a query.
The field in the query is pulled from a table that contains these fields:
PtID (autonumber, primary key)
LastName (text)
FirstName (text)
MRN (text)

I want to include LastName, FirstName, & MRN on my report. My preference
would be to use a cancatenated expression:
Patient: [lastname] & ", " & [firstname] & " " & [MRN]
I have created that expression as a field, Pt, in my query, and have tried a
variety of ways to get it to display in my report. Finally, using a combo
box, it displays correctly. BUT... when I run the report, the following
"enter parameter value" dialog box pops up:
Lookup_Pt_ID.Pt
If I blow by that (say OK), the report looks just like I want it.

I've seen this phenomenon before & it puzzles me - I'm getting this dialog
box & (a) don't know how to get rid of it and (b) don't know why, if it's
asking for a parameter value, the darn thing WORKS.

Any help would be hugely appreciated.
Click to expand...
Click to expand...
Click to expand...
 
I generally avoid these issues by naming every field in my database uniquely.
When you have two fields in a report recordsource that have the same name,
you must differentiate them with the table name. Usually these fields have
the same exact value so you shouldn't include both fields in your record
source.

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


Sue said:
Duane - rebuilding did the trick. I then experimented a bit to see if I could
replicate the problem. If I built a report on a query, then decided to
eliminate a certain field from both the query and the report, the report
continued to search for the field even though it wasn no longer asked to do
so.
Hopefully someone will find that tidbit helpful!
--
Thanks for your time!


Duane Hookom said:
Do any of your control sources use the table and field name like
"Lookup_Pt_ID.Pt"? Did you begin removing controls/sections from a copy of
the report until the issue goes away?

If you can't figure this out, you may need to rebuild the report.

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


Sue said:
My query works fine, Joseph - it's the report based on the query I'm getting
this weirdness on. I'm not sure what you mean by having a filter in a query -
but since I don't know how to do this, I'm assuming I haven't done so.

Any other thoughts?

--
Thanks for your time!


:

What does your sql look like? It should look like:

SELECT PtID, 'Patient: ' & [Lastname] &', '& [Firstname] &' ' & MRN as
PatientName
FROM PatientInfo
ORDER BY [Lastname];

This will give you two columns in your combo box. Make sure that in the
properties for the combo box you set the "Number of Columns" to "2" and
adjust the column widths to not display the the "PtID" column, ie "Column
Widths: 0";1.25".

Also if in your query you have placed a criteria to filter the data and the
query cannot find the location of that information, ie, referenceing a field
on a form (Criteria: Forms.Patients.PtID) it will show that error that you
are getting.


:

Yes, same thing is still happening.
I've tried removing JUST the control involved, & the report works fine.
I've tried putting the control back in as a combo box & still get the prompt
to enter parameter value.
I've tried putting the control back in as a text box & still get the prompt
to enter parameter value.
Now here's the REALLY strange thing - I try it without having this field at
ALL (neither as a text box nor as a combo box) & STILL get the prompt to
enter parameter value.
Please help???

--
Thanks for your time!


:

Are you still experiencing "weirdness" in your report or is it behaving? You
may need to work with a copy and start deleting controls and/or sections to
see if it makes a difference.
--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


:

My sorting/grouping expression is "Pt" - no table mentioned (sorry if I said
something misleading).
And thanks for pointing out the obvious (duh)... There's a blank space under
"filter" in the properties for the report.

Again, thanks for your time.

--
Thanks for your time!


:

Why isn't your sorting and grouping expression just the field name
[pt]
You shouldn't need any table names unless you had two fields in your
report's field list with the same name (never a good idea).

You will find the report's Filter property in the report's properties (how's
that for stating the obvious)?
--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


:

Yes, Duane, the field/expression is in the sorting & grouping & "points" to
where I'd expect it to there (ie to Pt).
I've double-checked the control sources, and they seem fine.
I haven't checked the filter property & don't know how to do so.
And thanks for the reassurance on the &/+ issue.

Thanks for your help & time!


--
Thanks for your time!


:

Do you have this field/expression in the sorting and grouping dialog? Have
you checked all control sources and the Filter property?

BTW: it is most proper to use "&" (as you have) rather than "+" to
concatenate text values.

--
Duane Hookom
Microsoft Access MVP
If I have helped you, please help me by donating to UCP
http://www.access.hookom.net/UCP/Default.htm


:

Thanks for the suggestion, but I'm still getting the parameter query,
probably because the expression comes from fields in a table or something.
I'm hoping one of the MVPs will pick up on this thread & let me know why
this seems to happen sometimes - I can't figure out what I'm doing that leads
to this situation.
--
Thanks for your time!


:

I did something similar in my report. I have the query with the items I want
to show in the report i.e. [lastname],[firstname],[MRN]

then in the report i put something like the following as the control souce
of my text box:

=[lastname]+", "+[firstname]+" "+[MRN]

I hope this helps.


:

I've tried to insert a field in my report.
The field is drawn from a query.
The field in the query is pulled from a table that contains these fields:
PtID (autonumber, primary key)
LastName (text)
FirstName (text)
MRN (text)

I want to include LastName, FirstName, & MRN on my report. My preference
would be to use a cancatenated expression:
Patient: [lastname] & ", " & [firstname] & " " & [MRN]
I have created that expression as a field, Pt, in my query, and have tried a
variety of ways to get it to display in my report. Finally, using a combo
box, it displays correctly. BUT... when I run the report, the following
"enter parameter value" dialog box pops up:
Lookup_Pt_ID.Pt
If I blow by that (say OK), the report looks just like I want it.

I've seen this phenomenon before & it puzzles me - I'm getting this dialog
box & (a) don't know how to get rid of it and (b) don't know why, if it's
asking for a parameter value, the darn thing WORKS.

Any help would be hugely appreciated.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top