Recent content by cowannbell

  1. C

    Pull random records

    I found the answer. http://support.microsoft.com/kb/292634
  2. C

    Pull random records

    I'm confused on this part. I need to pull the entire record but only one per address #. Select Address, FIRST(Name) AS Name The field name of the Address is address#. Are you saying it should look like this: SELECT [(Grp AZ & CO Providers)].*, FIRST [Address #] AS Address # FROM [(Grp AZ &...
  3. C

    Pull random records

    I have a table that has names and address and an address number. There are multiple address numbers but the names may be different. I only need one record for each address number and it doesn't matter which name i pulls. How can I accomplish this. Thanks,
  4. C

    Get Outlook Folder Name

    I figured it out myself. Here is the correct code. rstMail![Outlook Folder] =pfld
  5. C

    Get Outlook Folder Name

    I currently have a database that pulls in emails from Outlook. I also want it to pull in the name of the Outlook folder, the email is being pulled from. Here is what I current have and I need to finish this statement. rstMail![Outlook Folder] = I'm not sure where to go from here. Any...
See more
Back
Top Bottom