i just have a var F=1 (find in FILA filed) and a var date GIORNO=15/08/2021 (find it between DAL and AL), i need to select PREZZO from this two param...
in my case PREZZO is 30,00
peraphs i'm stupid...
EXTRACT prezzo from table...
-
- PlatinumLounger
- Posts: 4334
- Joined: 26 Apr 2010, 17:36
EXTRACT prezzo from table...
You do not have the required permissions to view the files attached to this post.
-
- Administrator
- Posts: 78237
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: EXTRACT prezzo from table...
Open a recordset RS with SQL
SQL = "SELECT PREZZO FROM MYTABLE WHERE FILA=" & F & " AND #" & FORMAT(GIORNO, "mm/dd/yyyy") & "# BETWEEN DAL AND AL"
and then get RS!PREZZO
SQL = "SELECT PREZZO FROM MYTABLE WHERE FILA=" & F & " AND #" & FORMAT(GIORNO, "mm/dd/yyyy") & "# BETWEEN DAL AND AL"
and then get RS!PREZZO
Best wishes,
Hans
Hans
-
- PlatinumLounger
- Posts: 4334
- Joined: 26 Apr 2010, 17:36