Recent content by jimbrands

the screen shots off the output do not function?? :banghead:

I made the sample datadase3(which contains the 4 tables and 4 querys and the totalquery/ and all the relations involved), to make things clear but appearently I don't seem to achieve to explain the problem , the Cartesean matter is not an issue. Everythings is working well in my project...

please have a look at the example database3 I made 4 tables , the totalquery1 works well, so now deletate the empty record in table3 for project 2000 then the query makes no calculation for project 2000 although there are entries in the other 3 tables for project2000 note : for every...

A right join is not the solution, because when it is the other way around and for example table2 has no record for project 2000 but table1 do has a record then the query will not function. In my project system it concerns 4 different tables, so there are many possiblities for example...

I made a better example , as you can see the total query shows two records for project 1000 and project 2000 and makes a calculation for both records. now delete de null record for project 2000 in table1 then there will be no more calculation for project 2000 even if there is a record with a...

See DB3 2 tables 1 query it calcultates field 1 + filed2, with the Nz function it works even if there is no entry in the table1, but there is a record with no value in it. now delete de the record in table1, so the table is empty. now the query doesn't work, but i would like the query to...

This is the actual query: SELECT [PP-VC budget uren p kostenplaats periode form].ProjectId, [PPproductie projecten].Projectnummer, [PP-VC budget uren p kostenplaats periode form].Kostenplaatscode, [PP-VC budget uren p kostenplaats periode form].[Kostenplaats omschrijving], [PP-VC budget uren p...

Hereby an example of the data I would like to calculate: for example I have a project administration and i want to regitrate the project budgets and compare these with the actual realisations, ( I have made this sollution wthin Access 2007 and it works very good and gives all the information I...

This presents the situation that I'm dealing with: The 4 tables are for example: Tabel1 TAB1ID Veld1 Tabel2 TAB2ID Veld2 Tabel3 TAB3ID Veld3 Tabel4 TAB4ID Veld4 (the fields Veld1,Veld2,Veld3,Veld4 are numeric type fields) The querys...

That's indeed correct, it's possible that there is no record in a particular table, so the Nz can't function. I've already tryed to change the joins but this did not solve the problem. In my application i have 3 different tables, so it's possible that one or even two tables have no records

Hi, I have a problem with the Nz (nulltozero) function in a query. The Nz function works well as long as there is a record , even if the field is empty, so far so good, but when there is no entry at all at one of the tables, the the Nz does not function. Example Table1 > field A contains...