Search results

ok, lets take just this one. If we can find out what is wrong here, then I can manage further. So the syntax is wrong in this one: =[par_id] & ", " & [par_name] & ", " IIf(IsNull([par_name]), "", [par_name]) besides, the part before IIf(IsNull([par_name]), "", [par_name]) works fine.

in numbers and currency , is the decimal symbol in dates . is the time seperator. No other seperators there. in Latvia we don't seperate thousands...

yeah, it is the same in the field list. par_city ...means partner's city anyway it doesn't matter.... :) maybe I can't just give a field names, maybe I have to give a full address like [Forms]![frmPartners]![par_city] ...I'll just try it out...

here is the message I get in case of =IIf(IsNull([par_city]), " ", [par_city]) though I don't think the issue is in whether I write "" or " " I think, though I'm not sure, that problem is really in syntax, like you can write it like this in VB but can't in control source. something, just like...

KenHigg, I just tested it step by step andding peace by peace, and the part where access gives me an error of syntax is this: IIf(IsNull([par_city]), "", [par_city]) it is like I write in the control source of unbound field: =[company_name] & ", " & [street] & IIf(IsNull([par_city]), ""...

KenHigg: initially I put this code in report's on open event: Private Sub Report_Open(Cancel As Integer) Dim fulladdress As String fulladdress = IIf(IsNull([par_street]), "", [par_street] & Chr(44) & Chr(32)) & IIf(IsNull([par_city]), "", [par_city] & Chr(44) & Chr(32)) &...

Well Rich, when I put such thing in field's control source I get an error re invalid syntax. well I am not that smart to find out where the syntax is corrupt, but I used the same one you gave me, just changed the names ot the fields.

Rich, you mean that I should put something like you posted in the control source of this unbound field in the report, or I should put it in report's on open event, like I did it before with the peace of code from the form which of course didn't work out.

Greetings! Most likely it's simple one. I have table with many different fields for parts of an address, like city, parish, street, region etc. For each record some of those fields would be empty, others filled. At the end what I need is to combine all those fields together into one, so making...

Greetings. Is it possible in MsAccess, to make thing like this: I have a table with number of records, each record consists of many fields and one of them is check box. I'd like to open this table via form in way of continious form or in datasheet view, and to have records where check box is...

Thank you. Nz function... but how? Can you give me an example? Should I use it in the expression in query?

Greetings. I can't understand how to do this most likely simple thing: I have a query, based on table, where I have 7 fields for entering address, like street, city, parish, county, post office, zip & country. For many records some of those fields will be empty, like Brown street, Moscow, -...