Search results

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

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

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

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

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

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