Access Exp 15 Lesson 3 - Microsoft Access Expert 15


	Back to Access Expert 15 Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Access Exp 15 Lesson 3

Michael Munitz

3 years ago

Hello,

At time index 17:53 I notice two tables/fields have been added to what I believe is [AttendanceReportQ]. I have gone back several times but can't find where that query was modified. Could someone point out where that modification took place so I can see the joins?

Thanks so much - Mike M

	Kevin Robertson @Reply 3 years ago
Looks like the Tables were added off camera. The added Tables are ClassT and ClassTypeT. The fields added to the Query from these two Tables are: - ClassTypeName from ClassTypeT - Description from ClassT

	Michael Munitz OP @Reply 3 years ago
Thanks, what about the joins? On Attendance ID or Class ID?

	Kevin Robertson @Reply 3 years ago
AttendanceQ.ClassID - ClassT.ClassID ClassT.ClassTypeID - ClassTypeT.ClassTypeID Remember you can always download the database Richard built in class if unsure.

	Michael Munitz OP @Reply 3 years ago
Thanks!!!

	Michael Munitz OP @Reply 3 years ago
The entire class database is available?

	Kevin Robertson @Reply 3 years ago
Yes. In the Resources section click on the Database Files link

	Michael Munitz OP @Reply 3 years ago
Thanks!

	Michael Munitz OP @Reply 3 years ago
Not sure where the actual resources page is?

	Kevin Robertson @Reply 3 years ago

	Michael Munitz OP @Reply 3 years ago
haha! I was looking everywhere but there LOL thanks.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Expert 15.

Next Unseen

New Feature: Comment Live View