Greetings,
I have a question, Is it possible to insert a value and
refer to that value in the same query?
What I mean is suppose in a table there are two fields. I insert the
value into the first field and the second value has to be inserted
based on first field.
eg: If first field is inserted as 1 then the second field decides as
follows
CASE WHEN first_field=1 THEN 1 ELSE 2 END
I have tried this, but i think I was not able to frame it properly. Can
anyone tell me how to do this?
Re: Design View Criteria question ... The first query will use AND logic: it will return those records for which the ...first field is equal to 123 (regardless of the value in the second field),... (microsoft.public.access.queries)
Re: Group by (Selecting First) after Sorting ... You posted in the tablesdbdesign newsgroup.... If you want a query that sorts by the first field, ... ascending order on the second field, which gives, ... (microsoft.public.access.tablesdbdesign)
RE: IIf comparison ... How would I link this query to the report? ... > Qreate a query with the following equation ... >> where if the first field is greater in value than the second field,... But if the first field is less in value ... (microsoft.public.access.reports)
Re: dpkg -l postfix ... Every field of this tabular output has a caption.... The first field is set to "i", so according to the caption, the desired ... action that dpkg sees for this package is "Install".... The second field is set to "i", which means the current status is ... (Ubuntu)
Re: Question on how relationships work ...Bill, you say "the user does not even see the first field ... ... I have a value list for a drop down field, with OrgID as first value, and OrgName as second value, with only OrgName visible - so far so good. ... I gave you an answer in your other thread, suggesting that you use a drop-down list, with the Person ID number being the first field, and the calculated NameLastFirstSuffix as the second field and the only field visible to the user. ... (comp.databases.filemaker)
