Oracle Person Needs help with MS Access Queries

[Karen]

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,ta bname.col2,tabn ame.col3,tabnam e.col4,"28 Days
From Receipt of Invoice","500", "4027 Unrestricted
Income",tabname .col5,tabname.c ol6
from tabname
where tabname.col7=sy sdate;

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

Thanks for your help

Karen

[Fletcher Arnold]

"Karen" <ka***********@ dsl.pipex.com> wrote in message
news:c1******** *************** ***@posting.goo gle.com...

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,ta bname.col2,tabn ame.col3,tabnam e.col4,"28 Days
From Receipt of Invoice","500", "4027 Unrestricted
Income",tabname .col5,tabname.c ol6
from tabname
where tabname.col7=sy sdate;

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=Da te()
Fletcher

[MacDermott]

If I understand your question correctly, you just need to alias them so that
those fields have names:

select tabname.col1,ta bname.col2,tabn ame.col3,tabnam e.col4,"28 Days
From Receipt of Invoice" AS Title1,"500" AS Title2,"4027 Unrestricted
Income" AS Title3,tabname. col5,tabname.co l6
from tabname
where tabname.col7=Da te();

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.goo gle.com...

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,ta bname.col2,tabn ame.col3,tabnam e.col4,"28 Days
From Receipt of Invoice","500", "4027 Unrestricted
Income",tabname .col5,tabname.c ol6
from tabname
where tabname.col7=sy sdate;

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

Thanks for your help

Karen

[Tom]

On 6 Feb 2004 03:22:57 -0800, ka***********@d sl.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,ta bname.col2,tabn ame.col3,tabnam e.col4,"28 Days
From Receipt of Invoice","500", "4027 Unrestricted
Income",tabnam e.col5,tabname. col6
from tabname
where tabname.col7=sy sdate;

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

Thanks for your help

Karen