Query asks for Parameter values (1 Viewer)

loubnabouayad

New member
Local time
Today, 05:57
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!
 

Simon_MT

Registered User.
Local time
Today, 12:57
Joined
Feb 26, 2007
Messages
2,177
Select * From TableName

Or Selected (specified) Fields then the joins.

Try Creating a Query and look at the SQL format and then copy the SQL Statement.

Simon
 

Users who are viewing this thread

Top Bottom