Search results

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

Beetle -- The Nz function didn't solve my predicament. Let me give some more information to see if a solution can be found. Proposed Solution: IIf(Nz([Field 3], 0)>0,IIf(Nz([Field 1], 0)<>0 Or Nz([Field 2], 0)<>,"Answer A","Answer B"),"Answer C") Changed to accommodate the text fields 1 &...

Thanks much Beetle, I'll give that a try. Here are some more details. Field 3 is a number and fields 1 & 2 are both text. The expression in Excel does this. If field 3 is greater than zero then if field 1 has text or field 2 has text write "Answer A"; if field three is greater than zero and...

I've nearly completed a conversion from an Excel database to an Access one as I've got only one more field to convert. However, this one seems to be the trickiest to figure out. I cannot convert this Excel expression to one that works in Access. Please help. Excel...

I'm fairly green at using MS Access...love the application and want to use it more...just need to know more. W