PLS HELP: SELECT TOP 100 PERCENT VS. SELECT ALL

  • Thread starter Thread starter Prodip Saha
  • Start date Start date
P

Prodip Saha

I have an Acc2000 query which returns all records when I use 100 Percent but
it returns empty resultset when All records are requested. This is kind of
strenge to me. I tried with all different percent including that of 100 %,
the query works every time.

If I drop a column from the query it works however I want it but I don't
want to remove any of the columns in the query.

Am I doing something wrong or is it a known bug in Acc2000? Thanks in
advance.

Prodip
 
Back
Top