Combining Intials and Date to make an ID

[Guest]

I am running a query for a project database i am creating. The columns run as
follows: Project Name, Project Manager, and Bid Date. This is what i what i
started JobNo: Left([Project Manager],3)+left([Project Name],3)+Year([Bid
Date]). Right now i am getting an error, what am i doing wrong?

 

[Guest]

I think that this is what you are looking for

Left([Project Manager],3) & left([Project Name],3) & Year([Bid
Date])

 

[Guest]

There are a couple of possibilities but not know what the error is, or what
version of Access you are using, I will take a stab with one of them.

You are using the "+" Operator as a concatenation operator. This will work
in VBA but Jet is attempting to add the fields together to come up with a
sum. You need to use the correct cocatenation operator, which is the
ampersand "&"

Your calculated field should look like this:
JobNo: Left([Project Manager],3) & Left([Project Name],3) & Year([BidDate])

 

[Guest]

Thanks guys, that helped alot

 

[Guest]

You welcome, have a good weekend
--
If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benefit from it.

Good luck

Thanks guys, that helped alot

I am running a query for a project database i am creating. The columns run as
follows: Project Name, Project Manager, and Bid Date. This is what i what i
started JobNo: Left([Project Manager],3)+left([Project Name],3)+Year([Bid
Date]). Right now i am getting an error, what am i doing wrong?