Count function

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?
 
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.
 
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 !!!
 

Users who are viewing this thread

Back
Top Bottom