Search results for query: *

Thanks Remou, I did it that way and it worked. Thanks for the help.

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

Hello, Thanks to all for your responses. Yes, it seems clear that splitting the table is not the way to go. I believe I have time yet to migrate to something more robust, so that is the way I will go. Your help on this was very much appreciated.

I take it by your response, dhookom, that separating the table into two distinct dbs would necessitate relinking all relationships manually, + whatever else? I didn't know if there is an analyzer function that might do the work for me, or what have you. Can't afford SQL Server... will probably...

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

Hello All, Thanks to everyone for the responses. I tried a version of pwise's method and it worked, so case solved. Thanks much for all the help!

Thanks for your responses. Golom I tried your answer and got an error on the join condition. You are trying to join an int with a date?

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

Thanks for the update pwise. Unfortunately I now get a run-time error 94: Invalid use of null. I've looked all over the web for an answer to this, and I have yet to find a solid, definitive answer that works. Whenever this gets solved I'm going to post it everywhere I can. So many problems for...

Hi Pwise, thanks much for your quick response! Sorry, it looks like your last 2 code samples were identical. I tried it and now get a run-time error '13', type mismatch. Is there something you were thinking to do differently on your second response? I'm wondering if Nz() is just for numbers, not...

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

Yes, it was the extra () that did it. Thank you! Strange, as I thought they were needed when doing line breaks. I guess just depends on context. Oh - table did accept 0-length strings. Thanks also for the tip with the doublequotes - makes sense. Your help is very much appreciated.

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

The last one worked, thank you pwise.

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

dhookom, I tried but it didn't work (Access 2002), kept getting "too sophisticated or not well written" error messages (to paraphrase). Is in the confines of a query, and only the DateAdd() seemed to work. Thanks though!

Hello All, Here is the answer: Between ([Forms]![frmMaryLtrReview]![txtSentDate]) And DateAdd("d",-61,[Forms]![frmMaryLtrReview]![txtSentDate]) Thanks for the help!

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