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.
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
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
Hi,
I have a new AP in the network that is configured by a web interface.
The problem now is that my router assigned an ip of our range to the AP and I don't know the ip of the AP so I can add new settings.
How can I discover the AP ip address?
Thanks
Hi,
What forces me is that I have a query to select twice values of that table to insert automatically some values, and the only way I could manage to do that was to create 2 tables with same values.
Thanks
Hi,
I have 2 tables with the same content, but one is linked to a form to change is values. What I need is that when something changes on table1, it copies the changes to table2, so they can always have the same content.
Is that possible?
Thanks in advance.
No, that was an error of the writing, but with:
Sortfield: If([Supervisão]="Sup. Congresso", 1, If([Supervisão]="Sup. Programa", 2, 3))
I got that error I told before.
Thanks in advance.
Hi,
I tried that expression on criteria, but I've got the following error: The expression you entered has an invalid . (dot) or ! operator or invalid parentheses.
This is my final expression:
Sortfield: If([Supervisão]="Sup. Congresso", 1, If([Supervisão]="Sup. Programa", 2, 3))
Can you...
Hi,
I have a query to get some data from a table and order it, but I need to order not in ascending way. I have to order it by a fiels that has 3 values: "Sup. A", "Sup. B" and "Sup. C", but in the final I want to appeared order like this:
"Sup. A"
"Sup. C"
"Sup. B"
How can I do this?
Thanks.
Hi,
I have a report that is getting data from a table called "Test2", but now I want the change it and point to the table "Test".
How can I do that?
Thanks in advance.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.