Search results

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

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

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

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

Hello all, Excuse me in advance as I am very green with access. What I am trying to do is get my query to only show results if the filed name contains one or the other name I am specifying I presently have it as. Criteria: Like"*Honda*" Like "*ford*" the logic only pulls in...