access 2007; sql query in a field?

[cmdturk]

hello,


i want to have a cell that shows an sql query and sth like formula. for example;
table1 fields: ID, WareName, Total, Came, Remaining
table2 fields: ID, RelatedID, Came, Date, Comment

table1.Came and table1.Remaining must be automated values:
table1.Came=select sum(t2.Came) from table2 as t2 where t2.RelatedID=ID;
table1.Remaining=Total-Came

how can i do that?
thank you,
mustafa öztürk

[NTC]

I must not understand your question, as the answer is too easy....just put that text into an unbound text box....

[cmdturk]

I must not understand your question, as the answer is too easy....just put that text into an unbound text box....

thanks,
but i am unable to get sql query in a text box. i inserted a text box on the auto generated form and write in it: "=(select sum(t2.Came) from t2 where t2.RelatedID=ID)"

the second text box is "=[total]-[txtCame]"

both give error.

but if i write "=[total]*2" it works.

i attached the sample accdb file.

thank you for your answer,

[NTC]

ah - I thought you simply wanted to display the syntax

you want to actually run the sql...

Access is event driven - so to run a query you must put that statement at an event...tab event, afterupdate, form current....some event - - not in a passive textbox control....

[cmdturk]

ah - I thought you simply wanted to display the syntax

you want to actually run the sql...

Access is event driven - so to run a query you must put that statement at an event...tab event, afterupdate, form current....some event - - not in a passive textbox control....

can you tell how to do it?