[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 736
  • Last Modified:

Make table query not working

Hi,

I have a make table query which returns 160k rows when i use the view button, on running the make table query, it returns only 500 rows, does anyone know why this would be?

Thanks
0
Seamus2626
Asked:
Seamus2626
  • 2
2 Solutions
 
Rey Obrero (Capricorn1)Commented:
do you have any grouping, filtering in your make table query ?

when you run the make table query did you get any message about "violation" etc.,?


try this


SELECT Table1.* INTO Table2
FROM Table1;


post back the result, replace "Table1" with the name of your table
0
 
Seamus2626Author Commented:
No,

I dont understand, it should be a simple query

SELECT [Calculation D2].[Client Type], [Calculation D2].[Overal RAG], [Calculation D2].[Score selection], [Calculation D2].[Recognised structure], [Calculation D2].[Business Risk Score], [Calculation D2].[Product Risk decision], [Calculation D2].LOB, [Calculation D2].Country INTO [Client Types]
FROM [Calculation D2];
0
 
mbizupCommented:
Is that the full query?

That one looks ok... but the Make Table query you have been working on in other questions today looks problematic.

The solution you accepted here I think will give you problems if your Memo field has less than 255 characters:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_28316409.html


Do you really need Client Type to be a Memo field -- what kind of 'client types' do you have with such long names?  

You could try redefining the fields as text, setting the length to something large like 500 if needed, and use a simple join as you had initially tried instead of using a where clause based on a truncated memo field.
0
 
Rey Obrero (Capricorn1)Commented:
is [Calculation D2] a table or a query ?
0

Featured Post

Veeam Disaster Recovery in Microsoft Azure

Veeam PN for Microsoft Azure is a FREE solution designed to simplify and automate the setup of a DR site in Microsoft Azure using lightweight software-defined networking. It reduces the complexity of VPN deployments and is designed for businesses of ALL sizes.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now