Count function (1 Viewer)

[zeroaccess]

Please don't set text color to black - I can not see it using the dark theme. @Jon is there anything that can be done about that? Disable black and white text colors from the picker?

 

[Pat Hartman]

I don't see a date anywhere in your data. If your tables don't include a date, a query cannot simply pull it out of thin air. You will need to modify your transaction table to include a date field. Call it CreateDT and set it's default to Date(). Whenever a new record is added, Access will populate the CreateDT field with the date the record was saved.

 

[capogna1]

I don't see a date anywhere in your data. If your tables don't include a date, a query cannot simply pull it out of thin air. You will need to modify your transaction table to include a date field. Call it CreateDT and set it's default to Date(). Whenever a new record is added, Access will populate the CreateDT field with the date the record was saved.

Thank you !!!