another query question

[Doris]

I want to apologize ahead of time for being a novice with MS Access
and VBA. I desperately need help with 2 queries that I am trying to
put together. I want to thank anyone that can help me out with this
situation.

I want to put a select query(Query1) that uses one table and the
criteria would be [Enter the Event Number]. When an event number is
entered it will give me the Event Number, Event Name, Event Date,
Event time, and House Size. Next, I need to create a 2nd
query(Query2) that pulls up the records from another table by the
Event Number.

Below are the tables and fields that I am using in both queries

The table that stores the events is called tblEvents contains these
fields: RecordNumber, EventNumber, EventName, EventDate, EventTime,
HouseSize, HouseLocation, the following are all Yes/No fields within
this table: Concessions, CrownClub, Sort, and Rotation. This table is
used in Query1

I have a table that stores job codes and contains the following fields
RecordNumber, JobCode, and JobCodeDescription. From this table I only
pull the JobCodeDescription using the job code field. This table will
be used in Query2.

The table that contains the volunteer information is called
tblVolunteers has RecordNumber, VolunteerNumber, FirstName, LastName,
Address1, Address2, City, State, Zip, HomeTel, BusTel, CellTel,
EmailAddr, EmergencyContactNm, EmergencyContactTel and StatusCode,
actually the tblVolunteer finds only the first name and last name of
the volunteer using the VolunteerNumber. This will be used in Query2

I have another table that would be involved and it's called
tblWorkHours which contains the following fields: RecordNumber,
VolunteerNumber, JobCode, EventNumber, TimeIn, TimeOut and
DateWorked. This is the primary table in Query2...this is where I get
my EventNumber from....there are many records in this table with the
same Event Number. This table will be used in Query2.

Doris

 

[Barry Edmund Wright]

Hi Doris,

I see you a struggling with the Volunteer Database. There is a good
free open source database that can be downloaded from:
http://www.witstoronto.ca/databases/vms/download.html
Please look at the How-To-Movies and you will see that it is just what
you need. It also has context sensitive help that is very easy to
follow because of the number of screen shots it uses.

Cheers,
Barry