Search results for query: *

Hi Remou! I have an Access2003.database, and there a form, where is a subform. Sorry Remou, I stated misleadingly "report" in original post. I enter data to both forms: 1. Main form collects main data. 2. Subform collects data, which is linked to main. In reports I use same method. Now...

Hi! I have a dilemma with Ignore-button (vbIgnore). It ignores values well in main report, but not in subreport. How would I get values in subreport to be ignored? Rgds Asbach

Hello! I am truly just beginning to even think to make any forms&reports and I am totally stuck/lost in very simple issue. I am using MS Access 2007 and its VBA tools -no special VB-application at hand. There I have few tables, without any relationships. I have table A, where I have fields "x"...

Hi guys! I am using Crystal Reports 10 with SQL 7.0 and I am lost. I have a subreport and I have bolded a stringed field (Left({table.field1}, 1) & Left({table.field2, 2). Result is on detail section: VPU JRI MIL RHA If my condition matches, then the field is bolded. That is not a problem...

Thanks's Gary. There was one dot, which was then changed to comma. That helped, although all calcultations have to be cross-checked. -Asbach

Dear all, I have had a little bit time to investigate this problem. I have a simple test as 'ns130' suggested. That works well. I have learned that all values, which have fractions (like "130,44") are being converted to "0,00" but all values, which are not having decimal values (like...

Hi Naith. I have accomslihed some testin and at least it works... :) Asbach

Hi dgillz! As I explain, I had a field, where all numbers were form 'xx.yyyy'. Somehow in database the field was non-numeric string and therefore I had to convert it to numeric. By using "replace" I changed all dots to commas ('xx.yyyy' to 'xx,yyyy') and then used "ToNumber". If you meant that...

Thanks ns130 andd gillz! However, the final solution came using "replace"-function, where I replaced all "." to ",". By that I could just use "tonumber" in a simple way without if-else operator. Regards Asbach

Hi all! I have a problem: In my database there is a field, which is actually a value of money (like 20.00 or -245.9555 or 1340 etc). Somehow it is determined to be a 'string' evethough it should be 'number'. Now, I try to convert it to be a number using 'to number'-function. My Crystal Reports...