Re: SQL Syntax Error

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

John,

Thank you so much for your help. All three are Text Boxes. Start/End
date are by year only. Unfortunately, I tried your code and with a
few adjustments it works but will not save properly. I will save it
in SQL mode as the code you gave me but will not work properly. To
get back into SQL mode I have to open the Query in Design view. Once I
get back into SQL view the only thing written in the Query is
"SELECT;" Somehow Access decides to delete it. (I believe you
mentioned it not saving correctly for whatever reason.) If this is
happening is there any way to prevent it? This error occured even
before I opened the Query back up in SQL. If searching within a Query
is now not an option do you know of how to apply a print macro to a
search form without using one?
Thanks,
M

.

Relevant Pages

  • Re: Editing disabled by alternative to INNER JOIN
    ... if the query is opened in view ... and then opens in SQL mode. ... saving from SQL mode does not prevent the query ...
    (comp.databases.ms-access)
  • Re: Editing disabled by alternative to INNER JOIN
    ... Clicking design mode, if the query is opened in view ... and then opens in SQL mode. ... saving from SQL mode does not prevent the query ...
    (comp.databases.ms-access)
  • RE: Append/update Query with two sources
    ... Here's the SQL for what your trying to do. ... and then open a new query, switch to SQL mode, and paste it in, then switch ... This query uses the Zip from a table ...
    (microsoft.public.access.queries)
  • Re: HR Manpower Summary Report HELP!
    ... Now open the query 022806 Query in SQL mode and copy and paste the entire SQL ... (If there are subqueries, ... This is the name of the query that I am basing my report from. ...
    (microsoft.public.access.reports)
  • Re: Using only one record
    ... A fairly simple way to do this might be to create a search form in Continuous Form view. ... The button runs an OpenReport, filtering the report to the primary key of the current record. ... I have a query set ... it is very cumbersome in selecting the one record to use for the ...
    (microsoft.public.access.forms)