Show last adjustment of a bill...

I have a table of bills. Each bill has a bill #. Each new bill is labeled
VER_NUM "001". When a bill is adjusted, the VER_NUM changes to "002". If the
same bill is adjusted a 2nd time, the VER_NUM changes to "003". I want to
create a query that will show only the last VER_NUM for each bill. I have
tried an IIF statement, but I can't get it to work. Please help.
.

Relevant Pages

  • Re: Cant execute SQL and get recordset back.
    ... you want to and execute them together. ... William (Bill) Vaughn ... > row from the query. ... In cases where there are multiple resultsets, ...
    (microsoft.public.vb.database.ado)
  • Re: Automatically adding data between two dates.
    ... I have a calendar table in many of my applications with one record for each date for whatever time frame I need. ... FROM CalendarTable as C INNER JOIN Bill as B ... If you feel it is absolutely needed, you can use this query to populate a table that you have created with the needed fields. ... Meter# date $/day ...
    (microsoft.public.access.queries)
  • Re: datetime conversion from UDT/GMT to localtime
    ... William (Bill) Vaughn ... My database has all date/times stored in UDT/GMT in datetime ... the query, the query then returns the correct resultset, but of course, the ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Complex RecordSource
    ... FROM Bill ... You need to join your menu table to the query to display their selections. ... her spouses ... as the last name on the name tag of the spouse. ...
    (microsoft.public.access.reports)
  • Re: Complex RecordSource
    ... FROM Bill ... You need to join your menu table to the query to display their selections. ... her spouses ... as the last name on the name tag of the spouse. ...
    (microsoft.public.access.reports)