General Query

Hann · Dec 18, 2002

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 · Dec 18, 2002

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 · Dec 18, 2002

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.

Code:

    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 · Dec 18, 2002

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.

General Query

Hann

Guest

pdx_man

Just trying to help

Newman

Québécois

pdx_man

Just trying to help

Similar threads

Users who are viewing this thread