EXTRACT prezzo from table...

User avatar
sal21
PlatinumLounger
Posts: 4334
Joined: 26 Apr 2010, 17:36

EXTRACT prezzo from table...

Post by sal21 »

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...
You do not have the required permissions to view the files attached to this post.

User avatar
HansV
Administrator
Posts: 78237
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: EXTRACT prezzo from table...

Post by HansV »

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
Best wishes,
Hans

User avatar
sal21
PlatinumLounger
Posts: 4334
Joined: 26 Apr 2010, 17:36

Re: EXTRACT prezzo from table...

Post by sal21 »

HansV wrote:
08 Sep 2021, 08:50
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
:cheers: :clapping: