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 TouchToneTommy 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: pankajdaga
  • Content: Threads
  • Order by date
  1. pankajdaga

    Access queries: passing parameters to a query like a where clause

    Hi everyone, I am an Access n00b. I have been trying this for hours and to no avail. I do not know why this should be so difficult! I have a query in Access say something simple like: Select * from Employees All I want to do is pass it a parameter like: Select * from Employee...
  2. pankajdaga

    Hi everyone again, I am stuck ag

    Hi everyone again, I am stuck again. SQL really is not my thing :-( Consider the following table again: ID TESTNUMBER STATE VALUE 1 100 1 0 2 100 1 1 3 100...
  3. pankajdaga

    SQL query dilemma. Multiple ANDs on a field over many entries

    Hi everyone, I have not been in touch with SQL for a long time. I had to start using it again since a few weeks and it has been quite a struggle. I have a question and I would be really grateful if someone can help me with it. Consider the following table structure: ID TESTNUMBER...
  4. pankajdaga

    SQL server to Access transformation

    Hi, I did not know how to convert an SQL server database to Access. Paladine had suggested using a DTS and probably is the easiest way to do it. However, I have a few questions regarding this: - The first one is that I cannot seem to import the identities and Primary keys in the Access tables...
  5. pankajdaga

    SQL server to access conversion

    Hi everyone, I know most people are going from SQL server to MS Access. However, for my particular need I need to convert an SQL Server database to MS Access. I, however, only need to import the tables with all the constraints. Is there any script or some simple way to do this? Any help would...
  6. pankajdaga

    Convert from SQL server to access

    Hi everyone, I know most people are going from SQL server to MS Access. However, for my particular need I need to convert an SQL Server database to MS Access. I, however, only need to import the tables with all the constraints. Is there any script or some simple way to do this? Any help would...

Part and Inventory Search

Back
Top