Results 1 to 2 of 2
  1. #1
    bdf48 is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Dec 2011

    Table Data Analysis

    So I am a new access user, but have a good amount of experience programming VBA in excel. I have a database for which I am trying to write some code to analyze data regarding fish movement.

    In one table I have a list of each fish in my study tagged with a unique numerical ID code.

    I have a system in the field where 12 different antennas are setup that can detect the presence of the fish when they pass the antenna location.

    What I want to do is count the number of paired detections for each fish. For example if we have a record of fish #1 passing antenna 1 and 2 then that is a single detection. Or if fish 1 passes antenna 6 and 8 that is a single detection.

    This would be somewhat easy to write in excel, but having trouble figuring out how this would be done in access. Specifically how I can reference table values from access and how to write the total count values to a new table.

    Any help would be appreciated.

  2. #2
    Madmaxrtw is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Dec 2011
    I would look into a case statement in access. They can be a little tricky but they are pretty powerful.

    This is a great article on how to use them.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 01-05-2011, 07:56 AM
  2. SAS(Statistical Analysis System) to SQL
    By Rixxe in forum Programming
    Replies: 4
    Last Post: 10-14-2010, 08:47 AM
  3. Replies: 0
    Last Post: 08-01-2009, 12:43 PM
  4. vba code for regression analysis P value output
    By Frangipani in forum Programming
    Replies: 0
    Last Post: 02-04-2009, 06:26 AM
  5. Need Help with Queries-Trade Analysis
    By nybanshee in forum Queries
    Replies: 0
    Last Post: 03-08-2008, 11:50 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
Other Forums: Microsoft Office Forums - Senior Forums