Search results
-
A
Calculated Field in Table - Week Num
Thank you pr2-eugin and David. I believe I will need to utilize pr2-eugin's advice, as I will be creating a form that shows this information and the table will need to updated based on this form. So, my thinking is I will have to link the form directly to the table, rather than a query, right... -
A
Calculated Field in Table - Week Num
I am trying to create a calculated field in my table, I am trying to use the following code: DatePart("ww",[Gas]![Date Opened]) I receive the following error message: "The expression DatePart("ww",[Gas]![Date Opened]) cannot be used in a calculated column." Please let me know what I am...