query failure

[Guest]

my query will fail if there are only a few records to
analyze - however if i expand the range it will work. why

 

[Guest]

Come on, with that little info. no one will be able to help you
You need to show your query at least or tell us the situation

Edmun
MCP - Access and SQL Serve

----- (e-mail address removed) wrote: ----

my query will fail if there are only a few records to
analyze - however if i expand the range it will work. wh

 

[Chris2]

my query will fail if there are only a few records to
analyze - however if i expand the range it will work. why

(e-mail address removed),

Please post your SQL attempts, your sample input data, sample expected
output data, and table structures including indexing and relationships.

This will help anyone here who wants to help greatly.


Sincerely,

Chris O.

 

[John Vinson]

my query will fail if there are only a few records to
analyze - however if i expand the range it will work. why

Because there's something wrong with the query.

If you'ld like someone to suggest what that might be, please open the
query in SQL view and post the SQL text here.