Recent content by William Carl

I have a name field 28 positions long. Some names are without special characters or spaces --- such as smith, others have spaces and special characters such as St Casimirs or O'neil. when I use the =left([lastname]),4 --- smith appears as smit which is acceptable however St Casimirs or O'neil...

I have created a text box on a report which I use to calculate the sum of 2 fields from a table. These 2 fields in the table are number fields with a standard format. My question is --- how do I edit the text box to include decimal points and commas. Any help would be greatly appreciated...

I have a total on a report which shows the percent of inspections correct based on the following expression in the Control Source for the text box =[txtnocorr]/[txtnoofinsp]. My format is percent and my decimal places are zero My problem is that when dividing 902(txtnocorr) by 904(txtnoofinsp)...

I have expiration dates for exams which need to be aged a year and 7 days from the expiration date entered into the system. If anyone could help me --- I'd really appreciate this. Thanks ---

On my report there are certain times when I want to print a mailing address instead of a home address. I want to use the same area on the report to print either of these addresses. I'm not quite sure how to go about this. Thanks ---