|
|
|
Re: Writing a query (probably using SQL) |
|---|
| message from Rebecca on 5 May 2004 |
tina-
First off I want to thank you for taking so much time and explaining
everything to me!!! and then to write the query and check to see if it
works.. wow!! way beyond what I expected..
I had to use the full version you initially wrote because I do have a
"mailcode" in both the member file and masterfirminfo. It seems to work
great! Now I have to write the rest of it, adding in the rest of the
address (city state zip) which I think I can figure out with all the
information you gave me.
I am having a new problem, I am going to post it as a separate question on
the newsgroup but thought I would mention it here since you have been so
helpful.. My database is closing on me.. and not saving the changes I make
to my query. For example, I go to the query, make the changes you gave me,
hit the ! to run the query, get the results I wanted, click the X to close
the query, and it closes my whole database!!!! So when I open the database
again, I go to the same query and the changes were not saved. I do it
again, but instead of hitting the X to close, I hit the little disk in the
toolbar to save, and it closes the database. I open again.. and it was not
saved.. any ideas what could have happend to my database? I did a back up
and then compacted it twice. re-opened the database and opened a few
different querys and forms and closed them with the X.. no problem. But when
I go and make the change to the query and hit the X,,,, database
closes....????
Again! THANKS SO MUCH for all the help you provided with my last question.
Like I said.. it is working.. but I can't get it to save.. :).. computers!..
(or me...) which ever.. something isn't working right.
Rebecca S.
"tina" <nospam@address.com> wrote in message
news:3R1mc.20883$Ut1.622464@bgtnsc05-news.ops.worldnet.att.net...
[masterFIRMinfo]![FirmAddress1]
file]![Home_address1])
File]![Home_Address1],[Member
|
| tina replied to Rebecca on 05 May 2004 |
glad it worked (running, that is), glad to help. btw, just as a side note, i
believe you could *not* include any table references *except* when you refer
to the mailcode field which is in both tables. also, i'd love to take the
credit, but...i didn't duplicate your table setup and test the nested IIf()
function i gave you. i only wrote two three-field tables in order to write a
query with a simple IIf() function, for the testing i mentioned in my last
post. so i'm not quite as wonderful as you think. <g>
re the "closing db, closing not saving query" problem. good idea to post a
new thread. suggest you first try writing in the nested IIf() function and
then saving the query *before you run it*. it's possible the function is too
complex and is causing problems, though that would usually cause some kind
of error *while it's running* not after. it's also possible that the query
object is corrupted, even the db object may be corrupted. next suggest you
try deleting the query and rewriting it. <cringe> or to be safe, open a new
blank db, import everything *except* that query, and write a new one -
that's probably what i'd do if the first suggestion didn'n work. but a new
thread will put much better minds (probably with better solutions) to work
on the problem.
good luck! :)
"Rebecca" <rebeccas@tadc.org> wrote in message
news:euS0m4qMEHA.4016@TK2MSFTNGP10.phx.gbl...
|
|
