Variable

[Syndicate_Admin]

Dear All,

i have the following code and i want to read the client number from the table hlp in the cell A1.

how do i have to define this?

Best Thomas

let
Quelle = Access.Database(File.Contents("C:\Users\t.severa\Desktop\Projektcontrolling\VIOI.accdb"), [CreateNavigationProperties=true]),
#"_Bewegungsdaten Neu" = Quelle{[Schema="",Item="Bewegungsdaten Neu"]}[Data],
#"Gefilterte Zeilen" = Table.SelectRows(#"_Bewegungsdaten Neu", each ([Mandant] = 222063))
in
#"Gefilterte Zeilen"

[lbendlin]

let
Quelle = Access.Database(File.Contents("C:\Users\t.severa\Desktop\Projektcontrolling\VIOI.accdb"), [CreateNavigationProperties=true]),
#"_Bewegungsdaten Neu" = Quelle{[Schema="",Item="Bewegungsdaten Neu"]}[Data],
#"Gefilterte Zeilen" = Table.SelectRows(#"_Bewegungsdaten Neu", each ([Mandant] = 222063))
in
#"Gefilterte Zeilen"[client number]{0}

Note that Access databases are not recommended as data sources.