G Guest Apr 16, 2004 #1 my query will fail if there are only a few records to analyze - however if i expand the range it will work. why
my query will fail if there are only a few records to analyze - however if i expand the range it will work. why
G Guest Apr 17, 2004 #2 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
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
C Chris2 Apr 17, 2004 #3 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... (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.
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... (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.
J John Vinson Apr 17, 2004 #4 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.
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.