Duplicate Results in Count Queries

[diggerydoom]

Hi all,

I have a table with a field 'FName'. I have run a query to count the number of each Name in this field. However, as well as having a blank field with 9129 results (which was expected) but another with 24 results that appears to be completely blank as well. There are another couple of incidences were results in 'FName' are appearing twice.

Any suggestions on how to identify what is causing this duplication?

Thanks,
Sam

 

[Brianwarnock]

As a start we are going to need to see the SQL for the query.

Brian

 

[Pat Hartman]

For the "blank" and "blank" - one is null and the other is a ZLS. You can change them all to null by creating an update query that selects the Null value and updates to "".

As for the other unexplained dups, there may be extra spaces or some hidden character. It will be very hard to identify these because you can't see them.

 

[oneonesip]

Hi all,

I have a table with a field 'FName'. I have run a query to count the number of each Name in this field. However, as well as having a blank field with 9129 results (which was expected) but another with 24 results that appears to be completely blank as well. There are another couple of incidences were results in 'FName' are appearing twice.

Any suggestions on how to identify what is causing this duplication?

Thanks,
Sam

using innerjoin or left join is the good ways, you could left join and in where clause let the fieldname is null

 

[akashneelh]

Hi ,

First of all make a group by of your Fname field to make unique. For the blank fields
U can try Trim function.
Trim (" Fname ") would return "" without any space.

If still the problem persists,please provide some sample data to check.

 

[diggerydoom]

Thanks for the replies- I will give it a go.