I have tried adding as much text as I can to the SQL pane in MS Query
and it went up to 29,996. I do not think that your query is that
complex (9 A4 pages!). I'm using Excel 2003 SP2. Have you tried it one
another machine. Maybe there's something wrong with the Office installation.
Jonathan
Bobby B wrote:
I am working in EXCEL 2003, to access external data through MS Query. I am
writing code in the SQL query edit pane,. My query and case statements are
large. The SQL query edit pane will not accept additional test. Is there a
limit to the number of characters / size for an SQL query in MS Query? If
so, can it be adjusted to accomodate additional text?
Re: DBMS and lisp, etc. ... Naively implemented with SQL, again for 10 ... (1 query for the initial orders, 1 query for each order for its ... soon as you upgrade to the SQL database.... (eq (order-customer orderA) ... (comp.lang.lisp)
Re: Populating a list -- table structure? ... I had made a report already and figured out about adding the ... your responce below, but thanks to your help with SQL, I was able to get the ... It takes a summary from a select query and gives the ...KitID, long integer ... (microsoft.public.access.forms)
Re: Populating a list -- table structure? ... I don't mean to skip your responce below, but thanks to your help with SQL, I was able to get the query to pull the info the way I needed. ... I have one report complete, ...Queries (just shows the QBE grid for convenience -- ... (microsoft.public.access.forms)
Re: Populating a list -- learning Access ... It is kinda funny -- I started using databases in the early 80's with dBase and, for years, never knew that I knew SQL!... If you are on a form or report, the most important property is the NAME, because that is how you refer to it in code. ... I don't mean to skip your responce below, but thanks to your help with SQL, I was able to get the query to pull the info the way I needed. ...Queries (just shows the QBE grid for convenience -- ... (microsoft.public.access.forms)
