Recent content by Loser

  1. L

    Crosstab Query Parameter problems

    Ok, no problem - thanks! Select query: PARAMETERS [Forms]![Date range]![Start Date] DateTime, [Forms]![Date range]![End Date] DateTime; SELECT [Query_key data per endoscopist].nc_user.name, nc_code_incompleteexam.name, Count(nc_code_incompleteexam.id) AS CountOfid, nc_coloscopy.invitationNo...
  2. L

    Crosstab Query Parameter problems

    Sorry, that was a typo - the error message actually has an additional square bracket at the beginning of it... "invalid bracketing of name '[[Forms]![Date ramge][Start Date] ]'" When I checked the SQL and the design view there is not square brackets round the whole statement, just the error...
  3. L

    Crosstab Query Parameter problems

    Hi all, I'm a newbie to Access and really only use the design views to create everything I need, rather than VBA or SQL, so I apologise in advance if this is a stupid question, posted in the wrong forum or I struggle to understand any advice. I've created a select query with date parameters...
Top Bottom