Access Query

Topic

New Reply

I am having one of those days already, can anybody remind me how to merge data from two fields into one in my query.

eg I wish to join wt = “AA” “/” job = “00505”
wish to create contract “AA/00505”

Reply | Quote

Replies

Try it like this:

wt = “AA” & “/” & cstr(job)

I assumed that ‘job’ is a field or a variable that has the value “00505”.

Reply | Quote

Thank you very much for that Bart, worked a treat, I had a mental block.

Cheers have a good day.

John

Reply | Quote

Glad I could help.

About that good day, it is a public holiday over here, the sun is shining bright, trafic queues to the beach solved and ……
I have to work, we are doing an euro conversion these days, that is a lot of waiting and waiting.
We arranged a pc with dvd player, a beamer, a set of could speakers and about 20 movies on dvd. Think we’ll survive…

Reply | Quote

>>Think we’ll survive…

The conversion, or the euro itself?

Reply | Quote

I hope both, that

Reply | Quote

Hallo Bart,

I read you have done an euroconversion. I hope it was also in Access.
Actually a customer of us has an Access database with a field that contains currency in NLG. He wants to convert these to euro’s but keep the history in NLG. I think the only solution is adding a column with the euro in it (based on the column for NLG).
Do you have some suggestions?

Anouk
Nederland

Reply | Quote