Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Calling segments

Posted on 2013-01-22
4
Medium Priority
?
249 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
3 Comments
 
LVL 66

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 2000 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

Microsoft has changed the look and feel of Azure AD and Microsoft account sign-in pages so that you will have a more unified look and feel when moving between the two interfaces.
Quickbooks hosting can do wonders to your enterprise but considering the points elaborated in the article which will help you to better analyze the outcomes. So scan your business, its needs and then move to the new world of limitless benefits.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …

783 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