Search results

I have a table where I will be loading data from excel and I have an append query to move that data to another table. Is there a way to make the append query only add the new data from the first table? Or do we need to clear out the transition table before we run the append query?

I am getting this error when trying to load my excel spreadsheet into access. I am only getting it in on a column that is multiple choice on my table. The spreadsheet that I am going to load from will always have that column blank as it will be input later. What can I do about this?

Now that my DateDiff formula is working I would like that information to populate in my table. I have tried it with a bound box and it isn't populating.

I am trying to get DateDiff to work on my form again.... I have an approved date and check date, I need to know how many days total are between those two dates. The approved date will always be populated by what I load into my database and the check date will be put in at some point later. I...

Hi All, I am still learning and need help!! Can I use the DateDiff function in a table? I have the formula: DateDiff("d",[Approved Date],[Check Date]) but when I try this I get a message that it doesn't recognize Approved Date?? What am I doing wrong?? :eek: