If date = sunday in one field, place a 1 in another field

[jeh]

Hi Everyone,

I need some help. I have a table with three fields; Temp(Text). Date(Date mmddyy). LLH(Nothing yet).
What I need is for the field.LLH to be 1 in every date that = sunday in the Date field.

Thanks for the help, and if anyone can help me, please break it down in hardcore newbie language,

Thanks for your time,

Jim

 

[bat17]

It is best not to store calculated fields but to create them as needed so rather than storing them in the table you should calculate them in a query.

Also it is not a good idea to call a field "Date" as it is also the name of an inbuilt function and Access can get confused. It is better to call it something like dDate or OrderDate.
To create your LLH field you can use the WeekDay() function in a query. Add a new column and in the Field row add something like
LLH:IIf(Weekday([dDate])=1,1,"")
where dDate is the name of your date field

HTH

Peter

 

[jeh]

Re: If date = sunday in one field, place a 1 in another fiel

Thanks Peter, Worked perfect!

Jim