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!

  • Congratulations strongm 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: Paul77fox
  • Content: Threads
  • Order by date
  1. Paul77fox

    Pivot table problem

    Hello everyone. I'm using ms access 2010 and I have a problem with the names of the columns and rows of a pivoted table. They are 1, 2, 3....12 for month_id and 1, 2, 3.....20 for service_id, instead of jan, feb, mar... and service1, service2, service3...service20. The pivoted table is a child...
  2. Paul77fox

    Pivot table view problems

    Hello guys. Can anyone tell me why in my pivot table view, the rows and columns are named 1,2,3...etc instead of their real names? Thank you!
  3. Paul77fox

    Temporarily denormalize a table

    Hello everyone! I need some help here! The main table structure is : client_id : month_id : service_id : amount : I would like to have a form with client_id like combo box, and then temporarily denormalize the rest of the table (month_id, service_id, amount) to look like a spreedsheet (month_id...
  4. Paul77fox

    Program to generate all possible records for a table structure

    Hello guys. I'm new in ms access and I would like to know how to generate all the possible records for this table structure: client_ID : month_id : service_id : amount I have 30 clients, 10 months and 35 services I would like to have 30x10x35 records in my table (generated programmatically) with...
  5. Paul77fox

    Converting 300 excel sheets into database

    Hello guys. Please help me with this and tell me the best method of creating a database of 300 clients everyone with its own table ((months (only ten of them) an services (30)). If I create a table where all the clients will have fields for months and services, will result 10x30=300 fileds for...
  6. Paul77fox

    Hi, I need to print only "true" marked records

    Hello guys. I'm very new in visual foxpro and I need help for a simple project. I have one table, one form, one grid in that form and I need to know three things: 1. How do I program the DblClick procedure of my logical field's header, to change all values in "true" and viceversa (if they...

Part and Inventory Search

Back
Top