Recent content by davelarue

In this tutorial http://www.databasedev.co.uk/access_max_function.html - I want to add a third column in the result above (pic) = strProductName (name of the product). Any ideas how i do this? Thx, David

Hi, New to this forum, and i think its a great initiative! I need 10 posts, so i can post my technical question. Thats why i'm going crazy below here.... ;) Thx, davelarue

Using the MAX(): i searched internet and found a tutorial. databasedev tutorial from this tutorial, how do i include strProductName in the query? This is an example, and i am doing the same for another report which has 10000 entries. If i just include strProductName in the query, then i don't...

To make things clear, i made an example. Column B represents the data which are same for both tables. The right table has 1500 entries, left table has 500 entries (which are duplicates in right table). I want the result to be right table with 1000 unique records...

Hello, What is the simplest way to subtract the contents of table A from table B? One of the columns of table A contain duplicated entries of a column in table B. What i want is the opposite of: "Only include rows where the joined fields from both tables are equal" Thank you. David