Recent content by jean2002

Sorted it out already, there was a space in two places in the query for [ qryAllPersons]

Hello, I have a query with the following structure: qryAllPersons: Select tblPersons.ID, tblPersons.Name, tblPersons.DateRecorded_A, tblPersons.DateRecorded_B, tblPersons.DateRecorded_C, tblPersons.DateRecorded_D, From tblPersons; And this gives the following result when executed...

Thanks, but I solved this one now. Used a update query instead.

Hello, I have have searched through numerous post in this forum, but I still have the following question: I have a database with a table say tblPeople. This table contains e.g. the following fields: ID----NAME----SURNAME----HAND---PERCENT1---PERCENT2...

Thanks, with using some if...elseif...else statements i got my version to work!

Good morning! I have a form which an user fills in, and before clicking on a button to go to the next form, there must be a check that all controls have been filled in completely. For example, if I have frm1 with fraOne, cboOne & txtOne, I wrote the following code for the OnClick event for...

Solved it now... The problem I had was that I am using a German version of MS Access, and somehow it did not understand the term Iif. Strange, cause it can translate other terms, like Nz, True, IsNull etc. Seems there is a bit of a language barrier problem at Microsoft... Well I got it to...

Well just got back to this problem... EEEESSSHH It turns out that I will have to use this Nz function in the QBD grid (pardon my previous misspelling "QBE"), because I will be basing a search form on this query. Can I maybe send this sample DB to someone who can then check it out? Regards, JP

Yip that worked now, but it really boggles me too why that was an error with using Nz() in the QBE... thanks guys - stars for you

Nope, created a new query, in design view, with the following in the "field" box: BMI:Nz([BMI_L], Nz([BMI_R], Nz([BMI_VID], [BMI_VTH]))) still no luck...(syntax error)

OK here goes the SQL.... There are 4 calculated columns in this query, namely BMI_L, BMI_R, BMI_VID and BMI_VTH. See them? SELECT [tblVersuchspersonen_test].[VPNummer], [tblVersuchspersonen_test].[Nachname], [tblVersuchspersonen_test].[Vorname], [tblVersuchspersonen_test].[Abteilung]...

The text box is called e.g. txtFinalValue, but i do not see why that should matter. I tried using this in a query, by typing it into the "field" box of QBE, but it still gives me a syntax error....

No, as I said in my first post, the textbox is based on a column in a query, called Value1, Value2 etc.:

Yeah what I mean is that I get a syntax error. (trying to enter this expression in the Expression builder of the ControlSource property of the text box) When I leave out the "=" sign at the beginning of the expression (as in =Nz(Value1, Nz(Value2....), I get no syntax error, but the value in...

Thanks PH, OK that is fine for 2 columns then, but what about if I have a Value 3 and Value 4 column? I tried something like this, but it doesn't work: Nz(Value1, Nz(Value2, Nz(Value3, Value4))) Regards, Jean