Recent content by waholtmn

I have a master table and table that is a subset of the master. I want to use the subset table to delete those same records in the master table. For the life of me, I cannot figure this out. I do not know VBS/SQL etc and would need a solution that is simple to execute. Thanks, Wayne

They job classifications are in a single column. Thank you for assisting me!

I have a table that has many job classifications. I want to keep 4 and change all others to miscellaneous. How do I keep four and change the rest? I've been monkeying around with the update query feature but am unable to figure this one out. Please help. Wayne

Awesome. Worked like a charm!

I have two tables. The first table has two fields; Implementer and Originator names. The second table is roster of employee names with their job class, location, and division. I want to perform a query to find both the Implementer's and Originators job class, location, and division. I have...

Thanks Plog...I found the Union as well...its a nice little piece of info to know.

This is for simplicity sake. I have two queries. Both single record queries with one field in each. Query 1 Field is a File ID stored as text in one format (CCYYMMDD- <AnyText>) and Query 2 field is also a File ID stored as text but in an entirely different format. I want to combine these...

Here is the public function I wrote: Public Function getCustomFieldName(f1, f2, f3, f4) ret = "" If (f1 = "2") Then If IsNull(f3 & f4) Then ret = "Answer B" Else ret = "Answer A" If (f1 = "M") Then If (f2 > 0) And IsNull(f3 & f4) Then ret = "Answer A" Else ret = "Answer B" If (f1 = "M")...

Plog -- You are awesome! I'll give it a shot.

PLOG -- Thanks so much...You are definitely helping this noob learn more and more. I come to forum only after exhausting efforts to find the solution myself. Your solution looks inviting and I'm going to look at it more closely but I do have a few questions. 1. f1, f2, f3....Those are generic...

I have a text field with values of either "2" or "M" and I'll call this [Field1]. Another field has numeric values including some with null values and I'll call this [Field2]. There are also three other text fields with some having empty strings and I'll call these [Field 3], [Field 4], and...

Is there a way that I could define a new field to be the literal text value from the field that has the expression and not an expression itself?

I'm sorry, you lost me there...still a noob when it comes to code...how could your solution be performed as an expression in the expression builder? Is there a way that I could define a new field to be the literal text value from the field that has the expression and not an expression itself?

Hello and thank you in advance for your assistance in helping me resolve a problem I am encountering in an Access 2010 query. I have created a query where a field uses this expression -- Source: IIf([Field 1]<>"" Or [Field 2]<>"","Answer A","Answer B") and this works fine. Note: Some of the...

PLOG -- I validated the results more closely and your solution is what I needed. Much thanks!!!