Combine date field and text field question

  • Thread starter Thread starter rblivewire
  • Start date Start date
R

rblivewire

m/d/yyyy;;;"N/A"

I am trying to combine a text field and a date field. I need either NA

or TBD in the blank rows of a date column. Besides thte above format,
is there any format that you can input so instead of N/A, the user can
choose what they want to put.
 
Sorry about that but a datetime field can only have dates and times.

What you can do is in your query, form, or report put an IIF statement like --

Date Display: IIF([YourDateField] Is Null, "TBD",
Format([YourDateField],"m/d/yyyy"))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Combine date field and text field question 3
Text to date format? 0
Is it posible to have a date/text field in an access db 5
Combine Text Fields 3
Excel Help with dates 2
Insert into (dates format) VBA 6
Date Formatting 1
Access 2007 Date field shows Now instead of Date 4

Back
Top