query failure

G

Guest

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

Edmund

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

----- [email protected] wrote: ----

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

Chris2

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

[email protected],

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.
 
J

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
Click to expand...

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.
 
Top