Not enough space on temp disk - Query

I receive this message when trying to run a query that reads some fields from
a table and the remaining fields are either from other queries or calculated
fields.
I have deleted all of the unecessary temp files form the temp folder. The
JEt.temp file has exceeded 2GB and is wanting more. I understand 69' Camaro
advised that it can also be a result of not using ANSI joins. Below is my
query as it appears in Access SQL view. I am not sure how to create the join
to the queries.

Any help would be greatly appreciated.

-Bfike

Hi.

Below is my
query as it appears in Access SQL view.

Sorry. It didn't show up. Please try again.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.


"BFike" wrote in message
...
I receive this message when trying to run a query that reads some fields
from
a table and the remaining fields are either from other queries or
calculated
fields.
I have deleted all of the unecessary temp files form the temp folder. The
JEt.temp file has exceeded 2GB and is wanting more. I understand 69'
Camaro
advised that it can also be a result of not using ANSI joins. Below is my
query as it appears in Access SQL view. I am not sure how to create the
join
to the queries.

Any help would be greatly appreciated.

-Bfike

My apologies for not attaching the Query.

Here it is:

SELECT ors_data.StoreNumber, ors_data.sku, ors_data.upc, [Unit Sales by
Store 2005].UnitsSold, [Units Sales by Store 2006].UnitsSold, [Unit Sales by
Store 2005]![UnitsSold]/[Units Sales by Store 2006]![UnitsSold]*100 AS [Pct
Change Units], [Unit Sales by Store 2005].[Units Sales 05], [Units Sales by
Store 2006].[Units Sales 06], [Unit Sales by Store 2005]![Units Sales
05]/[Units Sales by Store 2006]![Units Sales 06]*100 AS [Pct Change Sales]
FROM [Unit Sales by Store 2005], [Units Sales by Store 2006], ors_data
ORDER BY ors_data.StoreNumber;

Thanks Camaro '69

BFike
"'69 Camaro" wrote:

Hi.

Below is my
query as it appears in Access SQL view.

Sorry. It didn't show up. Please try again.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.


"BFike" wrote in message
...
I receive this message when trying to run a query that reads some fields
from
a table and the remaining fields are either from other queries or
calculated
fields.
I have deleted all of the unecessary temp files form the temp folder. The
JEt.temp file has exceeded 2GB and is wanting more. I understand 69'
Camaro
advised that it can also be a result of not using ANSI joins. Below is my
query as it appears in Access SQL view. I am not sure how to create the
join
to the queries.

Any help would be greatly appreciated.

-Bfike

I don't see any joins between the three tables/queries. This will cause a
huge Cartesian join. You need something between the three or else you could
be creating millions of records. Is there a line between the tables in the
query design QBE grid? There needs to be.

For testing you could also remove the ORDER BY clause as sorting records
uses space.
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"BFike" wrote:

My apologies for not attaching the Query.

Here it is:

SELECT ors_data.StoreNumber, ors_data.sku, ors_data.upc, [Unit Sales by
Store 2005].UnitsSold, [Units Sales by Store 2006].UnitsSold, [Unit Sales by
Store 2005]![UnitsSold]/[Units Sales by Store 2006]![UnitsSold]*100 AS [Pct
Change Units], [Unit Sales by Store 2005].[Units Sales 05], [Units Sales by
Store 2006].[Units Sales 06], [Unit Sales by Store 2005]![Units Sales
05]/[Units Sales by Store 2006]![Units Sales 06]*100 AS [Pct Change Sales]
FROM [Unit Sales by Store 2005], [Units Sales by Store 2006], ors_data
ORDER BY ors_data.StoreNumber;

Thanks Camaro '69

BFike
"'69 Camaro" wrote:

Hi.

Below is my
query as it appears in Access SQL view.

Sorry. It didn't show up. Please try again.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.


"BFike" wrote in message
...
I receive this message when trying to run a query that reads some fields
from
a table and the remaining fields are either from other queries or
calculated
fields.
I have deleted all of the unecessary temp files form the temp folder. The
JEt.temp file has exceeded 2GB and is wanting more. I understand 69'
Camaro
advised that it can also be a result of not using ANSI joins. Below is my
query as it appears in Access SQL view. I am not sure how to create the
join
to the queries.

Any help would be greatly appreciated.

-Bfike

Below is something to try. It assumes a StoreNumber field in all three
tables/queries. If need be you can change it to the proper field names.

It also assumes that all three have the same stores. If not some records
will get lost. Therefore you'll need to make some Left or Right joins.

I also noticed that you are dividing (/[Units Sales by Store 2006]) . If
that table/query has a 0 in the field, you'll get get a divide by zero error
and this could happen after the query has run for a while.

SELECT ors_data.StoreNumber,
ors_data.sku,
ors_data.upc,
[Unit Sales by Store 2005].UnitsSold,
[Units Sales by Store 2006].UnitsSold,
[Unit Sales by Store 2005]![UnitsSold]/[Units Sales by Store
2006]![UnitsSold]*100 AS [Pct Change Units],
[Unit Sales by Store 2005].[Units Sales 05],
[Units Sales by Store 2006].[Units Sales 06],
[Unit Sales by Store 2005]![Units Sales 05]/[Units Sales by Store
2006]![Units Sales 06]*100 AS [Pct Change Sales]
FROM [Unit Sales by Store 2005],
[Units Sales by Store 2006],
ors_data
WHERE ors_data.StoreNumber = [Units Sales by Store 2005].StoreNumber
AND ors_data.StoreNumber = [Units Sales by Store 2006].StoreNumber
ORDER BY ors_data.StoreNumber;

--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"BFike" wrote:

My apologies for not attaching the Query.

Here it is:

SELECT ors_data.StoreNumber, ors_data.sku, ors_data.upc, [Unit Sales by
Store 2005].UnitsSold, [Units Sales by Store 2006].UnitsSold, [Unit Sales by
Store 2005]![UnitsSold]/[Units Sales by Store 2006]![UnitsSold]*100 AS [Pct
Change Units], [Unit Sales by Store 2005].[Units Sales 05], [Units Sales by
Store 2006].[Units Sales 06], [Unit Sales by Store 2005]![Units Sales
05]/[Units Sales by Store 2006]![Units Sales 06]*100 AS [Pct Change Sales]
FROM [Unit Sales by Store 2005], [Units Sales by Store 2006], ors_data
ORDER BY ors_data.StoreNumber;

Thanks Camaro '69

BFike
"'69 Camaro" wrote:

Hi.

Below is my
query as it appears in Access SQL view.

Sorry. It didn't show up. Please try again.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
http://www.Access.QBuilt.com/html/ex...ributors2.html for contact
info.


"BFike" wrote in message
...
I receive this message when trying to run a query that reads some fields
from
a table and the remaining fields are either from other queries or
calculated
fields.
I have deleted all of the unecessary temp files form the temp folder. The
JEt.temp file has exceeded 2GB and is wanting more. I understand 69'
Camaro
advised that it can also be a result of not using ANSI joins. Below is my
query as it appears in Access SQL view. I am not sure how to create the
join
to the queries.

Any help would be greatly appreciated.

-Bfike