Search results

which is the correct way? " " or ' " " '

so which is the correct way? and can i go back to a single vara with those changes?

sorry :(

sorry i took so long hte computer went to the blue screen of death If Not (Nz(where, "") = "") Then where_comp = "Mid(where, 6) " If Not (Nz(where_cont1, "") = "") Then where_comp = where_comp & " & where_cont1" End...

all of the dynamic built strings begin with " AND " because you do not know which is the first one to contain a value and therefore which is the first line in the dynamic string. therefore you have to use Mid(where, 6) to remove the first " AND ".. here is the condition i came up with, what do...

into the sql Set orec = dbs.OpenRecordset("SELECT [Analyte], [Method], [Result], [Units], [DL], " & _ "[LOQ], [FlowValue], [FlowUnit_ID], [Notes] " & _ "FROM tblWater_Sample_Temp " & _ "WHERE " & Mid(where, 6) & ";")

I am now using 4 variables. but my q now is how do i combine these in the query? ie: if not(nz(where, "")="") and not(nz(where_cont1, "")="") and not(nz(where_cont2, "")="") and not(nz(where_cont3, "")="") then & mid(where, 6) & mid(where_cont1, 6) & mid(where_cont2, 6) & mid(where_cont3...

I am trying to build a dynamic query using : 'build a dynamic search clause to retrieve the information. where = Null If Not (Nz(rec!Matrix, "") = "") Then where = where & " AND tblWater_Sample_Temp.Matrix = '" & rec!Matrix & "'"...

no... the problem is that it won't select distinct dates based on month and year and display them that way I tried this; strDate = Format$(Me.cboMonth, "mmm-yy") but it throws an error.

i tried that dl the db and try it

I have a form which won't format the date properly in 2 parts. 1) the dropdown, the date won't format as "mmm-yy" when it drops down. 2) the date won't format for when I append it to the RE section. I have included the db

I got it now, thanks!

I am tryig to get the count to work in that form for the total in each point range. as well as for the total in each color kids form i put in atext box with =Count(*) but I get #Error little help..

lol, oops, sorry, one of those days I guess... Ironically I cracked a problem today that has been plaguing me for 2 weeks! Yet I couldn't remember this... maybe there's hope for me yet! ~THanks :o

that is what I am after, but since I put the points in as their own group they do not give the option to order (that I can find) just look at it, and try what i described above ~Thanks

The problem is that I have put the Points at the top when creating levels sp that the points total only appears once per group of prople with that many points.

In the attached database there is a report: "rptIndividualPointsTotal" which is based off of the query: "qryPointsTotal". the report has each person listed under the a point total. currently it lists the point total from least to greatest. Is there a way to have that report list the points...

I am using recordsets though, so that I can deal with one record at a time rather than all at once. I am ONLY using sql to insert. Anything else? as to y it isn't working?

I have the following db and form on my computer. I have checks and sql in the code to try the insertion but it simply throws a error. The code is at the bottom of the main form. if you open and run it it will throw the error for you. I REALLY need help on this, I have been trying for...

THey have common id's