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'm sure I am doing many things wrong, this is my first database. I will continue to work this out. Thanks for your help.

It was my best guess.... We need a sheepish grin smiley on here :) I am still getting the enter parameter value error, it says TrvlTbl.Days Btwn. That is the table that loads some stuff to the form and then we will input the other information in the form to update the table. I don't have a...

First it said that I was missing a para so I made it: =IIF(IsNull([Check Date])), Null, DateDiff("d", [Approved Date], [Check Date]) Then it said I have the wrong number of arguments.....

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?

In my formula the Approved Date will always be there. The Check Date is something that will be put in later.

=DateDiff("d",[Approved Date],[Check Date])

Oh; only one of my dates for the formula is in there on some of the records. I can just click through the message and get to my form. Will that be bad?? (classic newbie!! sorry!)

Ok, so I am not going to store the DateDiff in my table because it is on the form and I will create a seperate query to get that information. My question now is I have an unbound box on my form that calculates the DateDiff but everytime I go to open my form I get a message to enter parameter...

How do I Query a form? I was told not to use the DateDiff function on my table.

But I need the difference to be stored so I can create reports off of that piece.

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 finally got this to work. I put the DateDiff in the control source for my text box. Thanks for everyones help!

I finally got this to work. I put the DateDiff in the control source for my text box. Thanks for everyones help! :)

Sorry for the repost, I still can not get this to work.

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

From what I can see my box names are Days Btwn, Approved Date and Check Date. I have tried plugging those into your formula and it doesn't work.

So I am sure this is an ID10t error but ugh.... What do you mean by textbox control? Sorry, I am really new and obviously don't have much of a clue.

I tried just the =DateDiff("d",[Approved Date],[Check Date]) and the Me.textbox=DateDiff(...)

I'm so sorry, I am sure this isn't as hard as I am making it.... Putting that formula in the AfterUpdate isn't working.