Search results

Is there a way to supress one field if the value is similar to another field? Example Field / Value Customer / Ocohee Park Account Name / The Ocohee Park In this case, I would want to show the value in the Customer field and hide the value in the Account name. Example 2 Field /...

I don't know if this can be done... I sure hope it can! I have 6 date fields(D1, D2, D3, D4, D5, D6). I want to determine the most recent date in the fields and populate a new field (Drecent). A couple of wrenches to throw in... Any date field can have a null value. Multiple date fields...

Is there a way to define the Field Size and Data Type in the query when performing a Make Table? I've tried Setting the field size and data type in an "existing" table and then use an append query to fill it, however, I receive a validation rule error. I can make the table and then change...

I know you have to reference the subreport from the main report in order to get a page break (with code to determine when the break occurs) in the subreport to work properly. The Main report doesn't recognize the VBA in the subreport... What is the code to do this and where do you put the code...

Do you know if there is a way to count the number of times a certain letter/number shows up in a single field? For example: Field Value: 123ABC234ABC345ABC456DEF If I want to count the number of times a "3" is in the field - can I do this? So - I could update another field to Y/N based...