I'm basically new to creating a query/database. We currently have a query
of
which information is taken from 2 separate tables. Each table has hundreds
of
entries and they are linked according to their Order No.
One of the table (Forecast table) contains several entries such as
Forecast
Date, Status, CAP Forecast, EXP Cost, among others. These entries have
different values. I'd like to update our current query and narrow down the
result taken from the Forecast table wherein it will only pull the last
entry
or line (most likely containing the latest date). This result should not
sum
up the dollar amounts entered in the other 10 columns but would only take
the
info from the last line/entry or last row. I would greatly appreciate any
help you can give me. Thanks.
