Search results

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

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

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

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

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

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

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

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.

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.

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

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

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

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

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

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

finely it works! It will save lots of hours at my work. Thanks a lot for your help I really appreciate it:):):):):):):):)

I'm little bit confused I created first qry from a table which calculate a sum of the groups: SELECT [table1].CODIGO, Sum([table2].CLOROFILA) AS SumaDeCLOROFILA FROM [table1] INNER JOIN [table2] ON [table1].CODIGO = [table2].CODIGO GROUP BY [table1].CODIGO; than I created second qry where I...

I'm not sure that I understand how to do it

it's true what you said , but my problem is that I have to do to much queries (about 200) to make function that

Pat thx for your help, if I understand good, idea is to made a 1st qry that calculate sum of grouped values and than in second qry take out a percentile from field of sum, that should be grouped by same fields but it doesn't work because the code calculates percentile from the sum...