I have attached screenshots as it is easier to see.
Created a simple query with one link with common field.
Query runs no problem.
Then select Group by and sum one field and count another.
The result is startling!
I have attached screenshots as it is easier to see.
Created a simple query with one link with common field.
Query runs no problem.
Then select Group by and sum one field and count another.
The result is startling!
Any idea on how I can pin down which fields are corrupted
Presumably the one with the Chinese characters.
You may find its only one or two records. Check that field in all records in the original query and also in the table.
Do the number of records tally?
Corruption can be hard to pin down / fix.
If that doesn't help, make a backup then do a compact/repair.
If still not OK, try importing all objects into a new database.
In fact I would do a backup anyway as your database may be about to go 'belly up'.
Good luck
Hi,
That's one of the odd things. There is nothing with Chinese Characters!
Yes backup and reload the tables one at a time sounds like a good approach.
Still very odd!!
I suggested checking the number of records in table and query as occasionally corrupted records do not display.
As I said before, corruption can be hard to pin down. And if you do find corrupted records you may not be able to edit or delete them
Grouping on a Long Text field can cause this. Can't tell what data type your description field is.
Maybe next time just post pics rather than a pdf that has to be downloaded and then unzipped?
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
I tried to post pics but it was rejected as too many letters..tried to attach pdf and the file was too large.
Description is Long Text
@Micron is correct. I forgot about the issues with Long Text/Memo fields.
Do you have any records where the Description field is more than 255 characters?
If not the Long Text datatype is unnecessary and can indeed cause problems.
Change it to Short Text then try your aggregate query again.
However if you do have records which require the use of Long Text, change the Totals row of the Description field from Group By to First.
OR replace the Description field in the query with Left(Description, 255)
Yep that was it. Changed to short text and no more Chinese characters!
Thanks