Search results for query: *

THanks guys :) I am sure I can work it out from here. If I run into trouble later on, I will get back to you (if I may :)) Sheila

Hi! While I was surfing the web I ran into quite an interesting website, namely of Compagnie Financière Richemont S.A. (http://www.richemont.com/). The pictures on the welcome page change with each viewing. So does the color of the center table. I know there is some php involved. But I am not...

Darylle I got it! Thanks! :) The settings in my country are just different.

I get your point now Darrylle :) But I have no clue where to go from here. All the data in my tables use a comma as the decimal point and it seems to work fine! E.g. 1.5 gives 15, not 1 1/2. Maybe the settings are different.. but for the code to work in VB I need a dot as a decimal point, right...

Really? I find that rather strange.. so you write down 2,900.75 instead of 2.900,75 (being 2900 3/4)? Still, what can I do to solve this? :( Sheila

Hi People! I have a small problem with my VB code. It has to copy records to another table. It works fine as long as the AmountEuro field contains decimals(for example 2000). But when I try to copy one with decimals (for example 200,05) I get a syntax error. What am I doing wrong? Thanks...

Oh! You are right ^V^ Thanks a lot!

Hi Duane. I thought my database was finished but when I had a closer look I realized my sum totals were incorrect. I am not sure what is happening but dependent on the number of records available in a table the sum gets multiplied. For example.. when the invoice conatins three records...

Paul, when I do that I get an error message: "The expression you entered contains invalid syntax. You may have entered an operand without an operator" :( Thanks again, Sheila

Hi Paul, Ofcourse you are right. But here is the situation. I use the following expression: % A/T: [Actual Sum]/[Turn] Works great as long there is a value for the turn field. For example: 100/1000=0,10. But when the turn field is empty I get the #error value :) For example: 100/0=#error :)...

Hi all! I want to rename a "#Error" value to "-". It looks much better :) But I am not sure how to do it. Thanks.. Sheila!

Hi everybody! I just wanted to let everybody know that I got my problem sorted out! Thanks a bunch to everyone who lend me a helping hand Sheila

Hi Dhookom! Thanks a lot for your reply :) It got me a bit closer to my goal. I still have one small problem though. I now use the following query: SELECT [Account Union Query].[Account Code], [Account Union Query].[Budget Year], [Account Union Query].Quarter, Sum(Nz([Budget],0)) AS [Budget...

Hi! Please take the time to read about my problem. I have been at it for weeks and if I can't find a solution this time, I guess I have to give up my project :( But here goes: I would like to make a report which shows and combines data from two tables, i.e. 'Budget' and 'Invoice'. I am using...

Hi! I would like to make a report which shows and combines data from two tables, i.e. 'Budget' and 'Invoice'. I am using 5 fields, namely: 1. Budget Year 'from Budget table (the field is also available in the Invoice table); 2. Quarter 'from Budget Table (also entered in Invoice table); 3...

Hi everybody, Unfortunately Nick has been very busy the past week en het did not had the time to look into my problem. So if anyone else can offer me a helping hand, I would greatly appreciate it :) You can see all the details above. If you want me to send you the database, just post your...

Nick, Is it ok, when I send you the database with only the tables and the query I am working on? :) Thanks for your help! Sheila

Hi Leslie! I am think I am very near. However, when I enter the following code: SELECT Budget.[Account Code], Budget.[Budget Year], Budget.Quarter, Nz([Budget],0) AS Expr1, Nz([Amount in Euro],0) AS Expr2 FROM DataEntry RIGHT OUTER JOIN Budget ON (DataEntry.Quarter = Budget.Quarter) AND...

Here is the query I am using now :) Hope it is clear :) SELECT DISTINCTROW DataEntry.[Account Code], Budget.[Budget Year], DataEntry.[Amount in Euro], Budget.[Budget] FROM (Account INNER JOIN Budget ON Account.[Account Code] = Budget.[Account Code]) INNER JOIN DataEntry ON Account.[Account...

Hi! I would like to make a report which shows and combines data from two tables, i.e. 'Budget' and 'Invoice'. I am using 5 fields, namely: 1. Budget Year 'from Budget table (the field is also available in the Invoice table); 2. Quarter 'from Budget Table (also entered in Invoice table); 3...