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 Chris Miller 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: *

  1. Spikemaster

    simple problem merging access in word

    here is a relatively easy problem i just can't seem to resolve; partly because i am working with MSOffice in dutch. Right now i am merging an access-query into Word. All is fine with filling in the different fields such as first-name and surname. But here is the problem; between first- and...
  2. Spikemaster

    IIf...then use....: a beginner at work and very desperate

    well many thanks for helping me with this problem it was Joe's fomula that did it in the end: Expr1: IIf(IsNull([Adressen].[AdresWerk])=Onwaar;[Adressen].[AdresWerk];[Adressen].[Adres]) 'onwaar' means false by the way. When i implement this expression under 'criteria' of 'adreswerk' it...
  3. Spikemaster

    IIf...then use....: a beginner at work and very desperate

    Thanks alot guys for the help: i am experiencing more trouble because i have to translate everything to dutch first. this is what i managed to copy from your suggestions: SELECT [Adressen]![AdresWerk], IIf(IsNull( [Adressen]![AdresWerk])=False, [Adressen]![AdresWerk], [Adressen]![Adres]) FROM...
  4. Spikemaster

    IIf...then use....: a beginner at work and very desperate

    First of all: i am new with access 2000, but i have bot been able to find the solution to my problem in help: in my form i have two different address-fields: approximately 90 % of my records have entries in one field(address at work), while the other 10% have entries in the other field(address...

Part and Inventory Search

Back
Top