Recent content by dubczech

the field where the 3 letter month data is currently a text field. Do I need to change this? I did a quick query with the code below, and it brought over the 3 letter month into a 3 letter month, and when sorted, it sorted alphabetically. What have I missed?

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?

Can anyone else assist?

Correct. I think you can still have a relationship set up without a primary key.

I dont' have primary keys set up for either table.

Nope. That didn't work.

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"...