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/
