mindylst
02-17-2011, 05:27 PM
I have created a database that my department uses at work, and I am making some modifications. But there is one report I can't get to pull up like I want.
This is what i have:
DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenReport "Status Update", acViewPreview, , ("[CallID] =" & [CallID])
The Call ID (From Table Group Notes) is the date of the note we are sending an email on, but we need it for the same policy number (which that part is working) and only the last entry from table SS Requirements on that policy number, currently the report creates a page for each entry of the SS requirements.
This is what i have:
DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenReport "Status Update", acViewPreview, , ("[CallID] =" & [CallID])
The Call ID (From Table Group Notes) is the date of the note we are sending an email on, but we need it for the same policy number (which that part is working) and only the last entry from table SS Requirements on that policy number, currently the report creates a page for each entry of the SS requirements.