Solved

Calling segments

Posted on 2013-01-22
4
238 Views
Last Modified: 2013-01-22
I need an MS Access formula for this:

If a segment number = 00000000 then segment description
else
Department description.

segment number is a txt field

Thanks
0
Comment
Question by:Kdankwah
4 Comments
 
LVL 65

Expert Comment

by:Jim Horn
ID: 38807641
IIF([segment number]="00000000", [segment description], [Department description]) as NewColumnName
0
 
LVL 14

Accepted Solution

by:
pteranodon72 earned 500 total points
ID: 38807655
In a query?
Description: Iif([segment number] = '00000000', [segment description], [Department Description])

as a control source on a form:
=Iif([segment number] = '00000000', [segment description], [Department Description])

HTH,
pT72
0
 

Author Comment

by:Kdankwah
ID: 38807670
Thanks for timely response.  What if the segment is a sub department of the department and I want to run reports department reports seperate from the segment reports.  I dont know if I should open another ticket for this.

Thanks
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Library not Registered 16 51
DBF to ... Converter 5 49
word is recognized as adobe and adobe as IE files 14 21
VBA code won't run Delete Query 5 27
Entering a date in Microsoft Access can be tricky. A typo can cause month and day to be shuffled, entering the day only causes an error, as does entering, say, day 31 in June. This article shows how an inputmask supported by code can help the user a…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
The viewer will learn how to  create a slide that will launch other presentations in Microsoft PowerPoint. In the finished slide, each item launches a new PowerPoint presentation and when each is finished it automatically comes back to this slide: …

863 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now