RE: I can't open expression builder

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



Base the form not on the table but on a query based on the table. In the Job
Title column of the query put "purchasing" in the criteria row


--
Wayne
Manchester, England.



"JB" wrote:

I have yet another question. In the employees feild on the buy request form,
I only want people's whose job title is purchasing to show up. How could I
use a filter to hide the other employees?

"JB" wrote:

I think I figured that one out, now I have a new question. Can I use Dlookup
instead of cascading combo boxes? I have a table called employees and a form
called buy request. Buy request has a field for employee and for phone. I
want the phone field to automatically look up the correct number.

"JB" wrote:

whenever I click on the ... I open the query builder, which i don't know how
to use. is there a way to just open the expression builder?
.



Relevant Pages

  • Re: OT: SQL
    ... query processing. ... FROM Employees e, Employees m, Management mgt ... Manager and Employee Salaries. ... The scheme used does not model database files in general, ...
    (sci.logic)
  • Re: OT: SQL
    ... said was a totally failed attempt to formalize and automate database ... query processing. ... create table Employees ... Manager and Employee Salaries. ...
    (sci.logic)
  • Re: query a number stored as text
    ... Your query is quite complex, ... I need to join the Employees table to the Orders table like so ... ... "Lee" wrote in message ... >> GlobalSign digital certificate is a forgery and should be deleted without ...
    (microsoft.public.access.queries)
  • Re: OT: SQL
    ... said was a totally failed attempt to formalize and automate database ... query processing. ... create table Employees ... Manager and Employee Salaries. ...
    (sci.logic)
  • Re: Multi-Value Field Query
    ... It was directed at what Microsoft calls a Multi-Valued field, which is not the same as what you have ... This doesn't work very well in the query interface in Access, so you probably need to write a VBA function that does this for you. ... three areas 'CreatedBy', 'Owner', 'Employees'. ... appropriately and it lists all employees involved ...
    (microsoft.public.access.queries)