Parameter Problem Again

[jiajian]

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

 

[Pat Hartman]

Repeat the calculation.

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