just need a list please

[rizabdullah]

Hi Guys

Seems like my brain is not working today. I have a table, as below, with 3 columns. All I am after, through a query if possible, is to list the range between FROM & TO fields by ITEM field please. Any suggestions:

Item From To
A 2 10
B 1 5
C 4 7

 

[arnelgp]

what do you mean? do you want:
a2
a3
a4
...
a10
b1
b2
...
b4
c4
c5
...
c7

 

[rizabdullah]

That's correct.

 

[arnelgp]

why can't you just do it in the table?
you need a union query and a function to do that thing.

 

[rizabdullah]

Union query I am ok with,any hints about the function please.

 

[arnelgp]

forget about my last post we can get away with this without union query or function.
create a new table called int tblNumbers, with 1 field Numbers (integer).

fill your table with numbers 1 to 20.
i assume your field [To] and [From] are numeric.

after you made the table above, create a query:

SELECT [Item] & [Numbers] AS List
FROM tblItems, tblNumbers
WHERE (((tblNumbers.Numbers) Between [from] And [to]))
ORDER BY tblItems.Item, tblNumbers.Numbers;


replace tblItems table with your table name.

 

[rizabdullah]

Excellent, it works many thanks