Search results

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 :confused:

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

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

both...main form as well as subform

But how it will corresponds to the existing subform rows?

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...

But this is a connected question, I have fit this query with my subform coulms. I have to explain the whole thing to other person again.

Hi, I am very sorry to trouble you with my silly mistakes. I got the result of that query now. Will you please assist me further on this? It would be very helpful As i am very new to MS Access and i don't know much :( Thanks for your help

Hi, I have changed what you have suggested me Here is my new query for PriceDiff: PriceDiff: Abs([1st dec].[Price]-(SELECT TOP 1 Q.[Price] FROM [1st dec] AS Q WHERE Q.[Key] = mid([1st dec].[Key],1, instr(1, [1st dec].[Key], "/") - 1) & "/1/" & mid([1st dec].[Key], nz(instr(1, [1st...

Here i have attached the screen shot of my query and here are the codes which i am adding as follows: CalcPips: IIf(InStr(1,[Description],"JPY")>0,"Price Difference * 100","Price Difference * 10000") PriceDiff: Abs([1st dec].[Price]-(SELECT TOP 1 Q.[Price] FROM [1st dec] AS Q WHERE Q.[Key]...

when i insert the code for creteria of 'Pricediff' and 'calcpips', it is showing the following messages: You Cannot set the creteria before you add a field or expression to the field row. & The expression you have entered has an invalid .(dot) or operator or invalid parentheses Please tell...

Few Questions please: when i am adding code under key field creteria, it is showing that 'data type mismatch in createria expression'. Key feild's dayatype is 'text'. Same thing is happening when i write for 'Pricediff' creteria. 'Pricediff' is not in my table columns, so it is not allowing me...

244/1/-9934863 is a value of 'key', we need to look at price column correspondence to the key column. Key is just to recoganise the pairs. (the two rows which will have 244/1/-9934863 and 244/0/-9934863 will make a pair.) In this way we will get 2 prices for each pair and we need to subtract...

My form structure is as follows: I have 3 combobox on main form which filters the results and displays in subform. 1st combo box: submitter 2nd combo box: starting date 3rd combo box: End date I have a button to filter the subform. It works fine. In that subform, i need to calculate 'pips'...

I have only one table in my database. So i have to use the same table in my form and subform :mad:

ok, so i will combine this query with the query for my subform. For subform, i just need to select some columns from my table plus i need this calculated feild. But i don't know how to calculate as it is very complicated for me. Please help me. In my subform, i need the following columns...

Will you please help me to write a query for same database. Query is: I have to add a calculated coulmun in my table called 'pips' and How it will calutate is as follows: - I have pairs of trades in the table and subtraction of 'price' of pair is called pip of that row. -We can use 'key'...

Ok i post it in new thread, thanks :)

Will you please help me to write a query for same database. Query is: I have to add a calculated coulmun in my table called 'pips' and How it will calutate is as follows: - I have pairs of trades in the table and subtraction of 'price' of pair is called pip of that row. -We can use 'key'...

Re: Dispaly values in subform based on multiple combo boxes Yeah, but my client don't want that records who has no submitter or date. So its not a problem for now. :)