Recent content by afortney

I figured it out, thanks a lot

OK, I kinda get it. Could you please show me a steip by step way of doing this ? I get the prompt box up and I enter a value and all it does is populate that value in a box that it made up.

How do you enter a param query in Acess 2000 ?

I need to have a free form text box come up and ask the user what he/she want to query for.

I need to Query out a columns worth of data inside of Access, How ? I can create a Query and pull up all the data but I only want to pull up let's say col1 has values from 1 to 1000 I only want to see 50 how do I do that ?

The following query works in MS SQL Server, but does not work in MS Access. I get the error "Invalid precis and the query is below: select (select max(answer.answer) from answer where answer.member_id in ( select member_id from team_members where project_id in ( select project_id from project...

I just ran it using the "Run" prompt inside of MS Access. The query bombs out after the " "page.order_id select (select max(answer) from answer" part, is there anyway I can modify the syntax so it will work?

The following SQL Statement works ib MS SQL server but will not work in Access. The error is Erroor in syntax of query expresttion. The error occurs in the middle of the statement where the the text is the following "page.order_id select (select max(answer) from answer" select (select...

Is there any way you could show me how to do this, give an example?

I am trying to get the following query to work in Access, but errors occur, please help. INSERT INTO Table1( Project_id, r.Page_id, Order_id) SELECT Project_id, r.Page_id, Order_id FROM RULES r, PROJECT p, Page WHERE p.Business_stream <> 'Upstream' or p.project_id<=30 or...

I can get this statement to work in SQL Server but will not work in Access: SELECT AVG(a.Answer) AS avgscore, t.Category_name, p.Project_id FROM TEAM_MEMBERS tm INNER JOIN PROJECT p ON tm.Project_id = p.Project_id INNER JOIN ANSWER a INNER JOIN PAGE t ON a.Page_id = t.Page_id...

I can get the following statement to work in SQL Server, but cannot get it to work on Access, please help select isnull(stdev(myvalue2),0) as mystdev from tempstdev where myvalue2>0 and sessionvalue = '25768'