Search results

Hi Folks, I'm trying to rename a cell when there are duplicates of mutliple columns. Here's an example Col_1 Col_2 Col_3 Note A1 B1 C1 A1 B2 C1 Not a Dup A1 B1 C2 Not a Dup A2 B2 C2 A2 B2 C2 Duplicate A3...

Hi Folks, I'm doing something like the following: Select NOT(IsNull(a.ID)) as aMatch, a.*, b.* FROM TableA a RIGHT JOIN TableB b ON a.ID = b.ID However, the "aMatch" column resulting from the query is either numeric or text. Is there any way I can specify that the resulting column should be a...

Hi Folks, I have the following query, and i'm getting errors about access not supporting the JOIN. I know I can't embed inner joins within outer joins. But what about right and left joins? When I make them all INNER JOINS or LEFT JOINS, access doesn't complain. If I make them all RIGHT...

Hi Folks, I'm trying to get the following query working in Access 2007, but I get a "Syntax Error (missing operator) in query expression" error. Any help would be greatly appreciated! SELECT i.*, IIF(isNull(b.mID),0,1) LEFT JOIN iTable i ON bTable b WHERE i.mID = b.mID

Hi Folks, I'm trying to write a script that will fill empty cells in the selected column with the value of the first non-empty cell above (such code has been posted here before). However, I can't figure out how to get the selected cell into a recordset object in the first place (from which I...