Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: pfuesting
  • Content: Threads
  • Order by date
  1. pfuesting

    Creating multiple records with a comma separated field

    I have a query in Access that is producing this: V1 V2 Count Group 1 PT1, PT2, PT3 1 Group 1 PT4, PT5 1 Group 1 PT5,PT6 1 Group 2 PT7 2 Group 3 PT8, PT9 1 But I need it to create a new record for the comma separated values. The data should look like this: V1 V2 Count Group 1 PT1 1 Group 1 PT2 1...
  2. pfuesting

    Microsoft Access Median function

    Please help....I am trying to calculate the median based on a grouping. I am using the following code and it seems to be working. The only probelm is that there are also null values that should not be considered. How do I exclude the null records from the record count? Function...

Part and Inventory Search

Back
Top