Missing text data in report and underlying query

  • Thread starter Thread starter Van Kurtz
  • Start date Start date
V

Van Kurtz

I compact and repair an Access database (mdb). I then open
a report and a text field displays little square boxes,
rather than text. The same happens when I open the
report's underlying query. The text is a field in a table
that is part of the query. I have several reports and
queries, some show this effect and some do not, that is,
some reports display the text properly. When I open the
table containing the text, it is there and correct. The
compact and repair reduced the size of the database by
over 50%. I am running Access 2000 with Windows 2000,
Service pack 5.

Any thoughts?

Thanks
 
Hi.
I would not worry about the reprot for right now. Let's
concentrate on the query. I would suggest that you give
some more information on your tables and the sql for the
query. Once the query is corrected the report can be
addressed if necessary.
Fons
 
I agree that fixing the query should fix the report. Keep
in mind that the query worked before I did the
compact/repair. Here is the query:

SELECT Avg(results.result) AS AvgOfresult, Count
(results.result) AS CountOfresult, checks.auditCheck,
checks.checkPage, checks.checkOrder, [audit
section].section
FROM [repair audits] INNER JOIN ((checks INNER JOIN
results ON checks.checkID = results.checkID) INNER JOIN
[audit section] ON checks.checkPage = [audit
section].checkPage) ON [repair audits].auditID =
results.auditID
WHERE ((([repair audits].auditCompleted)=True) AND
((results.result)>-1) AND (([repair audits].soNumber)=
[Forms]![reops report generator]![soNumberText]))
GROUP BY checks.auditCheck, checks.checkPage,
checks.checkOrder, [audit section].section, results.checkID
ORDER BY checks.checkPage, checks.checkOrder;

The repair audits table links to a table of results, which
are answers to a table of checks (questions). Each result
record has a checkID, which links the result to the check.
The field checks.auditCheck contains the text of the
question; it is this field that displays as a little
square in the query/report. Also each check record has a
section ID (checkPage) which links to the table [audit
section], which contains the name (text) of each section
ID.

Thanks for your help.
 
Right of hand I see no problem with the query. Just
incase there is a problem with the MDB file, you may try
creating a balnk MDB and than import all the tables,
queries,forms, reports, macros etc.
I have had occasions where somehow an error in a file
caused unexplainable errors.
If this does not resolve the problem, if you wish email me
your mdb with some sample data and I'll gladly work
through it.
Let me know what you find
F O N S P O N S I O @ M S N . C O M
-----Original Message-----
I agree that fixing the query should fix the report. Keep
in mind that the query worked before I did the
compact/repair. Here is the query:

SELECT Avg(results.result) AS AvgOfresult, Count
(results.result) AS CountOfresult, checks.auditCheck,
checks.checkPage, checks.checkOrder, [audit
section].section
FROM [repair audits] INNER JOIN ((checks INNER JOIN
results ON checks.checkID = results.checkID) INNER JOIN
[audit section] ON checks.checkPage = [audit
section].checkPage) ON [repair audits].auditID =
results.auditID
WHERE ((([repair audits].auditCompleted)=True) AND
((results.result)>-1) AND (([repair audits].soNumber)=
[Forms]![reops report generator]![soNumberText]))
GROUP BY checks.auditCheck, checks.checkPage,
checks.checkOrder, [audit section].section, results.checkID
ORDER BY checks.checkPage, checks.checkOrder;

The repair audits table links to a table of results, which
are answers to a table of checks (questions). Each result
record has a checkID, which links the result to the check.
The field checks.auditCheck contains the text of the
question; it is this field that displays as a little
square in the query/report. Also each check record has a
section ID (checkPage) which links to the table [audit
section], which contains the name (text) of each section
ID.

Thanks for your help.

-----Original Message-----
Hi.
I would not worry about the reprot for right now. Let's
concentrate on the query. I would suggest that you give
some more information on your tables and the sql for the
query. Once the query is corrected the report can be
addressed if necessary.
Fons
.
Click to expand...
.
Click to expand...
 
Back
Top