Please I need Urgent Assistant

[michlean]

Please I just added a screenshot of my Table with the following fields> S/N Beneficiary name, MassRequest, Startday, EndDay, Day, Mass Time.

The mass request has a dropdown where one can select with 4 options, then one can selet a start date from calendar pick a date eg 9th february and EndDate could be 30th March.

one can select either sunday or monday etc from day field with dropdown of all the availabke options.

my proble is this...i want to print a report that can filter a beneficiary with each of the mass intentios, then i can filter any date of my choice ranges from start date and end date, it could be 2nd of march, or 2oth of february. then i can aswel filter mass time time which user also selected from drop down in the form.

my greatest challance is this, if i try normal filter in all the fileds, i can only see the single date of start date and end date, the othe date ranges arent captured.

please what do i do.

 

[michlean]

Thank you Very Much for response and help. like i said, i only started reading through Access because of this assignment, im not yet deep into it to understand th flow. but i dont think i understand your two solutions suggested.

Moreover, what u meant by creating 14 records, this supposed to be automated.

let me explain well what and how i wanted it to work.


from the db i attached, a
person requested for a mass of open thanksgiving from 2/9/2025 thats 9th of Feb 2025 to 12/14/2025 thats 14th of Dec. 2025.

I want if i run a report at each day, on open thanksgiving, the beneficiary name Catholic Youth Organization of Nigeria (CYON) will be inclusive, either Mon, tues, etc.

another eg. a beneficiary (Board of Church Wardens) booked a mass from 2/2/2025 to 12/7/2025 thats from 2nd Feb. till 7th Dec. 2025, from the form, they selected their mass to be called on only on 1 sundays, thats 1st Sunday of every month, so i want if a report is run for printing, at any first sunday, their intention will be printed. thanks. i don't know if u understand.

 

[June7]

Automating either approach will require VBA. In either option presented, code will "batch" create a set of records, whether retained permanently or not. This is actually a fairly common topic but you are a long way from being able to accomplish.

Otherwise, manual data entry of individual records, one record at a time.