Dato format

There will always be a time as part of a date time field, even if you dont enter one.

You dont say HOW you are using the dates but try adding a time to your from and to dates

EG:

... txtDatumFrån.Value & " 00:00:00'" ...  txtDatumTill.Value & " 23:59:59'"

Prøv evt også med mm-dd-yyyy formatet.

Rickie are your other questions closed or do you still ned help with them?

Or yyyy-mm-dd format

Still needs help on the other SPM! :-)

"WHERE CUS.[No_] = CLI.[No_] AND CUS.[No_] = '17000828'  AND CLI.[Comment] LIKE '*Täckning*' AND CLI.[Date] = " & txtDatumFrån.Value & " & 00:00:00 &"

Det virker ikke!

Har også prövet between

Try creating a variable which contains the SQL. Then in the debug window (CTRL+G) write out the SQL using

?MyVariable

You can then copy th eSQLinto a query to make it easier to find the problem.

Also try executing the SQL WITHOUT any date criteria. If you dont get any records then theres your problem.

BETWEEN " & txtDatumFrån.Value & " 00:00:00 AND " & txtDatumTill.Value & " 00:00:00"

Giver dette resultat men virker ikke:
WHERE CUS.[No_] = CLI.[No_] AND CUS.[No_] = '17000828'  AND CLI.[Comment] LIKE '*Täckning*' AND CLI.[Date] BETWEEN 2005-03-15 00:00:00 AND 2006-01-01 00:00:00

Den siger run-time error 3075

BETWEEN #" & txtDatumFrån.Value & " 00:00:00# AND #" & txtDatumTill.Value & " 00:00:00#"

BETWEEN 2005-03-15 00:00:00 AND 2006-01-01 00:00:00

this should be

BETWEEN #2005-03-15 00:00:00# AND #2006-01-01 23:59:59#

Sejt! Dette virker :-)
Option Compare Database

Private Sub btnSelective_Click()
DoCmd.SetWarnings False
Dim sSQL As String


sSQL = "INSERT INTO tblAutogiro ([AGCustomerNo], [AGName1], [AGDate])" & vbCrLf & _
        "SELECT (CUS.[No_]), (CUS.[Name]), ([Date]) " & vbCrLf & _
        "FROM [dbo_vw_Thorn_Svenska_AB$Customer] AS CUS, [dbo_vw_Thorn_Svenska_AB$Comment_Line] AS CLI" & vbCrLf & _
        "WHERE CUS.[No_] = CLI.[No_] AND CUS.[No_] = '17000828'  AND CLI.[Comment] LIKE '*Täckning*' AND CLI.[Date] BETWEEN #" & txtDatumFrån.Value & " 00:00:00# AND #" & txtDatumTill.Value & " 23:59:59#"
        DoCmd.RunSQL sSQL
End Sub

Hvordan med points?

We'll leave the points for you to decide. Glad its working :o)

;-))

Mange tak :-) Har delt points!