Search results

  1. P

    IIF Problems - Multiple Expressions

    Could someone please point out to me what's wrong with this query? I get a syntax error when I try to run it. If I take out the "OR '0058'" part, the query will evalute properly. However once I try to add in the OR statement it stops working. I have also tried "OR LIKE '0058'" and recieved...
  2. P

    Query: Comparing Two Tables

    I'm trying to write a report which initially I didnt think would be hard to do, but when it came time to write the underlying query I realized it was a bit above me. I cant give away too much of the database structure here, due to legal issues, so sorry for being vauge. Hopefully I can give...
  3. P

    Dynamic Fields in a Query

    My boss asked me to do something today that stumped me. He wanted me to make a query, where when you're selecting the parameters you could chose whether or not you wanted certain fields to be visible. On top of that I need to be able to chose whether I want it to be shown on screen in a query...
  4. P

    Combobox Within a Query

    I'm not entirely sure if this is possible, however I'm pretty sure I have seen it done in the past. But I've been racking my brains and scouring google for the solution with no luck what-so-ever. What I'm trying to do is display a query, where one of the fields will have a drop down box that...
Top Bottom