loubnabouayad
New member
- Local time
- Today, 04:28
- Joined
- Apr 6, 2014
- Messages
- 2
Help me?
My Access Query is asking for a 'Parameter value', he has done this a few times already and I was able to repair my wrongs, but this time I just cannot find it.
Also out of the blue he filled a column in the Query, in the 'field'? Veld in Dutch.
This is what he filled in: Expr1: [Factuurregels]. Factuurregels is one of my tables, it is also a 'subreport'.
The goal of my database was for me to be able to make bills/notas. My clients, products etc still have to be filled in. The company I do this for is really small, no more than 10 clients and only 5 articles.
SQL says this, though I don't understand the SQL at all...
SELECT [Factuurregels] AS Expr1
FROM (Leerlingen INNER JOIN Factuur ON Leerlingen.[Id] = Factuur.[LeerlingenID]) INNER JOIN Factuurregels ON Factuur.Factuurnummer = Factuurregels.FactuurID;
Thank you very very very very very much!
My Access Query is asking for a 'Parameter value', he has done this a few times already and I was able to repair my wrongs, but this time I just cannot find it.
Also out of the blue he filled a column in the Query, in the 'field'? Veld in Dutch.
This is what he filled in: Expr1: [Factuurregels]. Factuurregels is one of my tables, it is also a 'subreport'.
The goal of my database was for me to be able to make bills/notas. My clients, products etc still have to be filled in. The company I do this for is really small, no more than 10 clients and only 5 articles.
SQL says this, though I don't understand the SQL at all...
SELECT [Factuurregels] AS Expr1
FROM (Leerlingen INNER JOIN Factuur ON Leerlingen.[Id] = Factuur.[LeerlingenID]) INNER JOIN Factuurregels ON Factuur.Factuurnummer = Factuurregels.FactuurID;
Thank you very very very very very much!