I have Table A and Query B with the same four fields. If three of the fields
match, then I want to take the fourth field (which is a summation) from Query B
and copy it to the fourth field in Table A. Whenever I try to run an update
query to do this, I get the message Operation Must Use An Updatable Query.
The mere presence of Query B in my update query, whether I refer to it or not,
causes the above error message. I tried using a Dlookup in the Update To
field, but this does not resolve the problem.
Is there a way to correct this? If not, is there a way around it?
Re: how do i? ... The DLookup fixed it. ...John Spencer wrote: ... If you want to display the value of TheDateField in the query result, ...George Applegate wrote: ... (microsoft.public.access.queries)
Re: comboBox & northwinds sample orders form ... True, but OFTEN to display a customer name when you have a customer id, we ...dlookup) are suggest. ... the problem is that you don't need dlookup in a query.... You can always just shove in the sql in place of the ... (microsoft.public.access.formscoding)
Re: Problem with Dlookup function ... The problem is not with DLookup.... What you'll need to use is a query, instead of the table, as the "data ... The GrowthForecast is a field that needs to be updated with values from ... > qryFunctionTest Product ProductID ProductCode Location Year Month ... (microsoft.public.access.modulesdaovba)
RE: Verify data with Dlookup ... I still think Dlookup is the way to go for my situation. ... The procedure refers to a table not a query now. ... >> Since there would be multible tickets for each asset tag number. ... >>> looking for a specific ticket number or do you want to return a ticket ... (microsoft.public.access.formscoding)
Re: Getting Query to show calculation for all records ... it because I am using a DLookup in order to get the query values to show up ... tblHolds and any matching records in tblReleases (Change INNER to LEFT). ... Here is the SQL for the query.... (microsoft.public.access.queries)
