Re: Using Totals w/ an Updateable Recordset
- From: John Vinson <jvinson@xxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Mon, 17 Jul 2006 11:31:26 -0600
On Mon, 17 Jul 2006 09:06:01 -0700, Jamie McD <Jamie
McD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:
I have two tables with a one to many relationship, well call them A and B.
I have a continuous recordset form based upon this relationship.
The issue I'm having is I only want the Last value of B to show up - meaning
I do not wan't multiple lines from A for each B, just one.
I can do this using the Totals option of the Query, and choosing last for my
B value, it works - I only get one record from A, and the latest record from
B.
Ummm... you're being tricked. The "Last" operator is all but useless.
It does *NOT* mean "the latest record" - it means "the last record in
disk-storage order". Sometimes it will actually work for you but you
have NO guarantee; Access will store records wherever it pleases, not
necessarily in data entry order.
The problem I have, is that I need to update a field from A, using this
query on the form. The new recordset that shows the info I want, comes up as
un-updateable.
No Totals query, nor any query containing a Totals query, is ever
updateable (even if logically it should be).
I can use Dlookup at the form to find my value, but my users don't really
like how it works with the continuous recordset.
That's unfortunate because it's your only workable solution.
John W. Vinson[MVP]
.
- Prev by Date: Re: Using Totals w/ an Updateable Recordset
- Next by Date: Re: help with sql query
- Previous by thread: Re: Using Totals w/ an Updateable Recordset
- Next by thread: Column Order in Output
- Index(es):
Relevant Pages
|
|
