simple query..need help if possible

[northernirishgu]

hi
have just designed a rather simple music database for my dad to use at home as he has large collection.
have a table with the heading"artist" and another one with "album" ...my problem is that on the table there maybe 1 or more instances with the same artist but with different albums...when i run a simple query for ..say artists starting with the letter"a" i may get about 10 cases of the same artist appearing in my query when all i want is one...(depending on if i may put in say one artist like abba having 10 albums etc)...i am entering each artist with the album each time so i may enter the artist in say 10 times....depending on how many albums etc

if you understand all that...i would be grateful if someone could help me with a simple query
alan

 

[Uncle Gizmo]

I am not quite clear on what you want? Do you want a query that returns a particular list of records? And if that's the case, could you give an example. Or did you want some help with the design of your database?

 

[northernirishgu]

hi

sorry.

i am just trying to run a simple query...my database has a table with two headings
1..artist
2..album name

there may be instances of the same artist but with different albums ..in some cases as many as ten.have a simple query made that asks for say artists starting with the letter "a" which in my case throws out about ten abbas lol..i only want it to have one instance of each in my query.hope that helps ..

 

[Uncle Gizmo]

So although you have ten albums by Abba, you only want one album returned? This album name that you want returned, you just want any Album randomly returned?

I'm sorry but I am having difficulty understanding your question, and your last answer didn't really add anything to your original question it just repeated it!

 

[northernirishgu]

sorry

hi sorry
am getting there .

my database currently holds about 20000 songs with xxx amount of artists...all i want when i run my simple query ....( my query asks what letter i want my artist s to start with if i select say "a" then it will return all the artists starting with that letter...i dont want any other info just the amount of artists starting with my given letter)
although i may have instances in my database that have ..say...abba in about 10 times with different albums...i only want a list of all artists that start with the letter "a" but when i run my query...and because i have say 10 abbas..its giving me everything that starts with a ....all i would like to do if possible is when i run my query it will give me the list of artists starting with "a" once and not have about 10 abbas in my list....if thats possible....maybe its my bad designing of this database lol hope that helps abit more and thanks for replying so quick.

 

[Uncle Gizmo]

In the Northwind example database that comes with MS Access there is a form called "Customer Phone List" which will hopefully contain some useful example coding that you could modify, and I suspect it may be something that you could use as it is.

 

[Rich]

Use the SelectUniqueRecords option on the query PropertySheet

 

[northernirishgu]

thanks

hi
thanks to the two guys who helped me uncle gizmo and rich who finally cracked what i wanted to do...sorry if my explaination wasnt the best...at leasst you can get really good help here....many thanks as this problem was doing my head in

alan