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

    Using Count to return 0 when no records returned

    Hello, am trying a report that counts the number of Students who completed a specific lesson, grouped by month. The problem occurs when no students are counted for a month, instead of 0 it skips the month entirely. So the query: SELECT Month([DateReceived]) AS Mnth, Count(tblStudent.StudID) AS...
  2. frogmann

    Split table into multiple databases and keep relationships

    Hello, I've seen various forums online that address this, but none that seem to clarify the issue for me. I have a large .mdb file due to one table in particular which is very large (1,455,000 records and counting). The DB is still under 2GB but I will need a solution for this soon (and yes...
  3. frogmann

    IIf statement in query to return 0

    Hello, I'm trying to create a simply query that will count the number of StudentIDs for a given month, and return 0 if it gets a null response for any of the months. In SQL view it looks as follows: SELECT Month([DateReceived]) AS Mnth, Count(tblStudent.StudID) AS CountOfStudID FROM tblStudent...
  4. frogmann

    INSERT INTO statement from recordset needs to support null date values

    Hello, I'm continuing to have a bear of a time trying to accommodate null values in my insert statement. In particular (a simplified version): sql1 = "INSERT INTO tblStudent ( [DOB] ) VALUES ( #" & rs1![DOB] & "#) ;" This statement works fine when there is a date in DOB. But when it is null, I...
  5. frogmann

    Run-time error 3134: Syntax error in INSERT INTO statement

    Hello, am having a terrible time with this INSERT INTO statement. I know that single quotes go around text, dates need hashes, numerics need nothing. I can see the values for each of these is correct in debug mode, but still get the syntax error. If anyone can see the problem, would be very...
  6. frogmann

    Run-time error: No value given for one or more params

    Hello, I receive the following error: Run-time error '-2147217904 (80040e10)': No value given for one or more required parameters when running the following code: Set rs1 = db.OpenRecordset("SELECT * FROM tblNewStudentLog") Do rs1.MoveFirst sql1 = "SELECT tblStudent.StudID...
  7. frogmann

    Problem with Query using date range from control

    Hello, I am trying to reference a date range using a control from a form. I can reference the form ok using: [Forms]![frmMaryLtrReview]![txtSentDate] (this works when using a range: <[Forms]![frmMaryLtrReview]![txtSentDate]). But I want to specify a range: Between...

Part and Inventory Search

Back
Top