Results of a query to define the field name in another query

[jasonoski]

I want to specify the data that populates a column with a query by using the results of the query. I need to accomplish this within the regular query builder. To define the field I used this:

TestCurr: (SELECT mtbl_TimeToDataBucket1.NRxBucket
FROM mtbl_TimeToDataBucket1
WHERE (mtbl_TimeToDataBucket1.Order)=37)

So column TestCurr should be populated with the single record returned from the query. Like saying TestCurr:"Result" but to get "Result" text string, I am using a query.

How do I accomplish this?

Thanks,
Jason

 

[Norie]

Jason

I'm not 100% sure what you are after but the only way I think you could do this is using some VBA code.

 

[jasonoski]

If I have to do it in code, I will. Would you mind posting a simple code example? I could probably figure it out from there.

Thanks!

 

[Norie]

Jason

Can you explain exactly what you want to do?

Like I said in my original post I don't quite understand what you want.

Also any example of data and expected results would be helpful.