Access forespørgsel 2

"select * from aktivitetshændelse where akth_dato >= #" & startDate & "#"

and you may need to format startDate

"select * from aktivitetshændelse where akth_dato >= #" & format(startDate,"yyyy-mm-dd") & "#"

Det er vist ikke det rigtige svar, den brokker sig stadigvæk.

what problem do you get now?

perFelt = perTabel("per_name")

akthSQL = "select * from aktivitetshændelse where per_name = " & perFelt
' Gives error "Too few parameters. Expected 2"

akthSQL = "select * from aktivitetshændelse where per_name = '" & perFelt & "'"
' Gives error "Too few parameters. Expected 1"

akthSQL = "select * from aktivitetshændelse where per_name = #" & perFelt & "#"
' Gives error "Syntax error in date in query expression 'per_name = #Dennis#'."

I thought that startDate was a date field, But in the last example you use another name! (perFelt)!

If the field is text then you must enclose the value in '' if it is a date then use ## if it is a number tehn use nothing


what is perFelt? Is it a field on a form?

akthSQL = "select * from aktivitetshændelse where akth_dato >= #" & Format(startDate, "yyyy-mm-dd") & "#"
' Gives error "Too few parameters. Expected 1"

So you dont read Danish, I try with "

Yes I read danish but I cant see your database, so I cant see exactly what the problem is.
If you can send me your dB then it may help

eksperten@NOSPAMsanthell.dk
remove NOSPAM

akthSQL = "SELECT * FROM aktivitetshændelse WHERE [per_navn] = '" + perTabel("per_name") _
+ "' AND [akt_navn] = '" + aktTabel("akt_name") + "' AND [akth_dato] >= """ + startDate + """"
' Gives error "Too few parameters. Expected 1"

[akth_dato] is a date field in the table, startDate is a string that has its value from Me!Calendar3.value

I will return later

I found the solution, the following works.

AND (((aktivitetshændelse.akkth_dato)>=#" & startDate & "# And (aktivitetshændelse.akkth_dato)<=#" & endDate & "#));"

but thanks for your time :o).

I found this solution by using the query-builder.

selv tak og godt nytår