Search results

So will it look like this?? Select * from T1 FULL JOIN T2 ON ((T1.city=T2.city) AND (T1.county=T2.county));

Hi Everyone, How I can write a query and pull values from 2 tables having different number of columns and having no primary key. I tried using SQL UNION ALL command, but his brings me only the common columns. My requirement is i need to pull all the columns from 2 tables for a particular query...

Two tables are having some 55 fields each and some 6 in common. I am using this 6 as the input criteria in a query form to bring up all the other fields from both the tables. This is my main aim.

I am having two tables dbo_hpr and dbo_bridges. Only some of the columns in dbo_hpr are matching with dbo_bridges, SQL UNION ALL query only brings up the values that are common in both the tables. But I need to show all the values from both the table. So how shall I write the query to bring all...

I was trying to pull down values from two tables Dbo_Bridges1 and dbo_hpr using a query form named Prop_Bridges. Dbo_Bridges1 - gives information about the bridges in a particular area dbo_hpr - gives the property information in that particular area What I need to do is : If I select a...

In my query form, what is the Record Source I have to give?? Since it is taking values from two tables, should I have include both the table names in the record source???

Else is that possible for you to connect remotely and work on it? I even can't share the file bcos of its huge size(around 160 mb)

My combo's are having numeric value in it. I have used a small look up table like below one CountyName|CountyCD Oklahoma 12 Payne 13 I didnt know that these values will be concatenated. I assumed that it will check both the conditions. Else how about using this...

The field COUNTYCD in both the tables contains numeric value and yes there are some null values.

COUNTYCD is the field that contains the numeric values of all counties. And I have used in the below query. SELECT dbo_hpr.ADDRESS, dbo_hpr.PROPNAME, Dbo_Bridges1.CITY, Dbo_Bridges1.ADDRESS FROM Dbo_Bridges1 INNER JOIN dbo_hpr ON Dbo_Bridges1.[COUNTYCD] = dbo_hpr.[COUNTYCD] WHERE...

I was trying to bring down values from two different tables that have County(Numeric field) as a common field. But i am getting this error, Run time error "3615", type mismatch in expression. I donno wat is the reason. Here is the snipet of my query, SELECT dbo_hpr.ADDRESS, dbo_hpr.PROPNAME...

I tried using the code below but I cannot figure it out why it isn't working. So here I have attached a sample file called Database6. So the requirement here is when I open the datasabe6, it should directly open the form with all the menu bar and tool bar hidden. Can you just re-attach the file...

Hi John, I tried using the code above but I cannot figure it out why it isn't working. So here I have attached a sample file called Database6. So the requirement here is when I open the datasabe6, it should directly open the form with all the munu bar and tool bar hidden. Can you just re-attach...

Hello everyone, In MS Access is that possible to bring only just the forms opened when the corresponding DB file is opened? that is if a end user opens the db file, it should directly open the form on which they are going to work. All the menu and the tool bar should be hided when they open. Is...

Hi Plog, I will clearly explain the proble, consider the following table CountyID CountyName 109 - 156 - . . . This goes...

Hi everyone. Is that possible in access for recoding the values in a table? That is I have a field called County in my table which is in number format. But each of these number refer to one county, example Adair = 112, alfalfa = 156 etc. So now I have to create a new column named CountyName...

Hi everyone, When I was working with my DB, I am forced into a situation to change my data type size, but when I tried to do so it gives the following message," Microsoft Access can't change the data type : There is'nt enough disk space". But I got lot of free disk space. I simply dont get it...

Can you please elaborate? I didnt get what are trying to say??

Here it is, In my query form i have a field called County, its a combo box and it contain the several values like Adair, alfalfa etc. so the user will be selecting one of this value to perform query operations. But here comes the problem, in the table where these values are stored they are...

Hi, I am wondering how one will set criterian for combo boxes? that is for text boxes we use this, where qprop is the text box. If county is in a combo box what the criterian would be? Like [Forms]![SearchForm].[qprop1] & "*" Thanks!