Recent content by surreal1780

I don't have any experience with the Dlookup function, but it sounds like it would greatly simplify this problem. I'll give it a whirl and let you know how it turns out. thanks all for your help.

Rabbie, I took your advice and simplified it: =Switch(Allocation=1A, [01/03/2008], Allocation=2A, [01/15/2008]) However, I've still had no success. Also, I just wanted to include this message between Robjoy & myself: Originally Posted by surreal1780 Do you mean this...

Before you read this question, just know that yes, I do realize how cumbersome the function is below and that there are multiple recommendations for function building that have been violated. With that said, here's what I am having difficulty with. I am trying to construct a Switch function...

Hi, I was trying to create a switch function that does the following: • If the field “pre-date” has “group 1” selected, then the date in field “post-date” will = 01/01/2008 • If the field “pre-date” has “group 2” selected, then the date in field “post-date” will = 02/17/2008 • If the field...

thank you both! Thank you both for your help. I'll keep the shortening of names in mind--I know it's cumbersome so I'll definitely avoid using them in the future. thanks, D.

CraigDolphin: I received the following error when I tried inserting the function: "the expression you entered has a function containing the wrong number of arguments" ??? no idea what that means...sorry, I acknowledge I am still a novice in many respects using Access.

As you can see from the picture, when I enter in a date in "Pre-assessment 1..." no date is generated in "Date of 7". However, when I enter in a date in "Pre-assessment 2..." the function works. Ideas?

Hello all, I am trying to construct a DateAdd function, but am having difficulty. The function involves 3 fields: Pre-assessment 1 Date - Immediate starts Pre-assessment 2 Date - Control Starts Date of 7 Week Follow-up post-intervention I am trying to create a function for the "Date of...