I need some query help and I would really appreciate any help. Below is
my query:

Select AdminAdvertiserList.Company, AdminAdvertiserList.City,
AdminAdvertiserInvoices.[Contract Date], AdminAdvertiserInvoices.[Start
Date], AdminAdvertiserInvoices.[End Date],
AdminAdvertiserInvoices.Amount,
AdminAdvertiserInvoices.AdditionalRevenueProgram,
AdminAdvertiserInvoices.Payments, AdminAdvertiserInvoices.Messages,
AdminAdvertiserInvoices.[Bonus Messages], AdminAdvertiserInvoices.Type,
AdminAdvertiserRepsDDL.Name [Sales Rep]
JOIN AdminAdvertiserList ON AdminAdvertiserList.Id =
AdminAdvertiserInvoices.AdvertiserId
JOIN AdminAdvertiserRepsDDL ON AdminAdvertiserRepsDDL.Id =
AdminAdvertiserList.SalesEmployeeId


I would like to include the column MessagesSent. However, I want to
calculate MessagesSent that were sent between Start Date and End Date.
Does anyone have any ideas how this would even look?

Thank you very much for your help!

Update Statement
Date Range
UNDO
SQL query
How to concatenate strings from a column into a single row (with NULL value)?