General Query

[Hann]

My DB shall eventually be able to display single informations regarding Mobile telephones selected by models, colours or mobile description.
Ive got a table containing all this information, yet on the queries I would proceed in writing a query for each thinkable combination of models, colours, descriptions and maybe even qty-limitations.

Is there a possibility to write a general query from which the forms or reports can finally take all this distinct info?

 

[pdx_man]

You can have a form where the user inputs that items they are looking for, then have the criteria in the query point to the form. Create a report based on this query. Check out:

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=16360

 

[Newman]

I used a different method and wonder if it is as good as yours:
I created the form and on closing, it opens the report with the criteria build in the form.

    Dim NomDuRapport As String
    Dim Critere As String
    
    NomDuRapport= "EInterrupteurTelecom"
    If IsNull(txtDateDebut) And IsNull(txtDateFin) And IsNull(txtQuelleAnnee) Then
        Critere = ""
    Else
        If txtDateDebut.Enabled = True Then
            Critere = "[DateCiblee] >= #" & Me!txtDateDebut & "# and [DateCiblee] <= #" & Me!txtDateFin & "#"
        Else
            Critere = "Year([DateCiblee]) = " & Me!txtQuelleAnnee
        End If
    End If
    DoCmd.OpenReport NomDuRapport, acPreview, , Critere

 

[pdx_man]

That should work, too. An advantage of the way I mentioned, though, is you can reference the form from the report to be able to display the criteria values, or anything else you may want to dynamically add to the report.