Another query question: flat-filing

T

Tim

HA-

solved, it thanks for reading though!

took me 2 queries, one using something from the page prior
to this creating a ranking query (flipping the < sign) and
then making DateXX: iif(Rank=XX,svc_date), aggregating by
Maximum.
 

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

adding new columns 0
Confusing Query (Flat File Query/Report from Relational DB) 1
Can you use query fields as function variables? 8
create a report from multiple check boxes 0
Query for Export 1
optimize queries that refer to a calculated field in a source table 1
IF Statement in Query - Quick Question 6
Update or Append query help 2

Top