Re: Cant figure this out !

Ok, will try to simplify. the below code is in my query so that the form
opens with a status of either active or archived records.
The form also shows a list of employees and there status is either active or
archived.
I need to be able to show ALL records when the status is archived instead of
either active or archived as my choices.
The below code is in the query for the forms employees list and so shows
only active or archived records.
If the form is opened with a status of archived, then I need to see ALL
records.
I need to either change record source upon archive status or modify the
below code to check if the form's status is archived.



[Forms]![frmAutoPayrollReport]![Status] ' either active or archived is the
choice here


.

Relevant Pages

  • RE: Access database crashes trying to save query
    ... remove the Switch statement from up in the Select clause. ... You could simplify things by using an alias for your table like so. ... "chris" wrote: ... > When running the following query in Access 2002, I am able to see my results ...
    (microsoft.public.access.queries)
  • RE: Setting prompted value to a fariable in SQL
    ... Sorry for the confusion I tried to simplify the code and I didn't do a good ... It is a make table query that counts ... I was hoping to prompt the user for the ... simplified example of what I am trying to accomplish ...
    (microsoft.public.access.modulesdaovba)
  • Re: Type Conversion Failure in Update Query
    ... I put in the code and it still seems to give me "type conversion failure." ... I restricted the query to one field at a time to simplify things: ... Prev by Date: ...
    (microsoft.public.access.queries)
  • Re: Access wont commit (to SQL Server linked table)
    ... Unfortunately the query was running from VBA originally when the ... simplify things. ... Prev by Date: ...
    (comp.databases.ms-access)
  • Re: Need someone to look at SQL statement
    ... Simplify! ... I think you would have this error with just the middle SELECT query by ... in the WHERE clause you reference [PolicyNumber] without ... >could refer to more than one table used in the FROM clause of your SQL ...
    (microsoft.public.access.queries)