Search results

Thanks. Will try this.

Thanks. I was trying to avoid the 12 query route, which I know works. When I run the select query , all the data for the records to be updated is there, but it's only updating the last one. Thanks.:banghead:

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)...

Thanks, Appreciate the help.!!:)

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

Ok, thanks. I'll try to solve that way.

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...