title: Access 2010 SQL - Change Parameter Name?
body: <p>This is my first post. I am a newbie to Access 2010 and SQL.</p>
  
  <p>I have a hotel booking database and the SQL code I am using to run my query for vacant rooms is as follows:</p>
  
  <pre><code>PARAMETERS [Start Date] DateTime, [End Date] DateTime;
  SELECT R.*, [Start Date] AS Expr1, [End Date] AS Expr2, *
  FROM ROOMS AS R LEFT JOIN (select B.RoomNo from Bookings B
  
  where ([Start Date] between B.ArrivDate and (B.ArrivDate + BKGNS.DURSTAY))
  
  AND ([End Date] between B.ArrivDate and (B.ArrivDate + B.DURSTAY))
  
  )  AS BKD ON R.RoomNo = BKD.RoomNo
  WHERE (((BKD.RoomNo) Is Null));
  </code></pre>
  
  <p>My question is this - where I have <code>BKGNS.DURSTAY</code>, can I rename the parameter box that comes up when the query is ran with something like "Please Enter the Duration" rather than "BKGNS.DURSTAY" which currently appears on the parameter box?</p>
  
  <p>Hopefully I have explained this correctly as I am a newbie to both Access and SQL.</p>