about group by query

  • Thread starter Thread starter rudwan
  • Start date Start date
R

rudwan

hi
i have a table contain :
CustID long
InvDate Date
InvAmount Currency
Shipped boolian
i designed grouped by query to give me last invoices for
each customer like this :
CustID groupby
InvDate Max
who i can bring invamount & shipped from the same query
 
You must log in or register to reply here.

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

Subtotal charges by month 4
Query problem, Please help! 4
Selecting desired value in totals query 4
Need help with a complex data set 12
Sum up by cust w all details 2
Invalid use of Null (You'll be sent to Guantanamo Bay!) 3
How to add line numbers to groups within a query? 2
Maximum Date Query Problem 6

Back
Top