Dlookup med to kriterier

Check dine referencer - åbn et modul / procedüre > funktioner > referencer og kontroller om nogle mangler.

Du afslutter ikke din kode med End If - men jeg antager, at det har du.

Nærmere noget i denne retning:
If Me.tid < DLookup(\"[tid]\";\"Naale\";\"([disciplinid] =[disciplinid] And [naaletypeid]=7)\")

  Dlookup med to kriterier  07/10 2001 22:09:50    15 point fra ncbr

Hvem kan hjælpe med at få dette udtryk til at virke
If Me.tid < DLookup(\"[tid]\", \"Naale\", \"disciplinid = \" & DisciplinID & \" AND naaletypeid = 7\" ) Then

Jeg har ikke forklaret mig godt nok.
naaltypeid kommer fra tabellen naaltype så den skal se ud som noget alla dette:

If Me.tid < DLookup(\"[tid]\", \"Naale\", \"disciplinid=\" & DisciplinID & Naaltype!naaletypeid= 7) Then

Sorry

You cant! I suggest you make a query joining the two tables. and then change the table name \"Naale\" to the query name and then
If Me.tid < DLookup(\"[tid]\", \"YourQuery\", \"disciplinid = \" & DisciplinID & \" AND naaletypeid = 7\" )

should work

Finde naaletypeid ikke i tabellen \"Naale\"?

Hvad er fællesnøgle i de 2 tabeller?

Good morning Thomas!
Yes I know you can! but I think it would be easier for ncbr to make a query himself :o)

Good morning to you too, Terry ;o)

You are right, and it would be a lot faster to do so, but if he fails to make the query, it would be easier to just give him the nested DLookup.

OK :o)

fællesnøglen hedder naaltypeid.
MEN jeg har efter at have sovet på det, fundet ud af at det jeg er i gang med kun vil fungere på eksisterende records i tabellen \"Naale\" !!!

Hvordan kan jeg gøre søgningen uafhængig af dette, sådan at når der indtastes en ny tid for en svømmer. Undersøger DB om tiden berettiger til en Naal og om denne allerede er udleveret?

Hvis dette gør at der jeg skal afsætte flere point lad mig det vide :)

ncbr

What decided when a naal can be given?

a naal can be given if the time used to swim the distance is below \"tid\" from the Naale table where the disciplin is the same, but there are at the current time 8 different naal to be given depending on the time reached

This is just an idea!
Make aquery on your table Naal and sort after disciplin and tid.

Then use the dFirst function to get the closest Naal for the time.

YourNaal=DFirst(\"naaltypeid\", \"naal\", \"Disciplin = \" & Me.DisciplinID  & \" AND Tid < \" & Me.Tid)

Or something like that.
Me.disciplin and Me.tid are fields on a form.

YourNaal should be a variant as I think Dfirst returns Null if nothing is found.

Then you can test if a naal was given

If Not IsNull(YourNaal) Then.....

Give me a pin...
else

else
swim faster ;o)

Terry again i forgot an detail, there are different requirements depending on the swimmers sex, how do i ad this

I assume that the sex is in the naal too.

Sort the query after Sex disciplin tid.

YourNaal=DFirst(\"naaltypeid\", \"naal\", \"SexID = \" & Me.sexID & \" AND Disciplin = \" & Me.DisciplinID  & \" AND Tid < \" & Me.Tid)

it\'s not, but if I make the query based on two tables, would that work ???

You can make the query on two tables if they are related

Obviously you have to replace \"naal\" in the dfirst to the query name

Ill try it out.

Thanks