Other video games, TV shows, movies, general chit-chat...this is an all-purpose off-topic board where you can talk about anything that doesn't have its own dedicated section.
by scrub on Thu Feb 08, 2007 4:27 am
I need help with queries to create on Microsoft Access for my homework. I have made a database about a vet clinic. I need queries to run about animals, staff members or customers that go to the clinic. Can anyone please give me any ideas? For example, one of my queries is a list of the members of staff who are on 24 hour call to help animals.
Corey Brewer - Defensive Player of the Year 08

-

scrub
-
- Posts: 536
- Joined: Tue Aug 30, 2005 3:05 am
- Location: Belfast, Ireland
by bigh0rt on Thu Feb 08, 2007 4:32 am
You can query things like staff members who work with specific types of animals, or staff members who make over a certain annual salary or hourly wage, or who have worked there longer than X years, etc.
-

bigh0rt
- NLSC Team Member

-
- Posts: 9032
- Joined: Thu Nov 10, 2005 5:06 pm
- Location: New York
by scrub on Thu Feb 08, 2007 4:36 am
I cant include the staff wage in the database so any other queries would be very helpful. Thanks.
Corey Brewer - Defensive Player of the Year 08

-

scrub
-
- Posts: 536
- Joined: Tue Aug 30, 2005 3:05 am
- Location: Belfast, Ireland
Return to Off-Topic
Who is online
Users browsing this forum: No registered users and 8 guests