Search results

I need a field that I would like to create as a date field, however this needs to hold only the month, and the month has to show as a 3 letter abbreviation (APR, MAR, JUL, NOV, etc.). I will need to have this sort (so MAR comes before JUL) by the order of the month. Any ideas?

So I'm creating a new db from scratch (basically transitioning a massive excel sheet into access). It is a Property Database. with Site #s, addresses and more standard fields like those. I've got a couple things working correctly, but there is one field that is only maintained in the excel...

Database "A" is populated every morning out of another system. In my database, I have linked to Database A. Database B contains 15 fields, 8 of which are on Database A. I would like to have Database B populated by Database A. I have designed an Append Query to append the field "fac_nbr"...