Search results

Thanks CJ, Could you please help to do the same with this: SELECT CourseInformationDoncaster.[Full Name], CourseInformationDoncaster.[Course Title], CourseInformationDoncaster.CourseCode, CourseInformationDoncaster.ExpiryDate FROM UnionDonnyCodes INNER JOIN (Doncaster INNER JOIN...

Thanks CJ. I don't know how you worked that out but it works and I'm happy! Thank you. shosim85

wow. i didnt even know this forum had a room like this. Is this little debate still going on?

Hi, My query is this: SELECT Staff.FullName, [Course Title ID].CourseTitle AS Title, UnionCourseCode.CCode, Course.CourseExpiry FROM UnionCourseCode INNER JOIN (CourseCodeID INNER JOIN ([Course Title ID] INNER JOIN (Staff INNER JOIN Course ON Staff.FullName = Course.FullName) ON [Course...

Hi, I have a table that holds course information for students. I have a parameter query linked to this prompting the user to enter a course code thus displaying all students who have that course. However, I would like to do the opposite i.e prompt the user to enter a course code and then the...

Ok, been a while but I have another problem. I have the following code: SELECT Staff.FullName, [Course Title ID].CourseTitle AS Title, UnionCourseCode.CCode, Course.CourseExpiry FROM UnionCourseCode INNER JOIN (CourseCodeID INNER JOIN ([Course Title ID] INNER JOIN (Staff INNER JOIN Course ON...

Ah, thanks jdraw. Worked a treat!

Hi vbaInet Hope all is well with you. I have now near enough completed the database. However I have one small problem. I have done a query joining the date fields from my tables: SELECT SmallTools.FullName, [Small Tools ID].SmallTool AS Title, SmallCodeID.SmallCode AS Code...

YEP! It's as I thought.... YOU are BRILLIANT! That works nicely :cool:. I'll plod on gently now (well, at least until I come across another problem)! Thanks so much, your a STAR!!!!

Ah ok, I'll try that now. Thanks

vbaInet, sorry to be a pain but I am confused as to how to go about doing this union query. I have been reading that to do this, fields in the different tables need to have the same named fields. None of mine do so I'm not sure how I combine them. Please help, sorry shosim85

OK?! Not too familiar with that method as I am kinda self taught and seem to know some of the more complicated stuff but not the basics. I will read up on this and see how it goes. Thanks for your time and help. And no, not date of birth, lol

Ok. I would like to query all date fields across the different tables so that the user can enter the mm/yy they want to query. Then I want the results to display only those fields where the mm/yy is a match to the user's input. So e.g would be user enters 09/12 and the database would produce...

ok. I have attached a few records on the excel spreadsheet and a screen shot of the relationships. Hope this helps. Thanks

I cannot attach because the file was too big. Is there any other way I can get it to you please? Thanks shosim85

Please Help! I have several different tables with date fields for different things, i.e ID expiry, Course Expiry, Passport Expiry, etc. These fields are stored in different tables. E.g: Table 1 Table 2 Table 3 text field...

Hi Guys, I always come to this site to find answers to my burning Access questions and have found it quite useful so I thought I'd join too. Excellent site and thanks to all who reply and give us guys a hope that we can do this too. :D