Problem with displaying all records in a query

U

ukpicker

Hi,
I have a simple table to record a range of jewellery with an image for each
variation. The fields are Item, Pattern Number, Stones, Image (Picture). e.g
Brooch, 100A ,Coral , Picture.
There is no unique field because a particular pattern number could relate to
a brooch or bracelet or ear rings etc,etc. In addition each item with the
same pattern number can have a variety of stones.
O.K I want to add a query to a form to select each variation of a pattern
number.
My query brings up a list no problem but only displays the first record in
the list. if I try to select any other record in the list nothing happens.
Any ideas that might help.

Thanks in advance
 
K

KARL DEWEY

Post your query SQL statement. In query design click on menu VIEW - SQL
View and copy then paste in post reply.
 
U

ukpicker

here is the query :
SELECT Images.Pattern, Images.Item, Images.Stones, Images.Image
FROM Images
ORDER BY Images.Pattern, Images.Item, Images.Stones;

Thanks for looking
 
Top