Critter-razy header

[teqtaq]

I have rather interesting task.
My field consist of values
Dog
Cat
Bird
Fish
NULL
Snake
Bee

I need to get Header on my report which will look like following:
If Values="Bird" then "Bird"
If Value="Snake" or "Fish" then "Other"
If Value = "Dog" or "Cat" or "Bird" or "Snake" or "Bee" or IsNull then header should say "ALL"

Seems easy but I can't wrap my brain around it.

 

[genomon]

Try a SELECT...CASE stsement in the header format event that populates the caption of a label based on the data in your field.

"Teamwork means never having to take all the blame yourself."

 

[Remou]

I think I would be inclined to do this in a query.

SELECT IIf(Instr("Dog,Cat,Bird,Snake,Bee,All",Nz[FieldName],"All"))>0,"All",IIF ...

 

[Remou]

... or better yet, a table with the subsitution values.

 

[ProgramError]

... the reason? It allows additional animals to be added without having to hard code them into the database.

I'm all for upgradability if there's such a word.

Ian Mayor (UK)
Program Error
Your lack of planning is not my emergency!

 

[genomon]

I'm all for upgradability if there's such a word.

Scalability?

"Teamwork means never having to take all the blame yourself."

 

[Remou]

Scalability

Is that what snakes have?

 

[genomon]

"Teamwork means never having to take all the blame yourself."

 

[ProgramError]

No, that's the act of weighing things in a kitchen. DOH!


Ian Mayor (UK)
Program Error
Your lack of planning is not my emergency!

 

[dhookom]

I prefer the phrase "data driven". There is a great article at

http://weblogs.sqlteam.com/jeffs/archive/2006/02/10/9002.aspx.

Duane
Hook'D on Access
MS Access MVP