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 gkittelson 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: *

  1. dvenkat

    TRANSPOSE RECORDS IN A TABLE

    Hi I HAVE A TABLE AS FOLLOWS- Country City USA Austin USA Houston USA Dallas Canada Toronto Canada Montreal I want to change the table like this- Country City USA Austin, Houston, Dallas Canada Toronto, Montreal the table is very huge and so its tough...
  2. dvenkat

    HELP NEEDED WITH ASP!!!!!

    Hi I can set up the database. No problem. But its the asp portion that left me wondering what to do. I will check out the link you have sent. Thx for the help. If you guys have any other suggestions pl let me know
  3. dvenkat

    HELP NEEDED WITH ASP!!!!!

    Hi I need to design a database with three tables - one for each mfg site. The data into the tables will be entered via the web (data access pages/ asp pages) by some employees in Asia. Then I need to design a page which would display all the data (entered by Asia users) from the three tables...
  4. dvenkat

    Help required !!!!!!!! with Data Access Pages

    Hi I need to design a database with three tables - one for each mfg site. The data into the tables will be entered via the web (data access pages/ asp pages) by some employees in Asia. Then I need to design a page which would display all the data (entered by Asia users) from the three tables...
  5. dvenkat

    Data Access Pages

    Hi I am novice with Access. I need help to do the following- I need to create a data access page so that a user can access the page in the web, enter data in the textboxes shown in the page. The data entered should be populated into a table in access. How do I accomplish this? Any help is...
  6. dvenkat

    How to return values by comparing consecutive fields in a table?

    Thanks. This is exactly what I needed. Thx for the help guys. I will try it out and let you know if the query worked out. Thx again
  7. dvenkat

    How to return values by comparing consecutive fields in a table?

    I have the following fields in a table- Name, Age, Sex, Designation, Perf1, Perf2, Perf3, Perf4, Perf5, Perf6....Perf12. I need to return the name, age, sex and designation if Perf2-Perf1 > 4 or Perf3-Perf2 > 4 or Perf4-Perf3 > 4 or ..... Perf12-Perf11 > 4. I need to return the name, age, sex...
  8. dvenkat

    Parameter Query with 5 listboxes

    Jim Thx for your response. I am looking at your sample file.
  9. dvenkat

    Parameter Query with 5 listboxes

    To WildHare: Thx for the suggestion. Could you pl take the time to explain how I stick the choices from the listbox into a table. Thx for your advice. Its a great approach.
  10. dvenkat

    Parameter Query with 5 listboxes

    Hi- I am developing a query (parameter) with 5 list boxes. I am using the following code (see below) to retrieve records from the query based on the user options/ choices. However I get this error message when I run the query. Error Message: Run-time error '3075' Syntax error (missing...
  11. dvenkat

    Parameter Queries that query more than one field

    Hi I am setting up a parameter query with 5 list boxes. I need help with the following- How to set up the parm query so that user can choose any combo he / she wants and the query will retrieve records based on user options. How do I allow multiple selections in each list box. How do I show...

Part and Inventory Search

Back
Top