My query dosnt allow edits when I use a select statement

[mark_jm via AccessMonster.com]

I have a query which uses data from one table, but which selects data from
other tables dependant on certain field values.

The query works fine until I add the select ststement:
exrate: (SELECT [currency_rates_table].[rate] FROM [currency_rates_table]
WHERE([currency type] = [Suppliers].[currency] AND [from]<=[date entered]
AND [to]>[date entered] ))

As soon as I add this select statement,( which does what is is supposed to do)
, the query them dosnt allow edits???

Any ideas why and how to over coem it. I have tried converting it to a
dlookup, which does seem to work , but this is not as efficient as the select
statement , and I would really like to understand why the select statement is
doing this any way???

 

[Allen Browne]

Displaying results from a subquery will make your query non-updatable.

Perhaps you could use a DLookup() expression to get the rate.

 

[Stefan Hoffmann]

hi Mark,

Any ideas why and how to over coem it. I have tried converting it to a
dlookup, which does seem to work , but this is not as efficient as the select
statement , and I would really like to understand why the select statement is
doing this any way???

Why, cause it is so. But your sub query looks like it should be possible
to convert it to a LEFT JOIN.


mfG
--> stefan <--