Calculate or Input in field

[dkkirk2000]

Hello everyone!!
I'm pretty new to access but have been force to learn as I go to develop a database for my team. I've done pretty well so far, but usually run into walls, like now.



I have a query in which I have a set of steps that are based on a provided date, so I give my query a date and it calculates backwards up to a final date, everything works well, but now I have to add a different type of change in which I need to input 2 dates in type A change but ignore in type B.
So in the example below, I give a date at (330) for change B, dates calculates all the way thru (15). For change type A I give it a (330) date (no calculations) and a (140) date that calculates to (15). This is where I run into the wall..... I need to tell the query at (140) that if the Change type = B calculate, If change type = A let me enter date and calculate down to (15), Unfortunately I need the steps (330, 140,20...) to be call the same.

Change type A Change type B (330) = date (330) = date (280) = (330) - 5d (270) = (280) - 7d (140) = date (140) = (270) - 3d (20) = (140) - 2d (20) = (140) - 2d (15) = (20) - 1d (15) = (20) - 1d

Thank you for your help!!!

[pbaldy]

Personally, I don't like doing complex calculations in queries. I'd create a VBA function that had your logic in it, pass the date and type to it and let it return the result. A primer here if needed:

http://www.baldyweb.com/Function.htm

[dkkirk2000]

thanks for the reply. I'm ok with using a VBA function, but how do I tell it that if change = A enter date, else ignore and calculate......?????

[pbaldy]

I'm not really clear on what you're doing now, or the requirement. Will it be different for each record? You could get a date from a form, an input box, or whatever is appropriate to your situation.

[dkkirk2000]

ok, let me rephrase: All I want to do is:
If Change type is A: let the user input a date, if Change type is B: take the date on (270) and subtract 3 days.

[pbaldy]

Well, an input box in the VBA could let the user input a second date, but in a query I can see that being a pain in the rear. That's why I asked if it would be a different date for every A record. What does your query look like now?