Populate based on Start and End values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Range - Between Start and End 5
Querying between two dates doesn't work if Start and End are ident 10
Between [start date] and [end date] 7
How to enter start and end date/time in excel based on some specific value. 7
GENERATE RANGES FROM GIVEN NUMBERS(START/END) AND COMPILE INTO ASINGLE LIST. 7
Listbox populated based on Combobox 2
Is Date Between Start and End 2
Values returned by expressions based on changing dates 1

Back
Top