Hello!!
I have a table with over 4000 records, each record as a date of the 1st of each month. This is an annual budget that holds budget data for 5 years for various budget codes.
Does anyone know criteria I can use whereby I can enter a month (say 4 for April) and it will return all records from the 1st Jan of current year until the 1st of April (or whatever month I enter) of the current year.
Thanks in advance!
I have a table with over 4000 records, each record as a date of the 1st of each month. This is an annual budget that holds budget data for 5 years for various budget codes.
Does anyone know criteria I can use whereby I can enter a month (say 4 for April) and it will return all records from the 1st Jan of current year until the 1st of April (or whatever month I enter) of the current year.
Thanks in advance!