Recent content by mouk2007

Sorry, got it. Thanks.

GREAT! Thanks a lot. This code works however it shows the age with lots of decimal places, e.g 25.565434123. Could you please let me know how I could get rid of the decimal places.

Thanks for the reply. I inserted the code you provided but I got a Syntax Error. Here is the SQL for my query: SELECT Member.MemberNumber, Member.MemberDateOfBirth FROM Member;

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

Thanks for your reply. However when I pasted the SQL code you provided I still get the same message:'Specify the table containing the record you want to delete'.

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...

Here it is: SELECT Member.MemberFirstName, Member.MemberLastName, Loan.DateOut, Loan.DateDue, Loan.DateReturned, DVDTitle.DVDTitle FROM (DVDTitle INNER JOIN DVDCopy ON DVDTitle.DVDNumber=DVDCopy.DVDNumber) INNER JOIN (Member INNER JOIN Loan ON Member.MemberNumber=Loan.MemberNumber) ON...

Thanks again fneily. I have created a form based on my query using wizard by clicking on form using wizard option, the selecting my query and adding all the information and clicking on Finish. However when I open it in design view and add a combo box the third option is still unavailable. Could...

Thanks for your reply 'fneily'. The problem that I have is that in the combobox wizard only 2 options are available and the 3rd option (find a record on my form based on the value I selected in my combo box) is not there and only the first 2 options are there. I am creating this form based on a...

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...

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...