Search results

  1. C

    Query Parameters

    Also, I'm trying to do a parameter on 'Contract End Date' - where it will bring back all people with a contract end date of < the parameter - however I want the user to be able to define at this stage whether or not to bring back people with a blank contract end date. To do this I have added a...
  2. C

    Query Parameters

    Yeah it does - I was just looking to integrate it into the report For example, say we use the report to bring up a list of all players between 18 and 22 whos contract is expiring this Summer. That will bring up a list of players, but it'd be nice to easily know which one's have already been...
  3. C

    Query Parameters

    Thanks. It's weird, In the query I'm using DateDiff("yyyy",[Player Details]![Date of Birth],Now()) which is successfully bringing back and Age value. However if you go into the main Player Details form (Player Details1), using the exact same expression I get a '#Name?' error in the Age field...
  4. C

    Query Parameters

    Might have kind of solved this but not sure in best way. For the 'Position' field where it will either be an exact match to the position selected or be null (in which case it should bring back all positions), I've done: Like Nz([Forms]![Player List Query]![Position],"*") For the 'Height' field...
  5. C

    Query Parameters

    Cheers :-)
  6. C

    Query Parameters

    How can that happen? When I open the DB here (the same one I uploaded) I see the queries:
  7. C

    Query Parameters

    It's ok - I've taken some data out so here is bones of db - repaired and compacted. Basically there on the menu there is a button called ' Player Details - by Parameters'. This called a query called 'Player Details Query' which in turn calls a report 'Players by Position' It's the parameters...
  8. C

    Query Parameters

    Sure, is there a way I can send it to you directly rather than on the board?
  9. C

    Query Parameters

    Hi Just wondering if anyone had any ideas? Thanks Martin
  10. C

    Query Parameters

    SELECT [Player Details].[First Name], [Player Details].[Last Name], DateDiff("yyyy",[Player Details]![Date of Birth],Now()) AS Expr1, [Player Details].Nationality, [Player Details].EU_Passport, [Player Details].Height, [Player Details].[Preferred Position], [Player Details].[Other Position]...
  11. C

    Query Parameters

    Hi Help please for a newbie. I'm trying to create a query which will have multiple parameters which may or may not be input. If not input it should bring back everything for that parameter but still take into account other parameters. The following is my issue just now, I have 3 parameters...
Top Bottom