|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 8th, 2009, 08:57 PM
posted to microsoft.public.access
|
|||
|
|||
Creating query with Calculated Field
I am creating a query with a calculated field named MonthlyFeeStatus. This
field should equal Active if the MembershipStatus field is equal to Active and equals Not Active otherwise. How would I set up this equation. Thanks -- PrincessaIzMe 
|
|
#2
May 8th, 2009, 09:28 PM
posted to microsoft.public.access
|
|||
|
|||
|
Creating query with Calculated Field
On Fri, 8 May 2009 12:57:01 -0700, Princessa
wrote: I am creating a query with a calculated field named MonthlyFeeStatus. This field should equal Active if the MembershipStatus field is equal to Active and equals Not Active otherwise. How would I set up this equation. Thanks MonthlyFeeSatus: IIF([MembershipStatus] = "Active", "Active", "Not Active") This assumes that MembershipStatus has values other than "Active" and "Not Active"; if those are the only two, then you can simply echo the field: MonthlyFeeStatus: [MembershipStatus] -- John W. Vinson [MVP]
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
