Name of weekday in a query

[eliW]

Hi,
I am a beginner and wish to solve the following without using VBA or WeekName function.
Table 1: readers name, readers birthdate
Table 2: index, day (1-Sunday, 2-Monday etc.)
Query 1: readers name, readers birthdate, weekday of birthday (by WEEKDAY([birthdate])
Now what I need is somehow to link this query with Table 2 to give me the name of the day of birth for every reader.
Please how do I do this? (rememeber no weekname formulea). Actually I want to use table 2 as VLOOKUP table in Excel)
Much appreciation for clear and simple answer.
Eli

 

[plog]

First, why? I understand reinventing the wheel to help you learn how the wheel works. Yet, here you are asking us for help instead breaking it down yourself. Why?

Second, you would create another query, bring in Query 1 and then link Table 2 to the appropriate field.

 

[eliW]

First, why? I understand reinventing the wheel to help you learn how the wheel works. Yet, here you are asking us for help instead breaking it down yourself. Why?

Second, you would create another query, bring in Query 1 and then link Table 2 to the appropriate field.

I did what you suggested but yet I get the number of readers multiplied 7 times. What do I do wrong?
As to your first question , do you suggest to use the formula? if this is the case then what should I do when the second table is not days but anything else like months or cities?
All the best,
Eli

 

[plog]

What do I do wrong?

You didn't link your two data sources. You need to join them on the appropriate fields.

Yes, I suggest to use the formula--that's what its there for. If the data is Months, I wouldn't use a second table, I would use the Month function (http://www.techonthenet.com/access/functions/date/month.php). If you are trying to calculate the person's birth city using just their birthdate, well that would be a trick I have to see.

 

[eliW]

You didn't link your two data sources. You need to join them on the appropriate fields.

Yes, I suggest to use the formula--that's what its there for. If the data is Months, I wouldn't use a second table, I would use the Month function If you are trying to calculate the person's birth city using just their birthdate, well that would be a trick I have to see.

Hi Plog, much thanks for your answers.
But let me clear out something that bothers me: With all the respect: Do I feel some unpoliteness or even sarcasm in your answers? or maybe I'm mistaken.
Any way as a regular user of MrExcel's forum, with about 2000 threads, I always had the feeling that everybody there is so willing to help, teach, and cooperate.... I thought these are the manners also in this forum. If I took this all wrong, please have my huge appology!
All the best,
Eli

 

[plog]

I can't tell you how you feel, so I have no idea. (I am sure that last sentence isn't going to be well received though).

I do know I've answered all your questions and was more than willing to help and teach in doing so.

 

[eliW]

I 've found now a better solution to my problem using the same query1, with no need to create another query:

Expr1: Format([NextBirthDate],"dddd")

Eli