Search results

Good morning all, I have a form that lets you choose a patient's diagnosis from a combo box. I am now trying to total each diagnosis on a report. I need some help communicating to the computer what I want. I have tried =Count(IIF([HospiceDiagnosis], "COPD")) and multiple variations of that. Any...

I have a macro which will e-mail 14 reports from a command button. Would rather have VB code for some reason---so I did that thing where you convert the macro----now I do not know how to use it. I tried to copy and paste it into the on clinc property of the cmd button but it does'nt work...

I found some wonderful advise on printing multiple reports (edit code behind print button), but I need to take it a step further. I need to add a date range for the reports to print. I did this in the query under [AuditDate] and it's fine when I print one report, but when using the print all...

I have a subreport with 10 columns and I need to total each column? Right now it totals all 10 columns. Any help appreciated.

Anyone up for a challange or a good laugh??? I am working on a DB to be used by our corporate compliance auditors. I have multiple tables,queries and forms. I have a report with multiple questions each question was assigned a default numerical value (points). I have combo boxes that display...