Query numbers ??

[honey2wood]

Hello to all.

I seem to have a problem with a Query that does not want to play ball !!

I have a table with a primary key autonumber being the unique serial number for a form.
I have made a query from this table using all the field from the table.
In the customer field I want to exclude one of those customers from the query results so I have got <> "customer Name". This works great
The problem I have is that after serial no. 14999 the query stops.
Remove the <>"customer Name" and I get all the records.
Is this the limit to the ability of the query to work it just seems strange.

Graham

 

[PNGBill]

In query design view just enter " not 3" to not have number 3 showing.

Here is an example in sql

SELECT TblCustomers.CustomerID
FROM TblCustomers
WHERE ((Not (TblCustomers.CustomerID)=3));

 

[honey2wood]

Hi PNGBill

Thanks for getting back to me.
I have never used the 'not' before and it does the same as <> but the number problem is still the same.
There is at least another 30 lines after 14999 but they are not showing. I am at a loss with this one.

Graham

 

[PNGBill]

I tested the query and it should work to restrict just the number 3 from a list of numbers either side of 3.

You may have another problem with your tables and or query or even the form that you use to view the result.

Try making a new query of the table with just one field, the primary key.

get all the records first and if it works, add the criteria and see what happens.

 

[honey2wood]

Hi Again

Without the criteria set it works perfectly includung the customer I want but as soon as I put the criteria it stops at 14999.
I have also recreated the query but it does the same.

 

[PNGBill]

Do you have another table with more then 15,000 records that you can test the query on?

 

[PNGBill]

You say Customer you want?? I thought you were trying to not show one record rather then only show one record

 

[honey2wood]

Hi

Sorry I did mean the one I didnt want.

I have tried it on the same query with another field and it does the same.
I might have to start again with a different numbering system.

 

[PNGBill]

That sounds a bit drastic. How many records do you have?
What is the number system now? autonumber?

 

[MSAccessRookie]

Hello to all.

I seem to have a problem with a Query that does not want to play ball !!

I have a table with a primary key autonumber being the unique serial number for a form.
I have made a query from this table using all the field from the table.
In the customer field I want to exclude one of those customers from the query results so I have got <> "customer Name". This works great
The problem I have is that after serial no. 14999 the query stops.
Remove the <>"customer Name" and I get all the records.
Is this the limit to the ability of the query to work it just seems strange.

Graham

This seems a bit strange. I expected that the actual SQL statement might be a little more complicated then you have described so far. Would it be possible for you to post the complete SQL statement?

 

[honey2wood]

Hi
Just a bit of an update.
I have tried this on another PC and it works correctly. No problems at all.
Any idea why?
Thanks for everones help.
Graham