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

    Is there code to get parts of a table and put them into another table?

    Hello, I am trying to write the code to copy part of a table if certain requirements are made. I want to copy part of a table and put it into another table, but I can not figure out the code. I do not want to manually do it. Does this make any since?? What I am working on is a very in-depth...
  2. nicmar

    averaging multiple fields from a table

    How do you average multiple fields in SQL? To average one field, this is the syntax: SELECT AVG(Field1) FROM Table1; So how do you average multiple fields together? Ex. (this is incorrect) SELECT AVG(Field1, Field2, Field3) FROM Table1; What is the syntax??? Any comments or suggestions are...
  3. nicmar

    Assigning a value to a text box on a report...

    Hello, Is this the correct way to assign a value to an textbox on a report? Reports![Test Score Report]!txtMaxScore = rsStatistics![MaxOfScore] I am getting this error: "You can not assign a value to this object." The text box is an unbound text box on my report, I am...
  4. nicmar

    Recordset trouble...

    Hi, I am trying to get this recordset to work. My SQL statement is correct, I checked it in the query builder grid and it worked. Is there something that I need to turn on or declare, that is not done, to get the recordset to work? Or is there something to turn on for the dbOpenSnapshot? I...
  5. nicmar

    SQL syntax error

    Hey, I am trying to do an openrecordset, I am pretty sure that my SQL statement is correct. The problem I am having is with the Set rsStatistics line. I get one of two errors: Syntax error (missing operator) in query expression 'SDataQ.Class=01CBE'. OR Type Mismatch. No matter what I do...
  6. nicmar

    Select statement error

    I am trying to get the average, minimum, and maximum from a table and display the asnwers in text boxes on my report. Here is my code: gstrSQL = "SELECT Avg(SData.Test1) AS AvgScore, Min (SData.Test1) AS MinScore, Max(SData.Test1) AS MaxScore" gstrSQL = gstrSQL & "FROM...

Part and Inventory Search

Back
Top