Re: Parameter Query and Calculated Date Field

Tech-Archive recommends: Fix windows errors by optimizing your registry

Here is the SQL for the Query.. I place a dates in the Enter Start Date and
Enter End Date e.g., 9/1/2008 Short Format

SELECT tblCLIENT.SurveyID, tblCLIENT.FNAME, tblCLIENT.LNAME, tblREFERRAL.
SEQ_ID1, tblREFERRAL.REFERRAL_DT, tblREFERRAL.OUTREACH_completed, CVDate(
[OUTREACH_completed]+180) AS CalcDt
FROM tblCLIENT INNER JOIN tblREFERRAL ON tblCLIENT.SurveyID = tblREFERRAL.
SurveyID
GROUP BY tblCLIENT.SurveyID, tblCLIENT.FNAME, tblCLIENT.LNAME, tblREFERRAL.
SEQ_ID1, tblREFERRAL.REFERRAL_DT, tblREFERRAL.OUTREACH_completed, CVDate(
[OUTREACH_completed]+180);


Douglas J. Steele wrote:
Can you show the SQL of your query, as well as indicate what you're
providing for [Enter Start Date] and [Enter End Date]?

Hello,

[quoted text clipped - 10 lines]

Thanks

--
Message posted via http://www.accessmonster.com

.

Relevant Pages

  • RE: Excel & MS Query caused compile errors
    ... My data is in an Excel file called ... The format of it were distorted after copying and pasting. ... Microsoft SQL Server 2000, which requires a server, VBA or Microsoft Query ...
    (microsoft.public.excel.programming)
  • Re: mySQL Problem
    ... And when the query gets executed i get back the following error: ... Actually, problem is proper quoting, not the format or anything else. ... the SQL standard and won't work on any other RDBMS I'm familiar with. ... you admit that mssql uses something DIFFERENT and PARTICULAR to alias? ...
    (comp.lang.php)
  • Re: VBA ADO SQL Query Problem
    ... For long queries on a Oracle DB, I often meke it easy by using Business ... Object where I copy the SQL statement from. ... query parameter in the Oracle date format. ... But the query DID work, only no records were retrieved ...
    (microsoft.public.excel.programming)
  • Re: Format issue ... 2 decimal places displayed?
    ... Jeanette Cunningham wrote: ... to get sql of your query, open the query in design view, then select Query | SQL view from the menu. ... you applied the format to the combo box. ...
    (microsoft.public.access.forms)
  • Re: Noob question - Data Type Mismatch
    ... I am fairly new to SQL and am running into a problem I can't figure ... this is the right place for the query so if not then let me know ... I get a "Data Type Mismatch in criteria expression" error. ... Your non-US format would work with the specific date value you specified because ...
    (microsoft.public.access.queries)