Search results

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

i create a query and i get the next problem: home and away get values from a table and won is a formula in the query won: IIf([home]>[away];"1";"0") home away won 2 1 1 4 4 0 1 3 0 11 2 0 from 0 to 9 the formula works but if home is greater then 9...

ThanXs SJ Mc Abney Thanxs SJ Mc Abney it works now in access. I put in Criteria column1 "text1" and in OR column2 "text1" now i get column1 column2 text1 text3 text2 text1 Life is simple

This works Use use this in sql statement in dreamweaver and it works. but how get i this to work in access SELECT * FROM qr WHERE (column1='text1' OR column2='text1') AND seasonID = varSeason AND clubID = varClub

Query bases on two columns criteria I put an attachment with a access database. The query has to show only records containing text1. But now it doesn't show.

I made a query with several columns. I like to view only the records based on a query criteria of two columns. column1 column2 text1 text5 text3 text1 text4 text6 when i fill in criteria text1 for column 1 and column2 . Nothing showed up. How can I only show rows that contains...