Re: Insert a LIST into each line of 2nd file - WILL PAY $$$!

ok. Thanks. NOW... there is no setting that I can find that show the
size of the "temp" directory. I see environment variables but only
location, no further data to change.

Anyhow... In the make table query and export there is another field in
the query edit window called "criteria".
Being that one file has one field which is a 4 digit number (0000-9999)
I would like to tell the query to only use... say... 0000 through 4999
and one of the fields in the 2nd database (table) is a 3 digit number
from 200 to 999 and I would like to say that I only want to process
rcords that match say 200 through 500.

I did this manually by making seperate tables for each of the 1000's
blocks of the first database however this will take an eternity to run
such small queries all to avoid the "not enough disc space" error when
I know I have more than sufficient disc space. I also tried it on
another computer system with 1gb ram and 200gb drive with over 10gb
free... same result but much faster at querying almost to the end
before erroring out.

TO make things a little more interesting/difficult - ONLY IF YOU WANT
TO REALLY HELP! - I also have another field in the 2nd table which
contains either NOTHING in it or a 1 digit number from 0 through 9...
if possible I would also like to stipulate that if for instance it says
"8" then I only want to append the 1000 records from the first table
that range in the 8000's (8000 through 8999) to that record which has
the "8" in it from the 2nd table.

I can avoid this part by simply removing records after the fact but
that would simply not make sense IF the query can skip them in the
first place.


Thanks again!
I can be contacted about this anytime by email send to "bigcranes AT
gmail DOT com" or reply here.

ALL HELP IS APPRECIATED TREMENDOUSLY!

.

Relevant Pages

  • Re: Editing Access Data
    ... > second query to an update query, and update both your phone field and your ... > last name, etc.), so why not combine that exercise with the "moving phone ... >> actual name is sometimes, also appended with a ten digit phone ...
    (microsoft.public.access.queries)
  • Re: Need Help with Criteria Expression
    ... query that will do this and save this query. ... setting a validation rule that's commensurate with the way data would ...  If I actually enter a space, that is the same as entering a digit so it ... This input mask will allow for 1 digit months, 2 digit days, and 2 digit ...
    (microsoft.public.access.queries)
  • Re: Editing Access Data
    ... second query to an update query, and update both your phone field and your ... last name, etc.), so why not combine that exercise with the "moving phone ... > actual name is sometimes, also appended with a ten digit phone ...
    (microsoft.public.access.queries)
  • Re: Query for Left(String,5) - Access 2007
    ... Note that this query cannot use the query design view, but must be done in the SQL view. ... FROM ((boston INNER JOIN Name ON boston.Boston = Name.ZIP) INNER JOIN ... The only time I've used like is in the criteral when I'n only using the nameaddress table and then I'd type in all the likes manually - though usually there are only 4 or 5 zips. ... It will then find all matching 5 digits and all that start with the 5 digit code. ...
    (microsoft.public.access.queries)
  • RE: Subform comparison of 2 tables excluding non zero value
    ... thank you for the advice! ... Then it was suggested to me that I use a crosstab query. ... I looked into this and thought it would display my data beautifully on my ... avoid the requirement of a crosstab query to 'calculate' something. ...
    (microsoft.public.access.forms)