Report getting wrong data

[davidmcolaco]

Hi have a report that gets data from a query.

Everything is fine, except for a field where it should appear a name, but appears the autonumber from the table where is that data.
Can someone explain me why is that?

Thanks

 

[PHV]

Is the table where is that data JOINed in the query ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[davidmcolaco]

No, it's not. But when I run the query, everything is fine and appears the name I want to see, but in the report, I don't know why it doesn't.

 

[PHV]

Any chance you could post the SQL code of the query ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[davidmcolaco]

Sure, here it is:

SELECT [RECOR].*
FROM [RECOR]
WHERE ((([RECOR].Sup)="Sup. H" Or ([RECOR].Sup)="Sup. P" Or ([RECOR].Sup)="Sup. C"))
ORDER BY [RECOR].Sup, [RECOR].Departamento;

Thanks

 

[PHV]

And the problem is ?
ie what is missing and what are the relationships ?
BTW, hopefully you didn't use LookUp fields !

http://www.mvps.org/access/lookupfields.htm

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[davidmcolaco]

The query is running well so the problem is not on the query. The problem is on the report.
The report is based on this query that is running fine and everything is ok, except for one field where it should appear a name and appears the code.