D
David
table: inventory
fields:
inventoryid - autonumber - Primary key
trackingnumber - text, always 13 char, 1st 3 = number in a group 001***,
002***
manu - text
model - text
explain:
if a new item tracking number will be unique, if item belongs in a group
first 3 char will increment and the right 10 will be the same.
Q: I need a query that returns the above fields and GROUP BY the right 10
chars of the field trackingnumber.
the results are displayed in a asp page, a little help please...
David
fields:
inventoryid - autonumber - Primary key
trackingnumber - text, always 13 char, 1st 3 = number in a group 001***,
002***
manu - text
model - text
explain:
if a new item tracking number will be unique, if item belongs in a group
first 3 char will increment and the right 10 will be the same.
Q: I need a query that returns the above fields and GROUP BY the right 10
chars of the field trackingnumber.
the results are displayed in a asp page, a little help please...
David