syntax for combining text fields and formatted date fields;

D

diros

What is the syntax for combining text fields and formatted date fields,
presumably within an update query. Example: d
Code: 
m is the result of combo
field to look like 25p139 when date field was 9/25/05 and text field was p13.
Field names are [datefield], [codefield] and [combofield].

I wish to use combofield in a report so if it is easier to make the
combination in the report, rather than plucking combofield from query to
insert into report, please advise.

I use access 2000 in xp environment and have limited capability in
programming language. If you could write precise syntax for query update that
I could paste into a query, same would be reatly appreciated.  Same courtesy
would be appreciated if it is could be done in a textfield that I create in a
report.
 
J

Jeff Boyce

There may be some confusion in your use of the term "combofield" -- some
might interpret that as an Access combobox. I assume you mean "a field
which is the combination of other fields".

You can derive (i.e., calculate) the day and month of a date field value in
a query, using the Day() and Month() functions. To concatenate (?your
"combining") fields or portions of fields, create a new field in your query
something like (your syntax may vary):

NewField: Day([YourDateField]) & [YourCodeField] &
Month([YourDateField])
 
Top