Filtering range of records

[quest]

Hi,
I am trying to make query that will filter range of records. how this is not with maximum and minimum i tried with between same like with date from to but that way i get only first and last not the records between

record with docnumber 347 like in this example can be smaller than records with number 348 and 349 but also can be bigger. so with expresion between i got reocrd with docnumber 348 and 349 but not the record with docnumber 347 i want 347 too.
not successful with copy so here is picture instead

 

[June7]

Filter on range of what? What field are you applying criteria to - DateOfReceiving? Your dates are formatted for non-U.S. structure. Review http://allenbrowne.com/ser-36.html
Post your attempted query SQL statement.

 

[GPGeorge]

Hi,
I am trying to make query that will filter range of records. how this is not with maximum and minimum i tried with between same like with date from to but that way i get only first and last not the records between

record with docnumber 347 like in this example can be smaller than records with number 348 and 349 but also can be bigger. so with expresion between i got reocrd with docnumber 348 and 349 but not the record with docnumber 347 i want 347 too.
not successful with copy so here is picture instead

Please describe this situation as a narrative. What is the end goal? Explain things like maximum and minimum in terms of the specific values you want to compare. Are you talking about a date range, a number range, or something else? Which fields should be filtered for max and min?

 

[jdraw]

I agree with the others---what are you talking about exactly? Give us a few examples so we understand the issue. Between in Access includes the end points.