coasterman
Registered User.
- Local time
- Today, 12:30
- Joined
- Oct 1, 2012
- Messages
- 59
Hi
I have some pretty basic code on the form current event which after navigating a number of logical statements generates a date.
that value is then reflected in an unbound control txtLimitationDate on my users form. i.e
Me.txtLimitationDate.Value = LimitationDate
I would however like to use the value LimitationDate in a select query but don't know how to go about this?
Is this even possible in SQL or would I need to create a recordset in VBA? (which I suspect is probably beyond me at this point)
I know storing calculated value is tables is bad practice but I'd be quite prepared to go that route if anyone could point me in that direction.
many thanks
I have some pretty basic code on the form current event which after navigating a number of logical statements generates a date.
that value is then reflected in an unbound control txtLimitationDate on my users form. i.e
Me.txtLimitationDate.Value = LimitationDate
I would however like to use the value LimitationDate in a select query but don't know how to go about this?
Is this even possible in SQL or would I need to create a recordset in VBA? (which I suspect is probably beyond me at this point)
I know storing calculated value is tables is bad practice but I'd be quite prepared to go that route if anyone could point me in that direction.
many thanks