Send Outlook Email. The extended cut shows how to add values to your Emails.
You will probably also need the DCount function to total up the assignments.

Sure, just use a DSUM, covered in expert 11 I believe

Use the criteria for whatever is making that number. So like
DSUM("Assignments","Table","Date= whatever your using here, an entered field or a form on the field, not sure how you have it setup)

Yea Dcount, not DSUM. Woops LOL, might get slightly different answers

What am I doing wrong, life is just a struggle...

DCount('DateAssign', 'NewDailyassign', 'DateAssign=NSDate')

DCount('DateAssign', 'NewDailyassign', 'DateAssign=' & NSDate)

You need to assign that to something, something = DCOUNT

Either a field or a variable like

FieldName = DCOUNT....

You are saying does DateAssign have the value of a hardcoded string of 'NSDate' not the variable

Closer to an answer, but still not quite there, any suggestions?

Guess you need some context, of where the email body is getting the value

What's your dcount look like now?

I'm blind never mind LOL. Try
DailyAssignments = DCOUNT("ID","NewDailyAssign","DateAssign=#" & 3/11/2022 & "#")

I have tried both ways I keep getting zero

You tried with the pound signs (#) outside of the date like in my example?

Dailyassignments = DCount("ID", "NewDailyassign", "DateAssign=#" & "3/11/2022" & "#")

that got me 7, now to make it work as a variable for the date

I suspect you may have times in DateAssign but it is formatted as a date.

DailyAssignments = DCount("DateAssign","NewDailyassign","DateAssign>=#2022-03-11# And DateAssign < #2022-03-12#")

Note: I wouldn't hard code the dates otherwise you will have to change them in your code everyday.
Hint: Use a form field.

Dailyassignments = DCount("ID", "NewDailyassign", "DateAssign=#" & DateSearchAssgnReport & "#")

I finally got it to work!! thank you

I have a message Box that pops up, and I fill in that date, then I have a report and an email generated with embedded table, attaches a PDF report.

All I had to do was redo my code to use the  message Box variable in the Dcount for the search critera.

Phew! I keep trying to learn but gosh darn it I am slow!

Date formats are fun

Glad to hear it works :). And yea I hate the pound symbols LOL