Search results

Okay so I have a field named Vendor Claim # that I need to be updated via a prompt. Currently I am using an update query with the following IIf statement in the Update To: IIf([vendor claim #] Is Null,[What is the Vendor Claim # - This is NOT CLIENT CLAIM #],[vendor claim #] & "/" & [What is...

I have a series of queries that I use to populate an excel spreadsheet for a weekly report that I have to send out. I would like to have one of the fields exported be the current week displayed as a range of dates. Presently I was thinking that I could use a calulated field in a make table...

Okay so here is what I want to do. I get these excel spreadsheets that are filled with fields that I don't care anything about so I would like access to query these excel spreadsheets for very specific fields that I define. The problem I run into is this. I currently have a macro that imports...