Create Query for calculated column (1 Viewer)

[vbaInet]

I have to explain the whole thing to other person again.

You will be explaining to a community, not a particular person. There are people who may have been following this thread. If that's what it takes to get your question answered, then I guess you have to do it

Alright, what is the question?

 

[yasmeen]

Thanks!

My question is:

I have a subform where i have some colums in it, its data depends upon the options selected in main form. I want to correspond this 'calculated pips' column from this query with the subform results, so i will able to see which submitter has earned how many pips on selected date.

Thanks

 

[vbaInet]

Can you not use another subform that will display the PIPS and link it the main form?

 

[yasmeen]

But how it will corresponds to the existing subform rows?

 

[vbaInet]

Do you want to link it to the main form or to the first subform?

 

[yasmeen]

both...main form as well as subform

 

[vbaInet]

It can't be both. If the main form is linking to the first subform, then there's no point in linking the second subform to the main form. What is the name of the field that links the first subform to the main form?

 

[yasmeen]

there are 2 fields which links the main form to 1st sunbform, i.e. Submitter and dates

 

[vbaInet]

Which fields do you expect to use to link subform2 to subform 1 and main form?

 

[yasmeen]

Hi, i want to match 'key' field of the query to the 'key' field of subform. I am attching the screenshot of my form, in the subform i have Action, Quantity, dates, Submitter, symbol and Pips columns. I need to get the pips values from the query.

Thanks

Which fields do you expect to use to link subform2 to subform 1 and main form?

 

[vbaInet]

I was going to say use a subquery but that will make the recordset unupdateable. So you have a to use a DLookup() function:

http://www.techonthenet.com/access/functions/domain/dlookup.php
http://www.mvps.org/access/general/gen0018.htm

 

[yasmeen]

I go through the links you have mentioned. From there i get a idea what Dlookup do but here in my application, i don't know how to combine subform and query outputs in the right way

 

[vbaInet]

First of all, I must have told you that PIPS should not be a field in your table. If it is, get remove it.

From what you understand, what have you written?