Recent content by DarwinsDatabase

Thank you I solved it. It was a formatting problem. Thank you Plog for questioning what type of field it was. I just removed all formatting from the field and it returned the weeks. Thank you.

Thank you for responding. "Is [DUED] known?" [DueD] is the name of the variable field that will be entered by users. I would like a calculated field telling them the weeks between the Due Date and today's date. "I'm not sure what exactly you're trying to calculate. A date in the future? In the...

I am struggling with the DateDiff fuction in a calculated field. After some study, I have used several variations of: =(DateDiff("d",[DUED],Date())/7) to calculate the time (in weeks) until a due date starting from today's date. It continually turns up a specific date in the late 18 and early...

Hi Everyone! I am inexperienced at databases but have managed to fumble my way through many challenges in trying to update a faulty nutritional database I found on the Microsoft site. As I learn more about both nutrition and databases it improves. I joined in the hopes of having somewhere to...