Search results

I have an update query that needs to update data in JAN, FEB, MAR...fields in table A, based on the DATE field in linked table B. I have the update set to: JANBUD FEBBUD IIF(Month([DATE_Field]=1,[BUDGET_AMOUNT],0)...

I need to determine if a field contains only alphabetic characters (A-Z or a-z). Is there a function like Isnumeric for Alphabetic characters? I have a field which can contain only numbers ,or, letters and numbers, but NOT only letters. Any help would be really appreciated. Thanks, Pablo

I have form that has buttons that update data files. I have created a label on the form that records the last date/time the update was run for eact button. I can set the value to the label to Now() when running the macro thatupdates, and the date/time is set on form. However, when I close the...