I need to make a access table for price based FILA(see my last image immagine.jpg)
My idea ... a filed named FILA (are the row of beach umbrella) end a FILED prezzo, similar:
from FILA 1 to 10 PREZZO = 30
from FILA 11 to 20 PREZZO = 25
...
from FILA 41 to 50 PREZZO = 20
how to make this table?
Create table based FILA
-
- Administrator
- Posts: 78391
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Create table based FILA
Do you really need such a table? You could easily calculate the PREZZO from the FILA on the fly.
If you really want the table, I'd create the list in Excel, then create a table in Access with fields FILA and PREZZO, and copy/paste the list from Excel into the empty table. It'll take less time than writing code.
If you really want the table, I'd create the list in Excel, then create a table in Access with fields FILA and PREZZO, and copy/paste the list from Excel into the empty table. It'll take less time than writing code.
Best wishes,
Hans
Hans
-
- PlatinumLounger
- Posts: 4343
- Joined: 26 Apr 2010, 17:36
Re: Create table based FILA
AHHHH....HansV wrote: ↑03 Sep 2021, 14:13Do you really need such a table? You could easily calculate the PREZZO from the FILA on the fly.
If you really want the table, I'd create the list in Excel, then create a table in Access with fields FILA and PREZZO, and copy/paste the list from Excel into the empty table. It'll take less time than writing code.
ok