Skip to Content
0

How to count appointment one time

Jul 27, 2017 at 09:44 PM

22

avatar image
Former Member

I am trying to do a count on Patient name and date.

I am trying to add these 2 as one formula field that I can do a count on.

({DDB_APPT_BASE.APPTDATE}) + ({DDB_APPT_BASE.PATNAME}))

but I get a message on the second one that it's 'not part of the formula'.

We have a patient appointment table and sometimes the same visit is in there more than one time, due to billing or whatever. I am trying to count as one visit if the patient name is the same and also the datetime. I also have main group by Dentist. But the key is these 2 fields. I dont see how I can count this otherwise.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Vitaly Izmaylov
Jul 27, 2017 at 10:35 PM
1

You can't concatenate fields with different types. In your case Date type + String type.

but you can convert the Date to Text and then concatenate:

Totext ({DDB_APPT_BASE.APPTDATE}) + ({DDB_APPT_BASE.PATNAME}))

Share
10 |10000 characters needed characters left characters exceeded