Distinct query is returning weird result 1

[VijiKumara]

Hi,

I imported a data which is in Microsoft Excel and were able to import successfully. I did this by using export/import wizard. All the data types I assigned are varchar with enough space. But when I query the table for distinct records(both count and number of records), it always returns only one count and the record. This sounds very weird to me because the table has many distinct records. Please help.

1) The below image indicates table has many records.

2) The below image shows, query returning only one record as distinct

3) The below image shows, query returning, 1 as distinct count

Thanks in advance,
VIJ

 

[dhookom]

I believe the issue is with naming a column "User". Can you rename the column or try wrapping it in []s.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[VijiKumara]

You are absolutely right! I renamed the columns & it started working. Thank you very much for the great tip!