Weekday result from access column

[Cintury]

I have the function that returns a numerical value according to its corresponding weekday in one column in the design view of access and what I do not know how to do is make this be "equal to" the number in the WeekdayName(number, [abbreviate], [firstdayofweek]) function.

My current code without the WeekdayName func:

SELECT Dnt.Date
     , WEEKDAY(Dnt.Date) AS Date_weekday
     , Dnt.FoodDonationsID
     , Dnr.[Donor Company]
     , Dnt.Bakery
     , Dnt.Dairy
     , Dnt.Meat
     , Dnt.Fruit
     , Dnt.Vegetable
     , Dnt.Prepared
     , Dnt.Juice
     , Dnt.[Non-Perishable]
     , Dnt.[Non-Food]
     , Dnt.Driver
     , Dnt.TruckNumber
     , Dnt.[Donor Time]
  FROM tblFoodDonations AS Dnt   
INNER 
  JOIN tblFoodDonor AS Dnr
    ON Dnr.DonorID = Dnt.DonorID
 WHERE Dnt.Date = #2008-07-01#

[Stewart Ross]

Hi Cintury. Could you explain what it is you need assistance with here? I have read and re-read your post since you posted it, come back to it, read it again, and still cannot work out what you are asking. If you could clarify I am sure you will get a quick response!

Even though I'm not sure what it is you are asking, I do commend the formatting of the code you have posted - it is very clear, even if your question isn't!

-Stewart

[Cintury]

Hi Cintury. Could you explain what it is you need assistance with here? I have read and re-read your post since you posted it, come back to it, read it again, and still cannot work out what you are asking. If you could clarify I am sure you will get a quick response!

Even though I'm not sure what it is you are asking, I do commend the formatting of the code you have posted - it is very clear, even if your question isn't!

-Stewart

Ok right now what I have is a column giving me for example "3," and instead of that column giving me that number I want it to give me the actual day for example "Tuesday." Since I already have the one column giving the appropriate numerical value for the day of the week I wanted to know if there was a way I could use that value as the input for the other function.

WeekdayName(number, [abbreviate], [firstdayofweek])
(In order for the end result to say "Tuesday" instead of "3.")

[missinglinq]

Like Stewart, I'm having trouble following your code, but where

FieldName

is the name of the field(column) holding the numerical value of the weekday

WeekDayName(FieldName)

will yield the actual name, or where

YourDateField

holds your actual date

WeekDayName(WeekDay(YourDateField))

Linq ;0)>

[Cintury]

Thank you missinglinq this worked, but now I have a column with the appropriate day and its corresponding number showing on the query. When I uncheck the box for it not to be displayed then the other column asks for an input.

So my question is: Is there no way for the numerical representation of the day of the week to not be displayed?

[missinglinq]

Don't know what to tell you; unchecking the "Show" box in the Query Design Grid, which is what I assume you're talking about, should do nothing but keep it from displaying when you run the query. The calculation should still run, without parameter being input, as long as the field is actually in the query.

Linq ;0)>,