User Profile

Collapse

Profile Sidebar

Collapse
emperial
emperial
Last Activity: Aug 8 '14, 09:05 AM
Joined: Jul 22 '14
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • emperial
    replied to Find Unique Values ONE Column - Access SQL
    in Access
    Thank you both for the suggestions!

    That is indeed much more simple and have got it working now.

    I used NeoPa's code.

    I have only started using Access about 2 months ago, so I'm afraid I know what it needs to do but not sure what the best way (read: according to db rules!) is of getting it done!

    Haha thanks ZMBD for your comment regarding the endusers. I'll make sure to let them know ;)
    ...
    See more | Go to post

      Leave a comment:

    • emperial
      replied to Find Unique Values ONE Column - Access SQL
      in Access
      Hi all,

      Just in case anyone is interested, this is probably against all rules, but I have used the following steps to get what I wanted:
      - Used Job Count (and Group) to show records that would need to be deleted
      - Appended these jobnumbers to a table with an Append query
      - Used 'Find Unmatched Query Wizard' (so all records that didn't match the jobnumbers from the appended table would show)
      - Saved as a query...
      See more | Go to post

        Leave a comment:

      • emperial
        replied to Find Unique Values ONE Column - Access SQL
        in Access
        Hi ZMBD,

        Thanks very much for the suggestion! Am going to give this a try.

        Unfortunately I am not the end user which makes it quite difficult (and frustrating!) to set up a normalized db.

        Thanks again and I'll let you know how I get on.

        @Twinnyfo, apologies, I ready your first reply wrong. I thought it said 'job number and name of the workmen'. I do understand it's unfortunately not normalized...
        See more | Go to post

          Leave a comment:

        • emperial
          replied to Find Unique Values ONE Column - Access SQL
          in Access
          Hi ZMBD,

          Thank you very much for the above.

          It does work indeed!

          However, as the projects keep changing, say, at the moment no one is working at job "12" and "15", but next week it might be "14" and "13" that I would need to delete. So is there a way for Access to check whether a number occurs only once, and if so, deletes that record from the table?

          Thank...
          See more | Go to post

            Leave a comment:

          • emperial
            replied to Find Unique Values ONE Column - Access SQL
            in Access
            Screenshot of example db

            Please find attached a screenshot of the database and the records I would like to have deleted

            [imgnothumb]http://bytes.com/attachment.php? attachmentid=78 01[/imgnothumb]...
            See more | Go to post
            Last edited by zmbd; Aug 6 '14, 11:37 AM. Reason: [Z{Made attached images visable}]

              Leave a comment:

            • emperial
              replied to Find Unique Values ONE Column - Access SQL
              in Access
              Hi Twinnyfo,

              Thanks for helping me out again!

              Sorry if I didn't make it clear, the job number and workmen are two separate columns (I did try to insert some 'tabs' in the example table, but they got deleted after posting).

              Does this help at all?
              See more | Go to post

                Leave a comment:

              • emperial
                started a topic Find Unique Values ONE Column - Access SQL
                in Access

                Find Unique Values ONE Column - Access SQL

                This forum has been so helpful last time, thought I would give it another try!

                Have gotten to the point where I can't see the forest for the trees as I have the feeling the solution is quite simple!

                I have a table with the following columns: job, name of the workmen, days of the week, rate, adj, total and comments.

                To give an idea of how, a part of, the table looks like, please see below:
                Code:
                Job
                ...
                See more | Go to post
                Last edited by zmbd; Aug 6 '14, 11:35 AM. Reason: [z{[CODE] will keep table format, use spaces instead of tabs (^_^)}]
                • emperial
                  replied to Count fields greater than zero using expressionbuilder
                  in Access
                  twinnyfo, thank you so much for your prompt reply. This code works perfectly and is exactly what I needed.

                  I wanted to count the days worked (=>0), excluding days off (=0).

                  Massive massive thanks!
                  See more | Go to post

                    Leave a comment:

                  • emperial
                    started a topic Count fields greater than zero using expressionbuilder
                    in Access

                    Count fields greater than zero using expressionbuilder

                    Hi all,

                    Please help with the above issue as I am absolutely desperate.

                    There should be a simple solution.

                    I am working on timesheets where the fields Saturday - Sunday have different jobnumbers.

                    Example:
                    Sat Sun Mon Tues Weds Thurs Fri Days
                    10 12 08 07 06 13 0 6

                    At the end of every row is a column called 'days'.

                    I would like to count...
                    See more | Go to post
                    No activity results to display
                    Show More
                    Working...