Dugi, thanks for your help. What I specifically want to do is run Access 2003 on a Windows XP virtual machine on my Windows 2008 Server. Does anyone have any...

I've reached a temporary solution. I added a space ( " "+ [TableB.Col1] ) to the second Select statement in the Union query, inserting a space before each cell of...

Euguene, IT WORKS! I appreciate your help. I didn't think about the MIN function. 🙂

Is it possible to translate this into Access 2003 DB could interpret?

Once again, I appreciate your response. My code apparently does not take

Shawn,

Thanks for your suggestion. When I goto Google, I just get so many hits, I don't know where to begin.

As it turns out, in Access 2003 during the...

GSquared (4/24/2009)

---

I don't believe there is such a function in T-SQL. But I'd also say that this kind of thing should be done in the presentation layer, not in...

Chris Morris, Jack, et. all.

Much appreciative of the code you provided. Works to a Tee. I'm much more in debt to the thought process of the query you wrote;...

Jack Corbett (4/6/2009)

---

Exactly! I don't drink but posts like these could...

Jack Corbett (4/6/2009)

---

Please don't qualify the results in the data I presented, just answer what your requirements require you to return based on the data provided. It seems you...

JacekO (4/6/2009)

---

maybe my typo messed it up.

The line

GROUP BY Col_1, Col_2, Col_3

should be

GROUP BY Col_1, Col_2, Col_5

5 instead of 3

If it is not this then I think I...

Jack Corbett (4/6/2009)

---

Based on this data:

ID Col1 Col2 Col3 ...

JacekO (4/6/2009)

---

Is this what you need? (It is hard to figure out what do you really need)

SELECT Col_1, Col_2, Col_3, Col_4, Col_5

FROM Table

INNER JOIN (

SELECT

MAX(Col_3) AS max_col_3,

MAX(Col_4)...

Jack, thanks for the guide, i reposted by reply coded as table data to the previous poster. I hope this makes a difference. I'll review your link in more detail....

GSquare, (and thus...

Matt,

would this trigger work if the update was done on a linked table from Access? I support users touching tables directly, but not writing UPDATE statements. They go into...