is possible to use a between clausole...

[sal21]

I dont know if is possible, in other case...

I use this sql:

Code: Select all

SQL = "SELECT IMP_OPERAZIONE, NR_ASS, ASS, CONT, NR_CIRC, CIRC, COMMISS, ACC_CC, ADD_CC, NR_CDI, CDI, RESTO, COD, OPERAZIONE, MATR, SPORT, PRESENTATORE, NDG, RUOLO, ORDINE, DATA_OPERAZIONE, ORA_OP FROM tab_SI WHERE DATA_OPERAZIONE BETWEEN #" & Format(Me.DATE4.Text, "MM/DD/YYYY") & "# AND #" [b]& Format(Me.DATE5.Text, "MM/DD/YYYY") & "#[/b] AND SPORT='" & Me.SPORT3.Text & "' AND COD='" & RIGA & "' ORDER BY IMP_OPERAZIONE"

I need to set the second BETWEEN on a diffrent mdb on c:\mydir\database1

note:
I just have a jet4.0 conn opened named CONN thath point in the first BETWEEN condition
The structure (field name, table name, ecc...) of the 2 databases are exactllly the same.

[HansV]

I don't understand what you mean by "set the second BETWEEN on a diff(e)rent mdb".

[sal21]

I don't understand what you mean by "set the second BETWEEN on a diff(e)rent mdb".

follow me...

...WHERE DATA_OPERAZIONE BETWEEN #" & Format(Me.DATE4.Text, "MM/DD/YYYY") & "# AND #" & Format(Me.DATE5.Text, "MM/DD/YYYY") & "#...

DATA_OPERAZIONE are present on tab_SI where point the actual CONN and on tab_SI on c:\mydir\database1

in this case the first condition Between point on CONN (DATA_OPERAZIONE BETWEEN #" & Format(Me.DATE4.Text, "MM/DD/YYYY") &) the second element of between point on tab_SI field DATA_OPERAZIONE on c:\mydir\database1 & Format(Me.DATE5.Text, "MM/DD/YYYY") & "#...

[HansV]

Sorry, that doesn't make sense to me.

[sal21]

Sorry, that doesn't make sense to me.

OK... changed my method of selection.
tks.