By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,505 Members | 1,549 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,505 IT Pros & Developers. It's quick & easy.

field contanins column name for query

P: n/a
Hi,i'm new to access and not sure whether it's possible to create a
query on two tables below to get data from tblB or i should do some
trick through VBA?
thank u in advance
Dim

tblA:
Date, Zone
12/1/04 east
12/15/04 west

tblB:
Date; east ; west; north
12/1/04 55 66 77
12/15/04 11 12 14
12/17/04 5 6 9

Nov 13 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
di*****@yahoo.com wrote:
Hi,i'm new to access and not sure whether it's possible to create a
query on two tables below to get data from tblB or i should do some
trick through VBA?


Try the Query Wizard. That is, create a new query, and choose the second
item from the list you're presented.

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea
Nov 13 '05 #2

P: n/a
dim
i guess i eigher missed something in my explanation or i'm not
following your directions on using wizard (those tables do NOT have any
relations, and in query i would need add to tblA a field which contains
data (hours) from tblB: hours by specific zone, see both tables in
previous posting)...

Bas Cost Budde wrote:
di*****@yahoo.com wrote:
Hi,i'm new to access and not sure whether it's possible to create a
query on two tables below to get data from tblB or i should do some
trick through VBA?
Try the Query Wizard. That is, create a new query, and choose the

second item from the list you're presented.

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea


Nov 13 '05 #3

P: n/a
dim wrote:
i guess i eigher missed something in my explanation or i'm not
following your directions on using wizard (those tables do NOT have any
relations, and in query i would need add to tblA a field which contains
data (hours) from tblB: hours by specific zone, see both tables in
previous posting)...


I don't understand the question yet.

What exactly do you want in your query output?
--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html
I prefer human mail above automated so in my address
replace the queue with a tea
Nov 13 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.