Results 1 to 4 of 4
  1. #1
    reddog1898 is offline Novice
    Windows Vista Access 2007
    Join Date
    May 2011
    Posts
    2

    Filtering on Field Names from Table

    I have a table which looks like this example (linked to an excel file)

    Name Project Date1 Date2 Date3


    n1........p1......x1.....x2.....x3
    n2........p2......x1.....x2.....x3 (x's = hours per person per project on
    n3........p3......x1.....x2.....x3 given week ending date Date1 ect..)


    what I am trying to do is create a report, and utimatily a form to select these field names, that I can specify a Name(n1) and a Week Ending Date(Date1) and it will return a list off all Projects(p1) that they have hours(x1) associated with and those hours per Project(p1) for that given week. I have every week ending date loaded as a column in excel and formulas which are calculating the hours spread per person given a date range they will be on that project

    I am sure I need to write code for this but for the life of me, I can not come up with anything. Thanks in advance for any suggestions and help.

    Mark

  2. #2
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    Probably the easiest way is to build a query and then use a search form with unbound text boxes to insert your criteria. This will then generate a query result that can be used to populate either a form, a report or can be exported back to excel.

    Here is an example of how to do that.

    http://www.datapigtechnologies.com/f...earchform.html

    Alan

  3. #3
    reddog1898 is offline Novice
    Windows Vista Access 2007
    Join Date
    May 2011
    Posts
    2
    Thanks Alan that gets me close to what I am needing to do however I am still not there.

    What I need to do is search for the data under a Field Name and a specific field name so I can get the results as follows under this example of my table:

    Name.....Project Number...5/16/2011...5/17/2011
    mark............1....................5............ ....3
    mark............2....................9............ ....1
    chris............1....................2........... .....5
    chris............2....................3........... .....6

    I would like to say give me all the hours for Mark on Project 1 during 5/16/2011 <-- would like to see it return with the field names Mark...1....5
    or more general of a search like give me all the hours and project numbers that mark worked on 5/16/2011 <-- This I would like to see Mark....1...5
    Mark....2...9

  4. #4
    alansidman's Avatar
    alansidman is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Apr 2010
    Location
    Steamboat Springs
    Posts
    2,529
    What does your SQL statement look like, becuase as I understood your original request, the video should have given you what you requested. When you put Mark, Project 1, and 5/16 in the respective search boxes what do you get?

    Alan

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

Similar Threads

  1. Get Field names from a table in CurrentDB()
    By e.badin in forum Programming
    Replies: 8
    Last Post: 01-06-2011, 02:17 AM
  2. How to retrieve field names in a table
    By pkstormy in forum Code Repository
    Replies: 0
    Last Post: 12-05-2010, 09:09 PM
  3. Replies: 1
    Last Post: 05-17-2010, 12:21 PM
  4. creating field names in table without typing
    By GHanover in forum Database Design
    Replies: 2
    Last Post: 12-14-2009, 05:13 AM
  5. Replies: 5
    Last Post: 03-31-2009, 09:16 PM

Tags for this Thread

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