Populate based on Start and End values

D

Dave@Penske

Howdy:
I am trying to get the detail of the values between a given range, and can
not find a means to do so. What I have is the Start and End point of a given
range. What I am looking to do is to populate a cell(s) with the values
between these Start and End points and then combine all the Start, Between,
and End values.
Ex.
Start....H0001
End....H0010
Looking to see H0002,H0003,H0004,H0005,H0006,H0007,H0008,H0009 as individual
records also bringing in H0001 and H0010.

Much Thanks,
Dave
 
K

Ken Snell [MVP]

"Populate a cell"? Are you working in EXCEL or ACCESS -- cells are in
spreadsheets.

Please give us more specific details.. show starting data, and how the
ending data should look.
 
K

KARL DEWEY

Use of function "Between" include both values. Here is the standard syntax --
Between [Enter start] and [Enter end]
If you do not want to include the start and end values then use --
[Enter starter] and <[Enter ending]
Click to expand...
 
D

Dave@Penske

Karl:

Thanks for the quick response. I do not seem to have this function built in
to MA Access 2000. When I try typing the expression in I receive an error?
How can I get this function added to my built in list?

Thanks,
Dave

KARL DEWEY said:
Use of function "Between" include both values. Here is the standard syntax --
Between [Enter start] and [Enter end]
If you do not want to include the start and end values then use --
[Enter starter] and <[Enter ending]
Click to expand...

Dave@Penske said:
Howdy:
I am trying to get the detail of the values between a given range, and can
not find a means to do so. What I have is the Start and End point of a given
range. What I am looking to do is to populate a cell(s) with the values
between these Start and End points and then combine all the Start, Between,
and End values.
Ex.
Start....H0001
End....H0010
Looking to see H0002,H0003,H0004,H0005,H0006,H0007,H0008,H0009 as individual
records also bringing in H0001 and H0010.

Much Thanks,
Dave
Click to expand...
Click to expand...
 
K

KARL DEWEY

Where are you typing it in? What I gave was criteria for a query.

Dave@Penske said:
Karl:

Thanks for the quick response. I do not seem to have this function built in
to MA Access 2000. When I try typing the expression in I receive an error?
How can I get this function added to my built in list?

Thanks,
Dave

KARL DEWEY said:
Use of function "Between" include both values. Here is the standard syntax --
Between [Enter start] and [Enter end]
If you do not want to include the start and end values then use --
[Enter starter] and <[Enter ending]
Click to expand...

Dave@Penske said:
Howdy:
I am trying to get the detail of the values between a given range, and can
not find a means to do so. What I have is the Start and End point of a given
range. What I am looking to do is to populate a cell(s) with the values
between these Start and End points and then combine all the Start, Between,
and End values.
Ex.
Start....H0001
End....H0010
Looking to see H0002,H0003,H0004,H0005,H0006,H0007,H0008,H0009 as individual
records also bringing in H0001 and H0010.

Much Thanks,
Dave
Click to expand...
Click to expand...
Click to expand...
 
Top