Search results

add another field Hi, I wanted to add another field to my query using the code below. The new field is another set of "Transaction Detail2" from another table. How can I add the new field to the existing code below from another table which has the same fields (as my original table) except for...

Thanks Jon. That worked. I'm afraid I have to bore you people once again though. I used that query in my report, however since Company 1's transaction details are on 3 different lines the report shows them as 3 separate pages. Is there any way that I can have the query results such that the...

I'm trying to write a query that will eventually be used in a report. However I haven't got my query to work yet. I have this so far but the syntax is off and it doesn't work. SELECT ParentRecommendationDetail.RecommendationDetail, ParentRecommendationDetail.ParentName FROM...

I feel love....i think :)

Thanks dcx693. However I needed the last 5 transactions for each company. So if there were 100 companies then the query would show 500 transaction details. Using the SELECT TOP 5 function alone will just give me the most recent 5 entries in the database.

I'm not feeling the love. my post 'last 5 entries' is the only one on this page wothout ANY replies. :(

getting last 5 entries from a table Hi, I have to create a query that will get the 'last 5' transaction entries for 'each' company in a table. The table consists of about 100 companies, each with anywhere from 1 to 10 or so transactions. Any ideas on how to proceed. I tried the Multiple Entry...