Search results

Thanks for your work! The query is close but still not exactly right. A question: When you specify 'First', 'Last', 'Max', etc. in a query, will the result be limited to a single row? I.e. if the rows are different will the query return the first, last, max value no matter which...

dK, Thanks for the help. I have tried iterations of the post you pointed me to, but to no avail. I am way over my head I think :-) Here is the (scrubbed) needed portions of the db and queries. SampleDB.zip If you look at query_hippo_current_mod_only you will see it uses _zebra_current_ to...

I didn't explain it very well... Here is the query: querys.GIF Here is the data that results from the query: data.GIF For each budget id we need to pick out the SumofAmount for the latest mod_end_date, either in this query or the following one. I am a noobee at this kind of thing, and have...

We have a table that has dates and amounts in it. There are multiple rows for each date. We need to have a way to return the sum of the amounts for the latest date in the table, and only the amount for the latest date. We have a query that sums them, but it returns a row for each date. How...