MS Access Query Help

[Jeff]

Is anyone familiar with running queries in MS access? I have no idea how to do it and I need to do it for an assignment in school.

Jeff

[spikey_richie]

I wouldn't say I'm an expert, but I maintain a 200mb service database which has a shed load of queries in.

What you got then?

[Beerknurd]

I just took a database class in school... I still don't know jack squat... :lol:

[Jeff]

Use query to<LI type=a>(4 points) Display and print all fields for those items with a selling price greater than $10 and where the number On Hand is at least 10.
(5 points) Display and print the average selling price of products grouped by supplier code.

[spikey_richie]

Can you outline your entities and their relationships please.

[spikey_richie]

This looks like a handy reference site:

http://www.brainbell.com/tutorials/ms-office/Access_2003/TOC_Working_With_Queries.html

[NeoGen]

I used an Access database on a school project once. We had to build an ASP.NET website that made use of that access database....
I never liked Access much, but after that I swore never to use access again! :lol:

[spikey_richie]

I prefer to use PHP and MySQL - but I'm still learning

[JUST]

I'm not very sure.

1. select * from sometable where price>10 and On_Hand>=10
2. select avg(price) from sometable group by supplier_code