Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: mouk2007
- Content: Threads
- Order by date
-
How to calculate a Member's Age using a query
I have a table of the date of birth of my members in my DVD rental shop and I also have a table for the current date. I wish to calculate the age of my members. Could anyone please let me know the code that I must use in the query to do this. Many Thanks- mouk2007
- Thread
- Replies: 7
- Forum: Microsoft: Access Other topics
-
A problem with Delete Query
I have set up a Query formed of two tables. However when I run the delete query I get a message saying 'Specify the table containing the record you want to delete'. Could anyone please help me on how to do this. Here is the SQL: DELETE DISTINCTROW DVDCopy.CopyNumber, DVDCopy.DVDNumber...- mouk2007
- Thread
- Replies: 9
- Forum: Microsoft: Access Other topics
-
Forms - I have a problem with creating a form. Please help
I am designing a DataBase on a DVD rental shop in MS Access. I wish to create a form allowing the user to select a DVD CopyNumber and find the details of the last loan for that copy (name of the person who borrowed it, DVD title, DateOut, DateDue and DateReturn). I have set up a query...- mouk2007
- Thread
- Replies: 10
- Forum: Microsoft: Access Other topics
-
How do I link a command button to a query or a report?
I have created a form so that users can select one of the following options: 1 - Select Actor 2 - Enter Actor 3 - All Actors and based on their choice either a drop-down menu appears allowing the user to select an actor name or type in the actor name for the DVDs by that actor to appear. I have...- mouk2007
- Thread
- Replies: 1
- Forum: Microsoft: Access Forms
