I have an ACCESS db with two tables I would like to JOIN in several queries. Ignore the other tables in the container.
Table-1, Meters_tbl, columns: M&S_Code, M&S_Description, Svc_Type, etc....
I have a query that calculates the average result for 2 students for each question writing a pretest and a post-test. I want to now calculate the difference between each question's average. I'...
Hi Everyone,
I have a table that has the following information dbo.Contents.Rows, dbo.Contents.Columns, dbo.ContentID
for example Content ID = 1 has Rows = 8 and Columns = 12
I want...
Hi,
The following Sql statement rounds the amount and not displaying the real data entered.
Select CineID,convert(Varchar,[Date Received],101) [Date Check
Received],convert(decimal(10,...
I am looking to alter my trigger as so that it only inserts when a date in another table is less than the todays date,
where do i put this in the trigger?
I have an access table and I want to run the following sql commnad:
select count (distinct field) from table
In ms sql 2005 it works fine but not with access sql
I Have an mssql query with following condition
AND
(
((ADDDATE(SYSDATE(),INTERVAL -30 DAY) > ChdBdate1 AND ADDDATE(SYSDATE(),INTERVAL -500 DAY) < ChdBdate1) ) OR
((ADDDATE(SYSDAT...
I need to Identify the unique rows and put the number of times they are duplicated next to them.
I have tried the following from your existing response to another fellow:
SELECT cust_name,...
Using SQL code, can someone tell me how I can copy the structure and data from one table in one database to another table. How do I do that in SQL.
Currently we have a view that returns results such as the one below:
Code CampName Name Value Id
------- -------------- ----------------- ...
I'm running a query against one of our tables.
Select Distinct ColumnName From Table. (SELECT DISTINCT FULLERROR
FROM [DMS].[dbo].[SD_LOGDATA])
When I run this command it produces the error...
SELECT Employee.FirstName , Employee.Dept ,
Emp_Time_Track.No_Of_Hrs_Spent , Emp_Time_Track.Status, Project.Project_Id, Project.Project_Nm ,
project.convert(varch...
I have a select query which works fine.
but I want toe exclude a result where catid = 126 How do I do this.
SELECT * FROM categories WHERE Parentid = 0 AND ORDER by catname
I would like to display information from the tbl_Pass table based on a value from the tbl_Ship table. This will occur multiple times in my ASP page.
I have a view_ship.asp request that dis...
Afternoon all,
Two tables:
Students:
----------------------------
ID Name
0 Student1
1 Student2
2 Student3
StudentActive
----------------------------
StudentID IsActive
0 True...
I have entries in a table as:
ServerID DecomDate DecomNumber Comments DateChanged ChangedBy
81 8/6/08 20:07 na Comment Entry 10/28/2008 USER1
140 9/15/08 18:00 1812040 Comment Entry 10/28...
HI
I need to add records to an Access table using "Insert to" sentence, the point is that one of the fields needs to have a progresive value per each record, starting with a number previous...
Hi there,
i have the following request but not sure how to code it:
The report should contain accounts where the date of last invoice (DATELASTIV) is within 31 days of the current date a...
Please take a look at the attached SQL query. I need to update MASTER6.SSN = secaccessmerge.SSN where L__d__bName matches in both tables AND where MASTER6.Desired__bAction = "Physician'
Do ...
Hi all,
I am trying to test for the existence of a column within a table. The reason for this is we have two different versions of our gaming system 1 of the versions has the column wherea...
Im writing a query to compare addresses from two tables and keep only those that fit certain criteria. The tricky part comes in grabbing different pieces of data from different tables. Specifi...
I have a real easy one. I nee the SQL syntax to update the msrp field. I want it to be 110% of the price field.
I have one table that I have turned into 2 tables. I have assigned aliases to the tables. So I have t1 and t2. There is one field in the tables that I have combined in a case statement to m...
suppose we have two tables as follows
DEPARTMENT
DEP_CODE,DEP_ PERIGR
------------------
100 ,EDP
200, MARKETING
300, SALES
400, PRODUCTION
EMPLOYEES
----------------
EMPL_CODE, ...
I have a Report that I attached a Access query but I need to turn the query into code(SQL query). I am attaching a test file. Cant not get the syntax right.
The report name is SQL_Report...
