Query question on data by Last date

L

Larry L

I have a set of data with about 20 records on each of several dates. I'm
trying to get my query to just give me the set for the last date, without
having to know that date. I tried the Summation - Last and the Max in the
Date field, but it still shows me all the data.

There are about 12 pieces of data in each record, and I find that if I
just choose the Date field, and another field that doesn't change, Both
Last and Max do indeed eliminate all the other dates records, but as soon
as I add a field that changes, all the dates records show up?

I'm sure this is simple, but I'm stumped?

TIA,
Larry L
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to use/create code in MS Word to calculate age? 0
Creating a Chart on form from selected data in query. 0
Append Crosstab Query to Existing Table 0
Grouping Names in Mail Merge 0
Format change in merge data - Bold formatting after a comma 0
Copy previous record into form field 0
Display weeks from a Milestone 0
Publisher is filling blank lines with data 2

Top