Search results

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

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!

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...

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

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...

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...

I have a question. I have a query contains two columns one home one away. evertime i insert a goal in the table it gives 1 or 0 home away 1 0 0 1 1 0 now i need this home away 1 0 1 1 2 1 every next record looks to previous record and count it does someone...

how can i create a row in a query that acts the same as autonumber. I have a column named goals that only contains the number 1. For example the query contains 3 rows. What I want is that another column counts from 1 to 3. autonumber goals count 1 1 1 2 1...

I am creating a soccer fixture/competition for our local soccer club. so far it works. This competition is based on one competition with 12 clubs. The competition is based on a table with 22 competition rounds. Every round contains 6 matches. So i have a table containing 132 records. I want to...