Recent content by rgeoffb

I have a form that asks 2 questions. Date and Account. I need to check a table to see if the combination of both date and account have not been used. Date is normally today, can be yesterday. Account has a drop down menu with 6 choices. If both the date and account have been used then there...

Here is a problem that I don't have the faintest idea on how to solve. I have 2 classes of members, active and inactive. Some of these members have spouses. On occassion I have to mail to one or the other or all with or with out their spouse. How do I make a Form or Reprot that I can select...

Worked like a champ! Thanks

Concanting Names on Mail Labels Would like to join names on a mailing label: ie: =Trim([Firstname] & " & " & [Spouse] & [Lastname]) Problem is not everyone has a spouse. How do I get Access to ignore the " & " and [Spouse]? Thanks

Trying to do address labels. Used the wizard to create, no problem. In the last line I used the following: =Trim([City] & ", " & [State] & " " & [Zip]). It works but there is a problem. The Zip Code shows as 123456789. There is no "-" between the 5th and 6th number. The records are stored with...