Thank you Troy I knew it could be done, but I forgot it the two brackets did the trick. On the second question I had, I have it solved; however there is always a better way or procedure for anything, so I will explain this in short: I have an input form for replacements of Appliances and repairs upon entering Make, Model and Serial numbers it will show the current tenant and his Move In date which would be compared to the purchase date to determent if they would be responsible as to repairs etc. Regards, Herb -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Troy Sosamon Sent: June 7, 2002 11:53 AM To: [EMAIL PROTECTED] Subject: RE: Error column xxxx not found (2369)
I am assuming these are expressions in a report. If you want to get the first and last names into one var, you could do this fullname = (fstname & lstname) from sometable where somecondition Try this: VDate = MoveInDte FROM Tenants where Unit = Unit and MoveInDte = MoveInDte Looking at this, I am wondering why you want to lookup a date from another table and you are using that data in the where clause???? Troy ===== Original Message from [EMAIL PROTECTED] at 6/06/02 5:05 pm >Could some one tell me what the error number means, I try to build a >variable as follows: >VDate = MoveInDte in Tenants where Unit = Unit and MoveInDte = MoveInDte >The Comn is present in the database, is also used by other tables. > >Than besides that I have an other problem I like to show the Fstname and >LstName (they are separate columns) in an other Table in the same field >which is in the same Database with a variable. It works fine if I either >Use the LstName or the FstName but I don't seem to be able to combine >them. Have tried the ampersand, the comma and the semicolon. > >Thanks for any help >Ps. I know these are minute problems to all of you from what I can see >on the List, but consider where it comes from ! > >================================================ >TO SEE MESSAGE POSTING GUIDELINES: >Send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: INTRO rbase-l >================================================ >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] >In the message body, put just two words: UNSUBSCRIBE rbase-l >================================================ >TO SEARCH ARCHIVES: >http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/ ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEARCH ARCHIVES: http://www.mail-archive.com/rbase-l%40sonetmail.com/
