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?
CURRENT ISSUE
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.
SELECT(
Students[Name],
AND(
Year(Payment History[Date])<>Year(Today()),
Month(Payment History[Date])<>Month(Today())
) )
This query will go into the Email Template.
anyway, sorry for the double post hereโฆ
Thanks for all the help so far everyoneโฆ
User | Count |
---|---|
35 | |
35 | |
28 | |
23 | |
18 |