469,917 Members | 1,610 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,917 developers. It's quick & easy.

Another question about queries

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

Apr 25 '07 #1
2 1323
On Apr 25, 11:09 am, Dori...@aol.com wrote:
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

Try this. Create a como box (or list box) with columns for event
number, name, date etc.
Make event number the column bound.
Create text boxes that have as data source Me.combobox.Column(1) and
Me.combobox.Column(2) etc for as many columns as desired to display.
Next create as list box with as many columns as needed to display
volunteer info, name etc.
The record source for the list box should be a query based on the
volunteer table with criteria being set as the bound column of
Me.combobox.Column(0)
the list box will then only display information for the event selected
in the combo box

Apr 29 '07 #2
Jay
Doris, could you please stop multi-posting the same question.

You've posted this 3 times - twice as the original poster and once
semi-hijacking another thread. It just means people can duplicate
responses, wasting their time answering queries someone else may have
already dealt with.

It's usual newsgroup etiquette, please observe it.

Jason

lg********@gmail.com wrote:
On Apr 25, 11:09 am, Dori...@aol.com wrote:
>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


Try this. Create a como box (or list box) with columns for event
number, name, date etc.
Make event number the column bound.
Create text boxes that have as data source Me.combobox.Column(1) and
Me.combobox.Column(2) etc for as many columns as desired to display.
Next create as list box with as many columns as needed to display
volunteer info, name etc.
The record source for the list box should be a query based on the
volunteer table with criteria being set as the bound column of
Me.combobox.Column(0)
the list box will then only display information for the event selected
in the combo box
Apr 29 '07 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

5 posts views Thread by Daniel Tan | last post: by
3 posts views Thread by rfuscjr via AccessMonster.com | last post: by
4 posts views Thread by Doris | last post: by
1 post views Thread by Waqarahmed | last post: by
reply views Thread by Salome Sato | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.