By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,937 Members | 1,416 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,937 IT Pros & Developers. It's quick & easy.

help needed with a query

P: n/a
i have two tables
---Rental-----
Column name Data type Comments
TransactionNum Long Integer Primary key.
VideoCardNum Text(10) Foreign key Customer.
StoreNum Text(3) Foreign key Store.
Barcode Text(15) Foreign key VideoCopy.
DateRented Date/Time
DateDue Date/Time

--------VideoCopy--------
Column name Data type Comments
Barcode Text(15) Primary key
TitleNum Long Integer Foreign key VideoTitle AutoNumber
storage.
StoreNum Text(3) Foreign key
Available Yes/No Y or N
Fee Currency
i need to get the sum of the fee collecte on the latest date for each
store
itryed this but its not working its giving the combinations which i dont
need

select sum(fee) from rental where daterented in(select max(daterented)
from rental group by storenum,daterented) and storenum in (selec storenum
where daterented in(select max(daterented) from rental group by
storenum,daterented)) group by daterented,storenum;
this is in access
when i use this
it is giving a combination which i dont need
can any one help me with this please

DateReturned Date/Time Null indicates the video is still out.
Nov 13 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.