Parameter Problem Again

jiajian

Registered User.
Local time
Today, 16:29
Joined
Sep 19, 2002
Messages
28
Hi

How can I have parameter query on a field where it is expressed in another field which has calculation?

E.g:

Due: DateAdd([AccessCode],[AccessInterval]*[Sequence],[TPLDT])…….date format
DueMonth: Month([Due])………..month format

In the DueMonth, when I put a bracket [Enter Month], it will pop me parameter messages of [Due], how to call of the month in DueMonth?

Need your advice.

Thank you

jiajian
 
Repeat the calculation.

Due: DateAdd([AccessCode],[AccessInterval]*[Sequence],[
TPLDT])…….date format
DueMonth: Month(DateAdd([AccessCode],[AccessInterval]*[Sequence],[TPLDT]))………..month format
 

Users who are viewing this thread

Back
Top Bottom