Search results for query: *

Hi, Thanks for the reply. However, I need to use it on an Access query. The SQL statement was just an exmaple. So, I have a complex query with some joins and I want to filter it based on a certain column(s). So, what I need to do is pass a parameter to an Access query that will filter the...

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...

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...

excellent! It works! Thanks a bunch man! Pankaj

Hi, Thank you so much for replying. Could you by any chance give me some SQL code to achieve it. As I mentioned, I am not very good at it. Thanks, Sincerely, Pankaj

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...

Cool! I will do that tomorrow. If I find something, I will post it here. Pankaj

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...

Hi Paladine, I think your solution is the best. However, I have 2 questions that I was wondering if you could help me with: - The first one is that I cannot seem to import the identities and Primary keys in the Access tables. - Second, I would like to be able to run this DTS package through...

Hi, Thanks for the reply. Does DTS always import the constraints correctly?? I usually loose the Identities and the primary keys. Also, is it possible to use DTS through ASP.NET Thanks, Sincerely, Pankaj

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...

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...