Can anyone clarify this:
Most of my trouble comes from trying to figure out the proper reference format from where ever Im trying to call it.
Payment History[Date] [Payment History][Date] [Payment History].[Date] [Payment History[Date]]
These are all valid formats depending on where you are and what your trying to do… but, how do i know which format to use?
I have a table Students with a Reference to the Payments table called “Payment History”.
I’m trying to find all students that have NOT paid this month… Im using the following query and I just cant seem to get the reference correct.
This query will go into the Email Template.
anyway, sorry for the double post here…
Thanks for all the help so far everyone…