Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2010
    Posts
    21

    Unhappy Crosstab Form or Lots of Work?

    Just wondering if anyone else has a better solution for this quandary.


    I am setting up a fast set up tool for a user for some pool testing software. At time of coding I don't know the surfaces of the pool or the chemicals the user may want to test for. I have solved these issues as they are fairly straight forward. However I am now looking at the test targets they set. The only way I can imagine doing this at this time is using a fairly complex coding to build a temporary table containing a field with the surfaces selected and then columns with the test parameters the user has chosen so they can input the target values.




    Is this the best way to do it? Or is there a simpler solution I am overlooking?


    by the time I get to this stage in a table I have the surfaces the user has selected, and separately in another table the parameters they have decided to test for. My idea was to create a table with surface as a column, and then a column for each parameter, program in the content in the surface column and display for user input as a subform.

    Thanks

  2. #2
    CJ_London is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,397
    without having any idea how your data is organised and related impossible to advise. All I can say is that unless there is a performance issue due to high volumes of data, the requirement to have temporary tables implies data is not normalised - which should provide a simpler solution.

  3. #3
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Use a Crosstab query, not a form

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

Similar Threads

  1. Replies: 13
    Last Post: 10-04-2015, 09:52 AM
  2. Lots of Help Needed!
    By kennuge in forum Database Design
    Replies: 2
    Last Post: 11-19-2014, 02:49 PM
  3. query lots of different ranges
    By freddie in forum Database Design
    Replies: 5
    Last Post: 10-10-2014, 10:14 AM
  4. crosstab query (criteria does not work)
    By Rich P in forum Access
    Replies: 1
    Last Post: 02-15-2011, 11:40 AM
  5. crosstab queries (criteria) won't work
    By Rich P in forum Queries
    Replies: 1
    Last Post: 02-15-2011, 10:53 AM

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