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...
hi guys,
What i am looking to do is similar to a IF statement in excel. I have a row of data with numbers. I need to add a row that will tell me what these numbers are based on the numbers. for example if a number is between 1-1000 its a new , 1001-2000 its used. Is this something easily done...
Thank you Plog, so for my tables you are saying i should remove the admin and data and create a totally new table for that? so i would then i have 3 tables? One that is for that and the other 2 which is GAP sales and GAP Claims. Sorry for my ignorance has im very new at this.
Thanks for the reply sir. So when you say add field at bottom you are referring to this below picture? If so how where do i go to make the changes to the make to ensure for example ford is listed as domestic while BMW is listed as European. For example in excel i would just have each make...
Hi all,
What I am trying to do is create anther data field from data I have in my table. For example I have Vehicle Make as a data point and I wanted to use this field and add domestic ,European or Asian based on of course what brand the vehicle is. The goal is to run queries based on what...