Problem with displaying all records in a query

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

Guest

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
 
Post your query SQL statement. In query design click on menu VIEW - SQL
View and copy then paste in post reply.
 
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
 

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

Problem with Null Queries 3
Query Not Displaying All Main Table Records 1
running total of records in query 1
How to query for duplicates using two fields? 4
Case of the curious query ; count the codes 2
Query with common fields to all records 6
Finding a Match 1
Counting records in a query 9

Back
Top