Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
Solved

# Calling segments

Posted on 2013-01-22
Medium Priority
246 Views
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
Question by:Kdankwah
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 66

Expert Comment

ID: 38807641
IIF([segment number]="00000000", [segment description], [Department description]) as NewColumnName
0

LVL 14

Accepted Solution

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

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

Question has a verified solution.

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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Ever wonder what it's like to get hit by ransomware? "Tom" gives you all the dirty details first-hand – and conveys the hard lessons his company learned in the aftermath.
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
###### Suggested Courses
Course of the Month6 days, 20 hours left to enroll