Recent content by yasmeen

  1. Y

    Create Query for calculated column

    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:
  2. Y

    Create Query for calculated column

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

    Create Query for calculated column

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

    Create Query for calculated column

    both...main form as well as subform
  5. Y

    Create Query for calculated column

    But how it will corresponds to the existing subform rows?
  6. Y

    Create Query for calculated column

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

    Create Query for calculated column

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

    Create Query for calculated column

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

    Create Query for calculated column

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

    Create Query for calculated column

    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]...
  11. Y

    Create Query for calculated column

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

    Create Query for calculated column

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

    Create Query for calculated column

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

    Create Query for calculated column

    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'...
  15. Y

    Create Query for calculated column

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