Search results

  1. D

    Axis Scale must be 1 and 31999

    for now i just deleted all charts and rebuilt
  2. D

    Axis Scale must be 1 and 31999

    Crate a BAR Chart. and if you click the x or y axis line. "format axis" option is opening and than try to click scale or the other options. IMPORTANT : at the beggining the chart scale is working. After than u cant use it anymore and you are getting this error. inherently i dont want to create...
  3. D

    line does not contine

    Hello my friends this is my 2. graphic problem. As you can see at picture. normally i need to see the lines like this. (i painted the blue color) but access shows to me without lines. if the value is 0 (u can see 2. graphic better) the line does not continue. how can i fix that problem ...
  4. D

    Axis Scale must be 1 and 31999

    its not working at all. I cant scale X or Y axis !
  5. D

    Axis Scale must be 1 and 31999

    Hello my friends, is there any option to fix this problem ?? (u can see at the Picture. ) ty for your helps
  6. D

    same records need to see only 1

    IT WORKS Thanks both of you :) I used Property Sheet Unique Values. And Show option for others removed. (they are still there. Only from show option removed)
  7. D

    same records need to see only 1

    Hello If you check my picture, some Records are similar and i need to filter them. (this is a query by the way.) For example 3303933 these are 3 records, i want to see only one (Dates and other thing are not important. I tried TOTAL option but could not find any thing there. Hope so you...
  8. D

    hiding uncheck checkbox in report

    Ty guys i did it A: IIf([tbl_name]![Skyliner]=-1;"x") this is my code and it works. If someone need that
  9. D

    hiding uncheck checkbox in report

    why shall i delete it. I just dont want to see DO NOT CHECKED !!!! Thats mean there is checked options too !
  10. D

    hiding uncheck checkbox in report

    Hello I want to hide on my report unchecked checkbox ? How can i do that ? If i shall write a code, in which event ?? Or can i use in Query Build option ? I searched on internet and found some answers but they are not useful (i found this code and updated for my report but still did not...
  11. D

    Query > Build > no more place

    as i said no VBA because i dont know how can i write there and use it in query etc.
  12. D

    Query > Build > no more place

    Hello Friends; I created a build in Query. The problem is, i need to define many things. For example : Name: IIF([Table_name]![Field_name]="Dog";"Animal"...
  13. D

    Dsum bigger or smaller than 0

    for my report i need to sum them as 3 different parts. firstly - then + and total. they want to see all values.
  14. D

    Dsum bigger or smaller than 0

    okey i guess i found how can i do that. i created 1 more field for - values and + values too (i was thinking i can do them in same field but this is more fast and easy) now i can sum them ;) Ty Namlian :)
  15. D

    Dsum bigger or smaller than 0

    i have already written this =Dsum("*";"Table Name";"[Field Name] < 0") to my text box but not working. And i really dont know how shall i write to text box sql. Is that again in Control source ?
  16. D

    Dsum bigger or smaller than 0

    okey. im sending a picture now. in my field - and + values. I need to calculate them. For example : -152400 + (-70)= -152470 these values smaller than 0 and same thing for + values too.
  17. D

    Dsum bigger or smaller than 0

    Hello friends i have a simple question i could not find any solution:( this is my code : (im using 2007-2010 and its working like that) =Dsum("*";"Table Name";"[Field Name] < 0") i need to calculate only bigger than 0 or smaller than 0 doesnt matter.. i checked from Forum etc. there is...
  18. D

    Sum Positive and negative values in same Field

    im so bad to explain myself or im so bad to understand. (after 7 hours nonstop working. its really hard to write smthing as english for me. for my picture there are 2 - Value and -152.400,00+(-70,00) = -152.470,00 this is for negative... same thing for positive too...
  19. D

    Sum Positive and negative values in same Field

    okey. I guess i wrote there wrong. I have a field and there + and - values. i want to sum up negative value with other negative values and positive value with other positive values. And i ll use these in Bar Chart after i sum these Values. For bar chart i shall separate positive and...
  20. D

    Sum Positive and negative values in same Field

    Hello friends; Im trying to get sum "+" and "-" Values in same Field. I created new Expression Builder in Query and i wrote there : A: Sum([tablename]<0) of course it did not work. :D how shall i update my expression to work this thing ? Ty for your helps.
Back
Top Bottom