Let's try this again. I am trying to run a report based on a date range. I have three specific fields, Staff Name, Enter Date and End Date. I am trying to use the Macro expression builder, which works for the Staff name nicely. But my date range expression isn't quite right:
[ProductionLog]![EnterDate] Between [Forms]![NameDate]![txtStartDate] And [Forms]![NameDate]![txtEndDate]
Here Production Log is my linked table and EnterDate is the field it is pulling from. My fields are expressed as dates. Any help would be appreciated.