Recent content by Zlatkodo

Thanks for your effort, but I need more time to learn how to implement the access than to do it manually. It is very surprising and discouraging for beginners, that is such a complex process to do such a simple thing.

Thanks for fast response. Where I need to put your code? I am using Office Access 2007. I suppose I need to open Querry Wizard , select the num1 and nim2 from Available Fields to Selected Fields, and what then?

I neet to make only one change in my mdb access database with lot of rows. For example, I have two columns: "num1" and "num2" with numbers and need to create new column (as a text) according the rule: num1 # num2 That means if the numbers in num1= 12 and num2=...

I have not found a way to rounding. I'll give up and do it manually. Zlatkodo

Hi Janr, Where's the Help? What is F1? I was just joking. I have done according to your recommendations and now is OK. Thanks again for your explanation. Zlatkodo

Data type is number, field size is double, format is general number and dec. places is auto. Yes, I put exactly this: "Round(([Amp]*1,73),1)" Without " I get the error. Zlatkodo

I can not see Compact and Repair in Database Tools. Zlatkodo

I have a accdb-database in Access 2007 which consists of only one table with several columns and several thousand rows. Total size is approximately 1.7 MB. I have used "Find-replace" and I replaced the strings in a single column with new strings. But now the size of my database as many as 27...

Hi Bob and others, If I use: "Round(([Amp]*1,73),1)" I get the error: Microsoft Office Access can not update all the records in the update query. .........due to...

Instead: [Amp] = [Amp]* 1.73 in "Update to" must be only: [Amp]* 1,73 and then is OK. I must only find the way to round results in 1 decimal place. Thanks for helping. Zlatkodo

I tried on second way but I get strange results ( " 0" or "-1" ) on right places in database. Zlatkodo

Please, a little more details for the querry-design . Where to locate your code? Is this the whole code? Zlatkodo

I am a beginner in Accsess 2007. I have a accdb database . It's really only one table with several columns and several thousand rows. I need to make a single change to the database. I want to multiply by 1,73 the values in two columns called "Amp" and "Ixx" but only in those rows where the value...

Hi, Adam, You're right. I have already fixed the error. I'll try to do as you suggested. Thanks. Zlatkodo

I have a database in Access 2007 (accdb) , that consists of only one table with several thousand rows. I must add a new column X and enter into it values that depend on the value of the same row in column A, something like this: -" if 1500< valueA<=3000 then valueX=2 - if 1000< valueA<=1500 then...