User Profile

Collapse

Profile Sidebar

Collapse
djdaveg
djdaveg
Last Activity: Jan 25 '10, 08:17 AM
Joined: Jan 20 '10
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • djdaveg
    replied to Use a single row in another table for a query
    in Access
    Hi Leon,
    Thanks for your help, I will give this a go
    See more | Go to post

      Leave a comment:

    • djdaveg
      replied to Receiving duplicate values using not equal
      in Access
      I changed SELECT to SELECT DISTINCT and yes I changed AND to &. No need for your snotty answer at all thanks very much!!!!, So no more unnecessary replies thanks. sorry for the unnecessary brackets that Access puts in itself when the query is saved
      See more | Go to post

        Leave a comment:

      • djdaveg
        replied to Use a single row in another table for a query
        in Access
        not that you can accurately match record by record, for example there is a column of postcode prefixes i.e. BB and town e.g. Blackburn
        See more | Go to post

          Leave a comment:

        • djdaveg
          replied to Query wrongly SELECTs last row in table
          in Access
          Ah Ha, I think its is because you are using select *, try putting each individual field into the query, maybe that will work. If you need to know how to do this let me know.

          Thanks
          Dave
          See more | Go to post

            Leave a comment:

          • djdaveg
            replied to Use a single row in another table for a query
            in Access
            Hi, thanks for your reply, however the ID numbers in the two tabels don't match, I have a database in one and a few towns and postcodes in the other, I need to reference a town and then its postcode without access using the whole column in the table and just using the one that the first part of the query has matched
            See more | Go to post

              Leave a comment:

            • djdaveg
              replied to Query wrongly SELECTs last row in table
              in Access
              Can youpost a screen grab of the result with the extra line?
              See more | Go to post

                Leave a comment:

              • djdaveg
                started a topic Use a single row in another table for a query
                in Access

                Use a single row in another table for a query

                I am wondering if it possible to refer to a row of data in access for a query, if I want to find a row by ID then use the next field in that row for a query without access using whole column, is this possible.
                See more | Go to post
                • djdaveg
                  replied to Receiving duplicate values using not equal
                  in Access
                  Thanks Chip, I have now discovered where I went wrong, it was my syntax, I should have used the following

                  SELECT DISTINCT tbMainData2.ID, tbMainData2.URN , tbMainData2.Con tactName, tbMainData2.Res taurantName, tbMainData2.Add 1, tbMainData2.Add 2, tbMainData2.Add 3, tbMainData2.tow n, tbMainData2.cou nty, tbMainData2.pos tcode, tbMainData2.Tel ephone, tbMainData2.Con tact_Ok, tbMainData2.reg ion, tbMainData2.Res taurantorTakeaw ay, tbMainData2.geo...
                  See more | Go to post

                    Leave a comment:

                  • djdaveg
                    started a topic Receiving duplicate values using not equal
                    in Access

                    Receiving duplicate values using not equal

                    I am trying to get alll the results of everything in the north where the towns do not match the towns contained in a seperate table, everytime I run this I am getting 37 duplications of each record in the result.

                    SELECT tbMainData2.ID, tbMainData2.URN , tbMainData2.Con tactName, tbMainData2.Res taurantName, tbMainData2.Add 1, tbMainData2.Add 2, tbMainData2.Add 3, tbMainData2.tow n, tbMainData2.cou nty, tbMainData2.pos tcode, tbMainData2.Tel ephone,...
                    See more | Go to post
                    No activity results to display
                    Show More
                    Working...