GA Access: Value list prints in report

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

Guest

Hello

I generate a report from a merge of 2 tables. The problem is that in one table i have fields that have a value list and the whole value list prints in the report instead of the chosen value. I have modified the field in the report to the query that runs as its data source, but i still get the same result. Any suggestions ? Thank you for your help.
 
GA said:
Hello,

I generate a report from a merge of 2 tables. The problem is that in
one table i have fields that have a value list and the whole value
list prints in the report instead of the chosen value. I have
modified the field in the report to the query that runs as its data
source, but i still get the same result. Any suggestions ? Thank you
for your help.
Click to expand...

Please post the SQL of the report's RecordSource query and the
ControlSource of the control on the report that is giving you this
problem.
 
Hello Dirk,

Thank you for the info. I have simplified my query to test it. These are the statements. The field with the value list is 'TITLE'. When i run the query, is lists all the values from the field instead of the value i chose. I hope i explained it well.


SELECT T_Employees.[Employee ID], T_Employees.FirstName, T_Employees.Title
FROM T_Employees;


---------------------------------------------------------------------------------------------------------

----- Dirk Goldgar wrote: -----

GA said:
Hello,
one table i have fields that have a value list and the whole value
list prints in the report instead of the chosen value. I have
modified the field in the report to the query that runs as its data
source, but i still get the same result. Any suggestions ? Thank you
for your help.
Click to expand...

Please post the SQL of the report's RecordSource query and the
ControlSource of the control on the report that is giving you this
problem.
 
GA said:
Hello Dirk,

Thank you for the info. I have simplified my query to test it. These
are the statements. The field with the value list is 'TITLE'. When i
run the query, is lists all the values from the field instead of the
value i chose. I hope i explained it well.


SELECT T_Employees.[Employee ID], T_Employees.FirstName,
T_Employees.Title
FROM T_Employees;


---------------------------------------------------------------------- -----------------------------------

----- Dirk Goldgar wrote: -----

GA said:
Hello,
Click to expand...
that in > one table i have fields that have a value list and the
whole value > list prints in the report instead of the chosen
value. I have > modified the field in the report to the query
that runs as its data > source, but i still get the same result.
Any suggestions ? Thank you > for your help.

Please post the SQL of the report's RecordSource query and the
ControlSource of the control on the report that is giving you
this problem.
Click to expand...

It sounds as though the field actually *contains* the value list, as its
value. Is that possible? How was the field's value set in the first
place? Was there code involved?

I can't figure out from the information available what is going on. If
you'd like to send me a cut-down copy of your database, containing only
the elements necessary to demonstrate the problem, compacted and then
zipped to less than 1MB in size (preferably much smaller) -- I'll have
a look at it, time permitting. You can send it to the address derived
by removing NO SPAM from the reply address of this message.
 
Back
Top