Solved

Calling segments

Posted on 2013-01-22
4
240 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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Outlook Free & Paid Tools
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 …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

810 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