J jazsriel Member Local time Today, 15:14 Joined Dec 21, 2020 Messages 65 Apr 3, 2022 #1 ... Last edited: Apr 13, 2022
arnelgp ..forever waiting... waiting for jellybean! Local time Tomorrow, 05:14 Joined May 7, 2009 Messages 20,705 Apr 3, 2022 #2 on the 1st day of each month, print only the Previous month record, is that right? how about on "other" days? show all records?
on the 1st day of each month, print only the Previous month record, is that right? how about on "other" days? show all records?
arnelgp ..forever waiting... waiting for jellybean! Local time Tomorrow, 05:14 Joined May 7, 2009 Messages 20,705 Apr 3, 2022 #3 open test form and click "all in one" it will open "rptCasesCount22" report. if you open rptCasesCount22 in design view you will see a code on the Load event of the report. Attachments TMP (1).accdb TMP (1).accdb 3.2 MB · Views: 158
open test form and click "all in one" it will open "rptCasesCount22" report. if you open rptCasesCount22 in design view you will see a code on the Load event of the report.
arnelgp ..forever waiting... waiting for jellybean! Local time Tomorrow, 05:14 Joined May 7, 2009 Messages 20,705 Apr 4, 2022 #4 see and test it again. see the code on the Load event of the report. Attachments TMP (1).accdb TMP (1).accdb 3.2 MB · Views: 187
arnelgp ..forever waiting... waiting for jellybean! Local time Tomorrow, 05:14 Joined May 7, 2009 Messages 20,705 Apr 7, 2022 #5 on my opinion, you need to convert those "text" fields to numeric fields (long integer).
