Felt betingelser

The only way you can do this is if you enter the data through a form

In the before update event on the form

If tal3>tal4 then tal1 = 3
Else
if tal3<tal4  Then tal1 = 0

else
tal1 = 1

endif
endif

But WHY have an extra field in the form? You can make a query which calculates tal1!

det har du vel selv skrevet:
(lavet i asp)


if tal3>tal4 then
tal1 = 3
end if
if tal3<tal4 then
tal1 = 0
end if
if tal3=tal4 then
tal1 = 1
end if

SQL = "insert into tabel(tal1,tal2,tal3,tal4) values(" & tal1 &"," & tal2 &"," & tal3 &"," & tal4 &")")

I dont see any mention of ASP in the question!

Jeg har arbejdet en del med excel og der kan man bare skrive en IF-sætning i feltet og det håbede jeg også man kunne i Access.

Jeg vil ikke bruge forms endnu. jeg bruger kollonerne tal1 og tal2 i forespørgsler.

terry>> nej det har du ret i... men et eller andet sprog skal man vel bruge til det... kan ikke se, hvordan man skal gøre i ren sql.

Er der ike en indbygget facilitet i access?

the example I gave is in VBA (in Access)

If you are using ASP as the user interface then you can use VBScript or something and then do it directly in SQL as kvadratrodenaf1 shows. You will also very likley need an update too!

But lets find out where you are entering the data first?

Kan man lave en join i Access?

yes, but we only have ONE table, but then ther is NOTHING stopping you JOINing the one table to itself!

But where are we going with this?

burkal>If you have worked with Excel then you should have NO problem with Access VBA. BUT you MUST enter the data through a form so that you have access to VBA. Otherwise where are we going to write IF.....

Do you have a dB?
If you send it to eksperten@santhell.dk I will makew an example using an Access form (NOT asp)!

original question:
I have the mentioned table, which is a table which should record soccermatch results. Column tal1 and tal2 are points earned by home- and awayteam. Tal3 and tal4 is goals for Home- and awayteam.

I want to keep the DB as simple as possible as I am new to MS Access. This DB is also meant as a learning expirience. So no forms, reports or presentationlayers if at all possible.

My question regarding Joins is because I have two queries, which makes a table with Home- and awayteam standings and it is natural to use a join to unite the two tables.
Is there a SQL-window where you can type in SQLcommands? or can you read in a txtfile with sql in access?

In Access you should see a button (icon) named Queries on the database window. Press this button an dthen at the top of the database window press New.
Now you get a dialog where you can choose from differmet types of queries, select Design View (the top one).

Now you can choose which tables you want to use, and if you press close without chooseing any tables you can then enter the SQL directly. Right click on the title bar of the query window and choose SQL view from the menu. Or choose SQL from th emain menu.

I understand danish perfectly

Jubii sqlvindue.

jeg vil godt se en form på min DB, så hvis du har tid vil jeg gerne sende min DB til dig.

Er det ok?

In Access you can NOT enter a new record and set the value of a third field from the values you enter form the first two fiels! You will need to run an update query AFTER you enter a new record.

In your table you only need to record the goals scored, then in an SQL statement you can calculate the values of the other fields

send away

burkal>If you rnew to Access I suggest you get hold of a book, and there is also a link you may get help from here.

http://www.hedeskov.dk/

Den er sendt

har fået den

just in case you cant find Access
http://www.hedeskov.dk/netpublikationer/udv-database/indhold.htm

I sent the dB but I got an error so I have now tried with another account

jeg har kigget på den. Jeg har købt et par hæfter. har du sendt noget tilbage?

Hvor stor (KB) er DB?

The error is
Unknown user: bjarne_burkal@hotmail.com

one of my mail accounts seems to be having a problem with certain addresses!

Oops, sorry, shouldnt have pasted that here!

I'm off for 15 minutes!

have you received anything?

yes, jeg har modtaget det. Det ser jo meget nemt ud. ;o) Jeg tror jeg skal ha lavet db så simpel som muligt inden jeg begynder med forms. Men tak fordi du viste mig det. Jeg tror jeg stopper for idag. Så du skal have mange tak.

selv tak

Nat :o)