Concatenation of Text and Number

[RuralGuy]

We can create a Global User Defined Function (UDF) for this but are you in control of the design?

[diane802]

Yes I am!!

How would I create this?

[RuralGuy]

I'm not trying to run you around in circles Diane but the design seems a bit awkward and perhaps suffers from some normalization issues. You may want to examine those items first.

[diane802]

yeh i know...

its bc the users want to be able to also report separately on these three categories when needed, hence why the Form doesn't just ask for them to fill it into one cell.. but then they want to combine it into one column for certain reports...

what do you mean by normalization issues?

[RuralGuy]

Have you read any normalization articles yet?
Here's one from Microsoft but Google knows of pleanty more.

[diane802]

This is very helpful. Thank you!

[RuralGuy]

Do you want to create a UDF for the latest issue or revise the table structure a bit?

[diane802]

i don't think i can revise the table structure.. my option is to probably create a UDF... or report on it in three separate columns (which isn't the ideal)

[RuralGuy]

OK, we'll need a UDF that will accept 6 arguments then. Do you know how to create a standard module?

[diane802]

Yes, i just have never written an actual UDF..

If you help me outline the first few steps, I'm sure I can figure it out from there.

[RuralGuy]

OK, start a new module. What do you want to call our new function? It can be anything but the name you give the module.

[RuralGuy]

Diane,
I have to leave in about an hour and need to get ready. Can we take this up again tomorrow?

[diane802]

Yes thank you!!

[RuralGuy]

Are you ready to get started again? How about the answer to the question in post #26?

[diane802]

Sounds great - let's call it.... Disclosures