Create a complex calulated field in a query based off of todays date

[cmorten82]

Once a month I pull a download out of our system and import it into access as a table, I then create a query that pulls in Name and each Month of the year (i.e. July, August, September, etc.) as the field headings. These headings contain a persons name and their monthly pay I want to create a calculated field that looks at today's date and pulls based on that date sums all months prior to that date. FYI, Our fiscal year starts July 1 and ends June 30. So for instance if today is any date between 3/1/16 and 3/30/2016 than it Sums July-February and as soon as the date changes to 4/1/2016 it would then sum July-March and so on. Is this possible in Access.

[ranman256]

in a form, put text boxes for txtStart, txtEnd
the form knows what today is, so build a function to put the dates in the box for your fiscal year.

then the query cant build the field off the form:
Rng: forms!frmRpts!txtStart & "-" & forms!frmRpts!txtEnd

[cmorten82]

Thank you!!! That worked. Ive been struggling here.