Search results

MapInfo will also work with access by odbc-connection

There are probably a lot of tools that can do this; here are two I know Open source or commercial Open source: MapWindow (for example click here) Commercial: MapX by MapInfo

Karma wrote: Does Dolly Parton sleep on her back?

Italy is very nice! The weather is good, and there are lots of nice cities. Ofcourse Rome has got a lot to offer (collosseum, Forum Romanum, Vatican City, a lot of museums). I liked the region "Toscane" very much, there are a lot of nice places there as well: Florence, Perugia, Sienna, San...

IF(A2=A1,IF(B2-B1>90,"OVER 90 DAYS","DUPLICATE ENTRY")," ") if a2 = a1, it will check wether B2-B1>90, if so it will give "over 90 days", if not, it will give "duplicate entry" if a2 <> a1, it will give " "

i think you can put something like this iif(a*12+b<h,Yes,No) in the criteria of that Y/N field in the query design page

What should happen when option 3 is TRUE?

Go to the design view of your query, at the top of the view you'll find your tables... double-click on the line that links them, there you'll find the Join Properties Rickster57 was talking about... StevenS

Very Nice! Is there a way to open the form with the access environment to take a look at the code you used? Steven

i'm not sure but maybe this helps... SELECT TblLine.LineID, TblLine.LineType, TblLine.LineDim, TblLine.LineShape, FctConvertInch([LineDim],[LineShape]) AS Conv FROM TblLine GROUP BY TblLine.LineID, TblLine.LineType, TblLine.LineDim, TblLine.LineShape; i think you can't use an...

Please show the queries/SQL you used

I think something is wrong with the quotes in the first part of the iif-statement Maybe try something like IIf(CERS_Price_currency = "USD",[Trade].[CERS_Price]*[Market].[USD/EUR_Rate] , 0) AS [Price In Euro] HTH, Steven

I work with GIS as well. During my studies i used Esri (Arc) products. Now i work more with MapInfo. Access can be used for GIS-purposes. For example in MapInfo you can link your geographical information to access tables. So you can do the geographical analysis in the GIS-system and store the...

Solution? I think this is the solution. First i tried to solve the partnership part, then i switched the teams around untill i came up with this one: (can someone check if it's correct?) Round 1: 1&2 vs. 5&6; 3&4 vs. 7&8 Round 2: 1&3 vs. 2&4; 5&7 vs. 6&8 Round 3: 1&4 vs. 5&8; 2&3 vs. 6&7 Round...

I just use the help files that are connected with the F1 key. If i am searching for the functions that i need, i only seem to find worksheet functions, and can't find the access (or sql?) equivalent

With the ISNUMBER worksheet function i am getting the same message again: undefined function 'isnumber' in expression Is this also a vba keyword? or have i got another problem now? :) Steven

Thanks very much for your time i'm very grateful Steven

Thanks. does this mean that i can't use any of the functions that ms access help describes as worksheet-functions? (for example the IRR_worksheetfunction) Steven

the message given is: undefined function 'if' in expression

SELECT [Town Data].X, [Town Data].Y, [Town Data].Country, [Town Data].Place, [Town Data].Pop2004, If([town data].[pop2004]<[town viability table].[priority 3],"notviable") AS ["Not Viable"] FROM [Town Data] INNER JOIN [town viability table] ON [Town Data].Country = [town viability table].Country;