Note that I am leaving off the Select in the below Queries because Sucuri blocks the post if it contains the word Select in the below queries.
The below sql query returns a record count of 1 no matter what the value of X
Count(*) FROM tablename WHERE fieldname=X
This below sql query returns the correct record count of 66
* FROM tablename WHERE fieldname = X
Why do I get different record counts?
I believe the correct sequence for SQL and Count is as follows
PHP Code:SE LECT COUNT(column_name)
FROM table_name
WHERE condition;
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Still returns 1 no matter what condition is specified. If I use
S lect fieldname FROM tabename WHREE fieldname = x
then the correct number of records are returned but if I use count(fieldname) then I always I get a record count of 1
returned.
Is your fieldname actually "fieldname"? If not change it to your actual field name.
Yes, I know that. the field name is DietID and it returns a record count of 1. If I use
S LECT DietID FROM Recipes WHERE DietID = X, it returns a record count of 1 no matter what the X is since apparently the fieldname is the same as the condition search field. If I use another field such as
S LECT Name FROM Recipes WHERE DietID = X, it returns the correct record count
I believe that it should read
PHP Code:S LECT Count(DietID) FROM Recipes WHERE DietID = X
This thread is the one that needs moving back - is this an Excel or Access query? Sorry - it got moved with all the others.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Same with Count (DietID) or DietID..record count is 1 no matter what X is. If I use another field such as Name, it returns the correct record count of the number of records in the Recipe Table that has a DietID = X
I have moved this to the appropriate forum
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Same with Count (DietID) or DietID..record count is 1 no matter what X is. If I use another field such as Name, it returns the correct record count of the number of records in the Recipe Table that has a DietID = X
I suspect that it's because DietId is null, a count of nulls is 0 - the other fields are not null.
The Recipes table has many DietID's equal to X under the DietID field in the Recipe Table. "S LECT Name FROM Recipes WHERE DietID = X" it returns the correct record count.
Is that your actual SQL?
How are you calling this?
What's is DietID a Nullable field?
What database are you using?
Last edited by Kyle123; 11-07-2017 at 11:44 AM.
Yes, those are the actual SQL's and I'm calling it frrom excel vba using the recordset object. As I said, the below three sql's return the values indicated.
S LECT DietID FROM Recipes WHERE DietID = X ' returns a record count of 1 no matter what the X is since apparently the fieldname is the same as the condition search field.
S LECT Count(DietID) FROM Recipes WHERE DietID = X ' returns a record count of 1 no matter what the X is since apparently the fieldname is the same as the condition search field.
S LECT Name FROM Recipes WHERE DietID = X, it returns the correct record count
Note that my access database has several fields in the Recipes table of which Name and DietID are two fields.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks