Hi guys,
anyone know what this error message means. I am just trying link a excel spreedsheet into access. I have done it before with a similar file no issues but i tried doing it with a blank database and one that i have a lot of data on and getting the same message
Hi guys,
the title kinda describes what is need. Is is possible to do this? I have a query I ran with data. Theres a field called "LTV". I need to replace the data from this field to a table I have created. the table also has a LTV field. I have a common unique identifier to do the lookup on if...
think i was very much overthinking this, i think taking the date diference and simply divding it up 90 should work but i would need to round up.
What would be the best approach to have this all in one field. Right now I have my date difference calc as Date_Difference: GAP_Claims_new.[Claim...
wow thank you so much, so im obviously very green here. This code is inputed into where? surely not the builder? Guessing into the SQL module? if so would this goto into a table? or querey?
Thanks for the advice, always open to any feedback. So in terms of the quarters issue. I guess to be clear its not actual quarters like wha
t you are referring to. Each of the contracts will have a date in which the sale was made and a claim was made, the difference of those 2 fields will tell...
Thanks guys, so i have a table recorded but am struggling on how i would join it. You see what I have right now is a query which has 2 dates and the difference between them. Based on what that returns I want to be able to put that number in a quarter. Not sure if that makes sense. Table and...
hi team.
I am trying to input basically a long if statement. I have 28 total scenario and after typing them out it seems as access cannot handle this many?
Here is the formula typed . Essentially based on the number they will belong to a certain quarter. I believe access lets be input up to...
Hi all,
I am trying to simply find the difference between 2 dates in my querey. I want the result to be listed in days
i presently have it as
Difference: DateDiff('d',[Claim Entered Date]-[Sale Date Ky],Date())
but this is not yielding the correct results. Anyone know what I am doing wrong...
Thanks but is switch a function in access or excel?
this worked great Iif(Val([Sale Odometer] & "") < 1001, "New", "Used")
but if i need to append this to have it tiers i guess, so 0-1000 new, 1001-2000 mid, 2000> used. Something like this in access
Thanks for this info, what if I need to add multiple expression to the statement. something like if between 0-1000 new, if between 1001-2000 mid, if 2000-3000 used, if >3000 , unstable.
Something on excel would look like...
Thank you for this, you are right and not nitpicking, i need to learn the access lingo so please correct me along the way. The end goal is to have this information described be used in a trend analysis. This is just one of the pieces we will be using. I suppose the best option is to correct a...