Recent content by qaccess

Combine tables Why don't you combine tables 2,3 and 4

Still a problem Sorry but I think this not what I mean...Below is a query with ID and field1 from a table Test. field2 will be calculate with a formula [ID]![Test]-[field1]![Test]-field2 1-1-----3 1-2-----3 1-3-----3 2-1-----4 2-2-----4 2-3-----4 2-4-----4 how can i the get highest value of...

I have 3 fields in query. I want the highest value from field2 in field3. Shown as below: How I do this without using Group By? field1 field2 field3 1 1 2 1 2 2 2 1 3 2 2 3 2 3 3

Thanks Len Thanks Len I will explore the forum...I figured out that creating a database is not that simple, but if it works...It is a great tool..

update query Hi Len, can you explain me what normalisation is.. I am not so experienced in Access..and i made one mistake. I like to change the data in [tbl_indeling] and [tbl_speeldata] Not [tbl_speelschema] and then this gives an auto update. You can view my website at...

auto update table Dear Len, I try to create a soccer competition. I attached a test.zip containing the database.. one table contains division of 12 clubs [tbl_indeling] one table contains diagram [tbl_speelschema] i combine these tables in a query [qr_programma_nr] now i attach date when the...

I have two tables [A and B]. I combine these tables with a query. I create a new table [C] with data from the query with append...So far this works.. My problem: I change data in the first two tables [A and B].. How can I auto update the data in the new table [C] Please a solution!

append query I found out that you can do it with append query. Is there also to do this automatic?

I create a query from different tables. With an website based insert statement I put the data from this query to another table. Is it possible to fill the table without the insert statement. But automatic done by the database itself. So insert/update all the query data automatic into the table...

This works I did use some If statements and that works. They ignore the empty fields Dim varCount varCount = 5 If Request("MM_insert") <> "" Then for i= 0 to varCount uitslagen.addnew uitslagen("home")=Request("home" & i) uitslagen("away")=Request("away" & i) If Request("for" & i) <> "" Then...

ThanXs but still a problem I know that it works with Null. But now this. I create a database with soccer results. I have lets say 2 matches. I get the textfield information from another table and put this in another table with also two numeric fields home[textfield] - away[textfield]...

Empty numeric fields How can i then leave the fields empty.By an insert statement without getting an error

I have a numeric field with No value. I create a insert record statement with asp. The problem is when I leave the numeric field emtpy I get an error. How can i insert a Null value or emtpy string for numeric values

ThanXs ThanXs The Val command works. But I only get other errors. I will try to figure it out.

solution !!!! How can i solve this problem. I need to keep the text fields and NO numeric fields, because sometimes a text will be placed in it. Or do I need numeric fields to make formulas ThanXs