Query ???

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm familar with access, but with this new job, I deal heavily with access
databases and queries. I acquired the previous database administrators
position and am playing detective work on how to get certain queries to run.
My question is complex, so I will tell you the steps I have taken.

I have a make table query that creates a table called Arm Febuary.
I then create a query called Arm 2-2005, based off of the newly created table.
I then create a new query called ARM details that has the following code:

Account: badlapp!Lpacct &"-"&Format([Arm 12-2004]![dtcyc#],"000"))

I know that I need to change Arm 12-2004 to the newly created Arm 2-2005,
but when I do, it asks for a parameter and just stalls out. When I run it
with the above code, it runs fine. Can you help me out with this.
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Since Arm 2-2005 is a table, it must be in the Table part of the QBE
screen. You probably still have table [Arm 12-2004] in the Table part
of the QBE screen. Here's how to replace the table w/o screwing up the
query:

1) Right click on the table [Arm 12-2004] and select Properties.
2) In the Properties dialog box, Alias box, enter the word "Arm"
(without the quotes).
3) Switch to SQL view (menu bar: View > SQL View).
4) Find the FROM clause and replace [Arm 12-2004] with [Arm 2-2005]
5) Switch back to Design view (menu bar: View > Design View).
6) Test.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQlRAe4echKqOuFEgEQJS7QCg/rVP1TnnYbOIqWEuO9mD0o08nkYAn3OU
Njvc8jz2/KdEf8ojq8ItNn5U
=g+Ot
-----END PGP SIGNATURE-----
 
This didn't work. ARM 2-2005 is a Query, not a table. Another question, when
it asks me for a parameter, can I list certain numbers I want it to cycle
through, for example: 001 - 019? Is there any thing extra I need to do when
it asks me for the parameters?

MGFoster said:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Since Arm 2-2005 is a table, it must be in the Table part of the QBE
screen. You probably still have table [Arm 12-2004] in the Table part
of the QBE screen. Here's how to replace the table w/o screwing up the
query:

1) Right click on the table [Arm 12-2004] and select Properties.
2) In the Properties dialog box, Alias box, enter the word "Arm"
(without the quotes).
3) Switch to SQL view (menu bar: View > SQL View).
4) Find the FROM clause and replace [Arm 12-2004] with [Arm 2-2005]
5) Switch back to Design view (menu bar: View > Design View).
6) Test.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQlRAe4echKqOuFEgEQJS7QCg/rVP1TnnYbOIqWEuO9mD0o08nkYAn3OU
Njvc8jz2/KdEf8ojq8ItNn5U
=g+Ot
-----END PGP SIGNATURE-----

I'm familar with access, but with this new job, I deal heavily with access
databases and queries. I acquired the previous database administrators
position and am playing detective work on how to get certain queries to run.
My question is complex, so I will tell you the steps I have taken.

I have a make table query that creates a table called Arm Febuary.
I then create a query called Arm 2-2005, based off of the newly created table.
I then create a new query called ARM details that has the following code:

Account: badlapp!Lpacct &"-"&Format([Arm 12-2004]![dtcyc#],"000"))

I know that I need to change Arm 12-2004 to the newly created Arm 2-2005,
but when I do, it asks for a parameter and just stalls out. When I run it
with the above code, it runs fine. Can you help me out with this.
Click to expand...
Click to expand...
 
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Queries (Views) and Tables are treated the same in a query definition:
as a data source. Read a book, or the Access Help, on Tables and Views
(aka Queries).

Yes, you can list multiple numbers in a query parameter, but you have to
set up the query as described here:

http://support.microsoft.com/kb/q210530/

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQlSL9YechKqOuFEgEQKxLgCgljxZpECMmkNY2tQzRWaqNQiFNasAniig
xWgiQC+WW2RFwPzT0vXQXGMV
=eGhr
-----END PGP SIGNATURE-----
This didn't work. ARM 2-2005 is a Query, not a table. Another question, when
it asks me for a parameter, can I list certain numbers I want it to cycle
through, for example: 001 - 019? Is there any thing extra I need to do when
it asks me for the parameters?

:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Since Arm 2-2005 is a table, it must be in the Table part of the QBE
screen. You probably still have table [Arm 12-2004] in the Table part
of the QBE screen. Here's how to replace the table w/o screwing up the
query:

1) Right click on the table [Arm 12-2004] and select Properties.
2) In the Properties dialog box, Alias box, enter the word "Arm"
(without the quotes).
3) Switch to SQL view (menu bar: View > SQL View).
4) Find the FROM clause and replace [Arm 12-2004] with [Arm 2-2005]
5) Switch back to Design view (menu bar: View > Design View).
6) Test.

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQlRAe4echKqOuFEgEQJS7QCg/rVP1TnnYbOIqWEuO9mD0o08nkYAn3OU
Njvc8jz2/KdEf8ojq8ItNn5U
=g+Ot
-----END PGP SIGNATURE-----

I'm familar with access, but with this new job, I deal heavily with access
databases and queries. I acquired the previous database administrators
position and am playing detective work on how to get certain queries to run.
My question is complex, so I will tell you the steps I have taken.

I have a make table query that creates a table called Arm Febuary.
I then create a query called Arm 2-2005, based off of the newly created table.
I then create a new query called ARM details that has the following code:

Account: badlapp!Lpacct &"-"&Format([Arm 12-2004]![dtcyc#],"000"))

I know that I need to change Arm 12-2004 to the newly created Arm 2-2005,
but when I do, it asks for a parameter and just stalls out. When I run it
with the above code, it runs fine. Can you help me out with this.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top