counting records and updating

[emshim]

i have a query which find all the records of stock that are similar. I want to count how many of these there are. How would i go about doing this?

I then want the user to type in the system they want, how many they want, and this will "remove" the system from the list, but not from stock i.e. makes it unavailable. The query is been created from the stock, and so everytime the query is run, it would overwrite the "unavailable stock". If any one could help, this would be great!

Emily

 

[neileg]

You need to follow the advice in your other threads.

 

[emshim]

yeah i know but ive really confused myself, and ive tried to break it down into smaller questions, hoping one of the small bits will make it so i can do the lot!

I read one post, and i have grouped rows, and then created another query which counts the rows in the previous query, but it only tells me there is one record, and theres more!

Em