easy DB question

Hi.. I have a Access database that only has one table that contains
all the information about inventory and where it's located: itemName,
itemPrice, shelfNumber, etc.

Is there a way I can write a single query that will give me something
like this:

shelfNumber 1:
itemName - itemPrice - etc....
itemName - itemPrice - etc....
itemName - itemPrice - etc....

shelfNumber 2:
itemName - itemPrice - etc....
itemName - itemPrice - etc....

etc.. etc..

thanks!

Re: easy DB question

sarah@nospam.com wrote:
> Hi.. I have a Access database that only has one table that contains
> all the information about inventory and where it's located: itemName,
> itemPrice, shelfNumber, etc.
>
> Is there a way I can write a single query that will give me something
> like this:
>
> shelfNumber 1:
> itemName - itemPrice - etc....
> itemName - itemPrice - etc....
> itemName - itemPrice - etc....
>
> shelfNumber 2:
> itemName - itemPrice - etc....
> itemName - itemPrice - etc....
>
> etc.. etc..
>
> thanks!

http://www.aspfaq.com/show.asp?id=2241

--
Mike Brind