Recent content by Andrej

  1. A

    how can I restrict the data tables

    Also I mess with a database password. Is it possible to turn it off, it start to annoy me, writing the password and user name and know that is totally useless
  2. A

    how can I restrict the data tables

    I also mess up with the database password...now I know that it's totally useless ...is there any way to turn it off...
  3. A

    how can I restrict the data tables

    yes,I tryed to use ULS but probably I didn't implemented it properly. Is there any way to turn it off. I also was trying to implement partial replication and probably doesn't work because of ULS
  4. A

    how can I restrict the data tables

    I'm working with the Access 2007 program but the data base is in .mdb extension (2003) My question is how to restrict parts of data base for the various users. I tried to restrict by tool of access data base but the users are restricted just on my pc and on the pc where I put the replicas...
  5. A

    Mapping Tools I Can Use With Access

    If you need something more specialized you can connect ArcMap version 9.x with Access data base.
  6. A

    Sum conditond by date

    It's probably point and coma. Spanish version use coma for decimal numbers and as I see English version use point. But this should not affect the code and the values that Access gives me doesn't have any sense. I really don't know what I can do to change this. Thx for your time and help...
  7. A

    Sum conditond by date

    FECHA LLUVIA ACUMULADA DIARIA RunningSum 15/01/2007 0 0 16/01/2007 0 0 17/01/2007 0 99,199 18/01/2007 0 122,599 19/01/2007 0 161,599 20/01/2007 0 279,799 21/01/2007 0 296,399 22/01/2007 0 303,199 23/01/2007 0 303,199 24/01/2007 0 330,399 25/01/2007 0,4 410,599 26/01/2007 86,199 722,197...
  8. A

    Sum conditond by date

    when I was read your post I was shure that query will function perfectly, but it has exactly the same result as query before. I will attach you the same file with two query to see that results are the same.
  9. A

    Sum conditond by date

    I really don't know, but I get the exactly same results like it was before. I copied your code and put it in new query and I have the same results... don't know why.
  10. A

    Sum conditond by date

    date is defined in the right format. Really don't know what could it be. I will attached table and query thx for helping
  11. A

    Sum conditond by date

    it looks that's it, but values are not that should be, they are much more bigger when I look the code that you send me it looks perfect, but values are much more bigger and I can't find out what is calculated. FECHA value RunningSum 08/07/2005 0,8 25,6 09/07/2005 0,8 59...
  12. A

    Sum conditond by date

    that's great solution but doesn't solve my problem. I need a sum of values of 15 days for each day of table B. my problem could be solved just working with table B to get a table as: date________value____15 day events sum 01/01/2006 ___1,2 ________18 (value 15 days before +value 14 days...
  13. A

    Sum conditond by date

    solution for my problem also can be: just from table B, make a query that has a column with a date and column with a last 15 day events sum: date__________value____15 day events sum 01/01/2006 _____1,2 ________18 02/01/2006 _____0.8 ________17.6 . . . 15/01/2006 _____1.4____(1.2+0.8....+1.4)...
  14. A

    Sum conditond by date

    I'm confusing person and my threads also, thx for reading and trying Table A have one event per month and table B has events trough whole month(31 events). During the one month they coincide in one day. I want to make query where are coinciding dates and from table A put the value of that...
  15. A

    Sum conditond by date

    Hello&thx to everyone, who opens this page My problem consist 2 tables, where values from table B have to be added to table A in function of date. Table A have a one value per month and table B have daily values. Problem consist adding a column with sum values from table B to the value of table...
Back
Top Bottom