Re: find value from a query

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance


It seems like you did not post the latest SQL as it does not Join the
translation table to your cboClassification field ----

Edit it like this --
SELECT IIF(DMax("cboCommentClass", "qryParametersLast")=1,"SECRET NOFORN")
AS [Max Classification], tblComments.DOTLMPF_ChoiceFK,
tblComments.solution,........

Use [Max Classification] in the header.
--
KARL DEWEY
Build a little - Test a little


"maceslin@xxxxxxxxx" wrote:

On Mar 11, 12:19 pm, KARL DEWEY <KARLDE...@xxxxxxxxxxxxxxxxxxxxxxxxx>
wrote:
Post your complete SQL statement.
--
KARL DEWEY
Build a little - Test a little



"maces...@xxxxxxxxx" wrote:
On Mar 10, 6:03 pm, maces...@xxxxxxxxx wrote:
On Mar 10, 9:44 am, Duane Hookom <duanehookom@xxxxxxxxxxxxxxxxxx>
wrote:

I thought I read a similar question recently where it was suggested you have
a table that describes the order of the classifications. Do you have one?
--
Duane Hookom
Microsoft Access MVP

"maces...@xxxxxxxxx" wrote:
I have a dynamic qryParametersLast in which I have a field
cboClassification that I must now search through to determine a value
to place in the report header. In descending order the values for
cboClassification are secret, confidential, FOUO and unclass. If
secret is there then the header is secret, if no secret but
confidential then the header is confidential, etc...

I have absolutley no idea as to how to go about doing this. Can
someone point me down the right path?

Thanks
Dave- Hide quoted text -

- Show quoted text -

I had a post similar but it was a different table. I could order
tblClassification in any order needed in same method (adding another
column to table).

I do all my developmental work on an unclassifiefd network so I can
work issue at hom ein spare time (really the only time I ahve as this
is a collateral duty) and then transfer it tot he correct network when
completed. Not sure I understand KArl suggestion- what goes in
"code" spot?- Hide quoted text -

- Show quoted text -

I have tried the following and am getting a parameter box with the
same message in it. If I put an "=" in front of the expression I get
an error "missing operand"

IIF(DMax(cboCommentClass, qryParametersLast)=1,"SECRET NOFORN")

Any idea what is wrong?- Hide quoted text -

- Show quoted text -

Here is the complete query string. It is a dynamic query so the
"Where" claus can be very complex

SELECT tblComments.DOTLMPF_ChoiceFK, tblComments.solution,
tblSolutionLocation.Solution_Location, tblBasicData.[Lesson IDPK],
tblPersonnel.[Last Name], tblCore.CoreCapability,
tblNumbered.Numbered_Fleet, tblDOTMLPF.DOTMLPF_Choices,
tblStatusChoices.Status, tblComments.Date_Entered,
tblBasicData.HyperlinkToLesson, tblComments.Review_Date,
tblBasicData.DateObserved, tblBasicData.Title,
tblComments.ClassificationFK
FROM tblStatusChoices INNER JOIN (tblPersonnel INNER JOIN (tblNumbered
INNER JOIN (tblDOTMLPF INNER JOIN (tblCore INNER JOIN (tblBasicData
INNER JOIN (tblSolutionLocation RIGHT JOIN tblComments ON
tblSolutionLocation.SollocfieldsPK=tblComments.Solution_LocationFK) ON
tblBasicData.[Lesson IDPK]=tblComments.Lesson_IDFK) ON tblCore.[Core
Capability IDPK]=tblBasicData.CoreCapabilityFK) ON tblDOTMLPF.[DOTMLPF
ID PK]=tblComments.DOTLMPF_ChoiceFK) ON
tblNumbered.NumberFleetPK=tblBasicData.NumberedFleetFK) ON
tblPersonnel.personnelPK=tblComments.Responsible_IndividualFK) ON
tblStatusChoices.StatusChoiceIDPK=tblComments.statusFK
WHERE DOTMLPF_Choices="Doctrine";



Thanks for looking

Dave

.

Relevant Pages

  • Re: find value from a query
    ... Use [Max Classification] in the header. ... cboClassification are secret, confidential, FOUO and unclass. ... FROM tblStatusChoices INNER JOIN (tblPersonnel INNER JOIN (tblNumbered ...
    (microsoft.public.access.reports)
  • Re: find value from a query
    ... KARL DEWEY ... to place in the report header. ... cboClassification are secret, confidential, FOUO and unclass. ... FROM tblStatusChoices INNER JOIN (tblPersonnel INNER JOIN (tblNumbered ...
    (microsoft.public.access.reports)
  • Re: Inner join on table with NULLs
    ... I want to perform an inner join between two tables. ... The first has some data columns and two classification ... table to determine the period and sequence nr. ... startup Private g_bIsCurrent As Boolean ' These get initialized ...
    (microsoft.public.access.queries)
  • Re: Report/Query Filtering
    ... numbers that the only difference is the classification. ... FROM Categories AS Categories_1 INNER JOIN (Products AS Products_1 INNER JOIN ... CategoryID) INNER JOIN ((Customers INNER JOIN Orders ON Customers.CustomerID ... Then a query of the table becomes a bit easier. ...
    (microsoft.public.access.reports)
  • Re: Report Queries
    ... In report design, you can now see a section headed by a grey bar named: ... Would it be feasible to use the AttendeeID in the group header? ... FROM ((TPhysicians INNER JOIN Attendees ON TPhysicians.TPhysicians = ...
    (microsoft.public.access.queries)