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 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
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
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 This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
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
|
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...
|
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...
|
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...
|
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,...
|
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...
|
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...
|
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...
|
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,...
|
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...
|
by: ryjfgjl |
last post by:
ExcelToDatabase: batch import excel into database automatically...
|
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...
|
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...
|
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...
|
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...
|
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...
|
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....
|
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...
| |