Recent content by ffejeff224

Alright... adding the where clause worked for now. I had tried [vendor claim #]<>[my statement], but Access kept removing the [vendor claim #] and leaving the rest. I thought it would work with just the <>[my statement], but for some reason it wasn't working properly. Thanks for the help I...

Just a quick update. I took out the Criteria and the query updates fine. The problem is that I don't want it updating if current value matches the one that I enter into the promt. Does anyone know a way to acheive this?

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 appreciate your help guys. I ended up having to write a query just to populate both dates for beggining and end of the week then I just concatenated the two dates in the query that I was exporting to excel.

I obviously misunderstood, I thought he was saying to use that as a criterion in a field to limit results to only that current week... not returning an actual date. I havn't worked with date fields a lot so I don't really understand what the code is doing. Sorry if I offended.

Ty for the help, but I wasn't looking for a criterion. I am not sure I explained myself properly, but I am trying to get an expression to create a calculated field that is the actual range of dates for the current week.

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