Jet-SQL is an SQL dialect used in Microsoft Access.
Questions tagged [jet-sql]
61 questions
0
votes
2 answers
Can you use two SET and WHERE Statements instead of ELSE in Access SQL?
I am trying to use two SET and WHERE Statements in place of an ELSE Statement. Is that possible? I am getting a syntax error on the following:
UPDATE HRBI
SET HRBI.[MktDISC%] = 0, HRBI.[MktDISC%] = (HRBI.[MarketMedianDISCUSD] /…
Chris2015
- 1,030
- 7
- 28
- 42
0
votes
1 answer
Syntax error on a LEFT JOIN of two tables
I am trying to update a table (HRBI) with a LEFT JOIN on another table. I am getting a syntax area on the following script:
UPDATE HRBI
LEFT JOIN REMMINC ON (HRBI.[PayGroupCountryDesc] = REMMINC.[REMCountry]) AND (HRBI.[BusinessLvl1(Group)Code] =…
Chris2015
- 1,030
- 7
- 28
- 42
0
votes
1 answer
Update a column based on a JOIN between two tables
Can you update a column in a TABLE based on a JOIN of two tables? Here is the code I have. I am getting a syntax error that says
Syntax error (missing operator) in query expression "Y" FROM HRBI LEFT JOIN Section16 ON HRBI.WorkerID =…
Chris2015
- 1,030
- 7
- 28
- 42
0
votes
1 answer
Update data using SET / WHERE statements
Is there a way to update these records using a WHERE statement?
UPDATE HRBIQuery SET HRBIQuery.PaySegmentMultiplier = '1.35',
HRBIQuery.PaySegmentMultiplier = '1.25', HRBIQuery.PaySegmentMultiplier = '1.15',
HRBIQuery.PaySegmentMultiplier =…
Chris2015
- 1,030
- 7
- 28
- 42
0
votes
1 answer
How do you UPDATE twice within the same query?
I am trying to use UPDATE twice within the same query to revise my TABLE data. Can you explain how I do this? I am getting a sytax error on the following code:
UPDATE HRBI SET HRBI.PayGroupLocationPayGroupCountryCode =…
Chris2015
- 1,030
- 7
- 28
- 42
0
votes
0 answers
Create SQL String in Microsoft Access Dynamically
I apologize if this is an easy one, but I can't find this on the web anywhere!
I have a list of tables and queries, and a full list of fields from each table and query.
I want to choose my fields in an Access form, and then, on another form, choose…
David
- 21
- 6
0
votes
2 answers
MS Access select .. into statement disordered
In an MS Access 2010 application, I use this SQL statement:
SELECT myTable.field1, myTable.field2, ...
INTO temporaryTable
FROM myTable
ORDER BY myTable.field4, myTable.field3
The order of the records in temporaryTable often are not according to…
peter_the_oak
- 3,529
- 3
- 23
- 37
0
votes
0 answers
Ordering Dates Correctly in JET SQL - Access 2010
Ok, quite frustrated trying out different options, need some suggestion.
I have tried to create a sort of ROLLUP, CUBE query in JET-SQl and everything is working as expected except the correct ordering of DATE field.
SELECT
CDATE(FORMAT(P.[START…
Youbaraj Sharma
- 1,295
- 3
- 17
- 34
0
votes
1 answer
JET SQL for Access 2003
I have the following SQL statement:
Select Choose(1,Orders.Employee, Orders.Customer) as Name1,
Choose(2,Orders.Employee, Orders.Customer) as Name2, [Shipped Date]
FROM Orders;
However, the field "[Shipped Date]" has a space in it and hence why I…
Abs
- 56,052
- 101
- 275
- 409
0
votes
1 answer
Access update query unable to update specific records
I have a table with a column of ping-able computer names that is given to me as part of a larger table. The computer names may contain a dotted domain name and/or be an IP address. I need to separate out the computer name and domain name into…
mjoshawa
- 115
- 8
0
votes
3 answers
Table aliases and field names with spaces
From SAS, I am updating a table in MS Access with values from another table. Some of the fields in the table being updated contain spaces. This seems to be causing problems in the update statement. This gives me the error "Too few parameters.…
attitude_stool
- 1,023
- 1
- 13
- 18
0
votes
2 answers
How to give where condition in the select query?
How to give where condition in the select query?
ACCESS 2003
MY Query
SELECT RECORDNO, PERSONID, EMPNAME, TITLENAME, DEPARTMENT, NATION,
CARDEVENTDATE, INTIME, OUTTIME, (select TOP 1 F1.CARDEVENTDATE from
tmp_cardevent as F1 where F1.RECORDNO <…
Gopal
- 11,712
- 52
- 154
- 229
0
votes
1 answer
"Expression is typed incorrectly, or it is too complex" error - Access 2007
As the question says, I get this error whenever I try to run my query.
I have 3 fields I want to search in each table, an OEM code, models and additional search terms.
Here is the SQL:
PARAMETERS [Search] Text ( 255 );
SELECT *
FROM inkSearch
WHERE…
Ryan Buddicom
- 1,131
- 15
- 30
-1
votes
2 answers
Sql - return value for EVERY thing being searched in select command, even if repeated, or doesn't exist
As the title says I want to run a select statement to return 1 value for each item searching with. I will provide a simple example for this.
Lets say that my table is the following:
table1
Mdl Code
Model Model Code
M1070 32HT
M1060 …
Eric F
- 899
- 2
- 21
- 45
-1
votes
1 answer
convert jet-sql access column calculated into sql server
how to convert this calculated column ACCESS in my sql server column?
([VratePctg] < 0.05) Or (Abs([Amount1]) < 1) Or (Abs([Amount2]) < 1)
Thank you
sebyrock
- 29
- 6