Recent content by mhoek74

That was it! (Why couldn't I think of that?) Maybe someone could explain this to me...because I thought distinct would only give me a single distinct column (like in my example all distinct first names) while you needed the distinct row for the operator to look at all columns. Thanks

Here are some results from this query... Kirk Stevenson Kirk Stevenson Alton Jones Daniel Harlewicz Kevin Kones Kevin Kones Kevin Kones Kevin Kones Kevin Kones I would expect to only see... Kirk Stevenson Alton Jones Daniel Harlewicz Kevin Kones Thanks, Mike

I created a simple report and made it look nice in terms of spacing, etc. When running the report and then publishing to Word, of course the formatting is preserved and it looks nice, etc.. However, when choosing the "Analyze it with MS Excel" option, the data is dumped in the...

OK, this seems simple enough...I would like to get distinct rows from the following query: SELECT DISTINCTROW Query1.[Managers First Name], Query1.[Managers Last Name] FROM Query1 INNER JOIN Table1 ON (Query1.[Managers Last Name] = Table1.[Last Name]) AND (Query1.[Managers First Name] =...

Hello, In an Access query, I would like to use the like operator (or a variation) on a field rather than a string. For example, SELECT table_a.x FROM table_a, table_b WHERE table_a.x like table_b.y Is something like this possible? Thanks! Mike