Re: Using Totals w/ an Updateable Recordset
- From: "Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx>
- Date: Tue, 18 Jul 2006 00:33:45 +0800
You should be able to use a subquery in the WHERE clause and still have an
updatable query.
Subform recordsource would be something like this:
SELECT B.*
FROM B
WHERE B.ID =
(SELECT Max(ID)
FROM B AS Dupe
WHERE Dupe.FK = B.FK);
The example uses ID is the autonumber primary key, and FK as the foreign key
field name.
If subqueries are new, see:
How to Create and Use Subqueries
at:
http://support.microsoft.com/?id=209066
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Jamie McD" <Jamie McD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8D6E4CB2-740D-4549-AB92-802E2ABC6F4C@xxxxxxxxxxxxxxxx
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.
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.
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.
Any thoughts?
.
- Follow-Ups:
- Re: Using Totals w/ an Updateable Recordset
- From: Jamie McD
- Re: Using Totals w/ an Updateable Recordset
- Prev by Date: Re: join with no related field
- Next by Date: Column Order in Output
- Previous by thread: Export to Excel??
- Next by thread: Re: Using Totals w/ an Updateable Recordset
- Index(es):
Relevant Pages
|
|
