473,320 Members | 1,766 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Oracle Person Needs help with MS Access Queries

Hi

This may be a really easy answer for you! I usually work with Oracle
but have an Access project to work on.

I have a table of clients (name, addr1, addr2, addr3, pcode etc) which
I need to use as a basis for a query result set which will include
literal values for an accounting package.

The way I do this in Oracle is:

select tabname.col1,tabname.col2,tabname.col3,tabname.col 4,"28 Days
From Receipt of Invoice","500","4027 Unrestricted
Income",tabname.col5,tabname.col6
from tabname
where tabname.col7=sysdate;

How do I put the literal values into an Access query?

Thanks for your help

Karen
Nov 12 '05 #1
3 1730
"Karen" <ka***********@dsl.pipex.com> wrote in message
news:c1**************************@posting.google.c om...
Hi

This may be a really easy answer for you! I usually work with Oracle
but have an Access project to work on.

I have a table of clients (name, addr1, addr2, addr3, pcode etc) which
I need to use as a basis for a query result set which will include
literal values for an accounting package.

The way I do this in Oracle is:

select tabname.col1,tabname.col2,tabname.col3,tabname.col 4,"28 Days
From Receipt of Invoice","500","4027 Unrestricted
Income",tabname.col5,tabname.col6
from tabname
where tabname.col7=sysdate;

How do I put the literal values into an Access query?

Thanks for your help

Karen

Use the word AS to alias the field:

SELECT tabname.col1, tabname.Col2,
245 AS SomeNumber, "Hello" AS SomeText
FROM tabname
WHERE tabname.col7=Date()
Fletcher
Nov 12 '05 #2
If I understand your question correctly, you just need to alias them so that
those fields have names:

select tabname.col1,tabname.col2,tabname.col3,tabname.col 4,"28 Days
From Receipt of Invoice" AS Title1,"500" AS Title2,"4027 Unrestricted
Income" AS Title3,tabname.col5,tabname.col6
from tabname
where tabname.col7=Date();

Note that I've also changed the Oracle sysdate to the Access Date().

HTH
- Turtle
"Karen" <ka***********@dsl.pipex.com> wrote in message
news:c1**************************@posting.google.c om...
Hi

This may be a really easy answer for you! I usually work with Oracle
but have an Access project to work on.

I have a table of clients (name, addr1, addr2, addr3, pcode etc) which
I need to use as a basis for a query result set which will include
literal values for an accounting package.

The way I do this in Oracle is:

select tabname.col1,tabname.col2,tabname.col3,tabname.col 4,"28 Days
From Receipt of Invoice","500","4027 Unrestricted
Income",tabname.col5,tabname.col6
from tabname
where tabname.col7=sysdate;

How do I put the literal values into an Access query?

Thanks for your help

Karen

Nov 12 '05 #3
Tom
On 6 Feb 2004 03:22:57 -0800, ka***********@dsl.pipex.com (Karen)
wrote:

Well, pretty much the same way you do in Oracle, if your in Queries >
View > SQL View

SELECT tabname.Col1, tabname.Col2, tabname.Col3, tabname.Col4, "28
Days
From Receipt of Invoice" AS Expr5, "500" AS Expr6, "4027 Unrestricted
Income" AS Expr7, tabname.Col5, tabname.Col6
FROM tabname
WHERE (((tabname.Col7)=Date()));

if your in Queries > View > Design View
Expr6: "500" in the Field: row of the query grid will do.

Tom
Hi

This may be a really easy answer for you! I usually work with Oracle
but have an Access project to work on.

I have a table of clients (name, addr1, addr2, addr3, pcode etc) which
I need to use as a basis for a query result set which will include
literal values for an accounting package.

The way I do this in Oracle is:

select tabname.col1,tabname.col2,tabname.col3,tabname.col 4,"28 Days
From Receipt of Invoice","500","4027 Unrestricted
Income",tabname.col5,tabname.col6
from tabname
where tabname.col7=sysdate;

How do I put the literal values into an Access query?

Thanks for your help

Karen


Nov 12 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

100
by: Peter | last post by:
Company thought DB2 will be better than Oracle. The bottom line is when you do select, the system crash. I think it may take 4-5 years for DB2 to reach Oracle standard. Peter
3
by: Jon Ole Hedne | last post by:
My Access 2002-application need to work with tables from both Oracle and Access. To solve this, I want to run some querys on three views in Oracle and import the results into temporary...
8
by: Alfonso Esteban Gonzalez Sencion | last post by:
I am trying to use Access as a front end for extracting information from an Oracle database. I started using linked tables but I am getting a very curious behaviour. When I consult the linked...
1
by: girlkordic | last post by:
I have a linked table from an Oracle database (that contains HR information for my company)in an Access database. The Oracle DB is updated on a daily basis. I would like one of my tables in...
1
by: s-dogg | last post by:
If anyone has seen this before, please help. I work at a company that has an Access application front end attached to tables in an Oracle 10g backend. In order to run our application this way,...
9
by: AnandaSim | last post by:
Hi All, I've had Access 97, 2000 connections to the corporate Oracle database for a few years now - but seldom use it. When I did use it years ago, performance was not fast but the features were...
2
by: egoldthwait | last post by:
I need to convert a 17mb access 2000 db to Oracle and house it in a Citrix farm. The issue: we have never converted an Access Db to Oracle but can probably use Oracle's Workbench to assist with...
42
by: Paul | last post by:
Anyone know where I can find some good resources to help us choose between SQL and Oracle ( Progress Openedge as well ) . Any comments on what you would choose ?? We are creating a new Warehouse...
5
by: jonceramic | last post by:
Hi All, I started developing in Access, and people took notice and so we're starting to migrate into our corporate's bigger Oracle system. I'll still be using my developed Access front ends,...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.