Search results

I'm not sure if I understand you. I have too much groups that I can make a query for the each group. If I made a query with grouped data, I have to make 200 more queries and if I wanna chage something like date to filter, I have to change on every query that I create.

The problem with a code is because it calculate a percentile value for the whole data set. I need values for the each group, that are grouped by the same name or number of other field. I have to much groups that I can't make other queries to calculate from them I don't know if I explain it...

Hi all, I'm trying to get a public function to work within the design view of a query. The function is defined as: Public Function Percentile_(fldName As String, _ tblName As String, p As Double, _ Optional strWHERE As String = "") _ As Double... ( I can put the whole code if u need it) Any...

in a way, is a lot's of ecological data that needs to have a value of percentile and g. mean and then it's all connect to ArcMap to present that on GIS maps. is it possible to put function in the function like: PercentileRst («RstName»; Sort by other column «fldName»; «PercentileValue»)

on beginning it was my idea too It's possible, but is not useful I have to do 140 queries to do that work but thanks anyway

Hi I found the code to calculate percentile value and It works fine, my problem is that code is calculating value for the whole data set, not for the filtered data. PercentileRst («RstName»; «fldName»; «PercentileValue») is it possible to put some function that can filter or sort data...

it works, this is great, thank you. it really helps me a lot

sorry for the late response, the table is normalized, but the query it's modified in the sense that change the column in string type because the minimum has to be presented like <0.01 value. numbers has a problem when value is 4.00 in the report is presented like 4. is it possible to change...

thanks for advice, but if the field has strings and the numbers, setting this format doesn't shows 2 decimal.

thanks for quick answer, and is it possible to do it in the table?

that seems good solution, how do I use this function?

Hello my problem is how to reduce decimal number of column in the tables. Problem is that some numbers are quotients and they have a lot of decimal which make a problem in the report where they have to have just 2 decimals. Column in the query and in the report is not reserved only for...

Hello my problem is how to reduce decimal number of column in the tables. Problem is that some numbers are quotients and they have a lot of decimal which make a problem in the report where they have to have just 2 decimals. Column in the query and in the report is not reserved only for...

have a problem in the report with a number of decimal for instance, need to have a 2 decimal number in the column of numbers, but data in the column not is always number(<0.01) any idea how can I get in the column of report with 2 decimal numbers in combination with strings

Hello my problem is how to reduce decimal number of column in the tables. Problem is that some numbers are quotients and they have a lot of decimal which make a problem in the report where they have to have just 2 decimals. Column in the query and in the report is not reserved only for...

IT WORKS!!! also in Spain thanks both of you, you realy halped me a lot

you understand my problem, and you give to me great solution but still I have a error in the report I changed [ ; ] for [ , ] and report didn't want to show aether error column and says to me that syntax's is wrong. Is it possible that Spanish windows and Access have different syntax? On the...

hay this is great solution for user like me, but when I put in the box statement: =iff([name of column]<1;"<1";[name of column]) aether =iff([name of column]<1;"<1";">1") in the column of the report I get #Error thx for response

sorry, but I'm very green in the programing could you put me some example that I can put in the VB and use IF "value of column of query or report"=0,1 THEN "change with"="<0.1"-in the report My problem is than I don't know when to put "" or [[]] in VB and how to call some column in specific...

Hello I'm novice user of access so now at final point I have problems that I don't know how to resolve I have a columns of environmental data that i want to present in the Report My problem is that, some values(like 0.005) at report I have to change for value of string(<0.01). is it...