Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: cyclops1eye
- Order by date
-
HELP!!!! --> pulling from two tables with one COUNT
DUDE!!! THIS WORKS GREAT!!! THANKS A MILLION!!!.... One modification that I did make, though, was to change COUNT(*) to COUNT(1), so that I didn't have it loading all fields... Anyway, thank you very much!!!! -one_eye- cyclops1eye
- Post #6
- Forum: ANSI_SQL
-
HELP!!!! --> pulling from two tables with one COUNT
That looks just like what I need... just wasn't sure how to express it in SQL... Thank you very much! I will have to go try it out now... I will let you know what I encounter. Cheers, -one_eye- cyclops1eye
- Post #5
- Forum: ANSI_SQL
-
HELP!!!! --> pulling from two tables with one COUNT
I was meaning same columns. That is actually not the case, but I am familiar enough with SQL that I was trying to make it easier for someone to answer my question... What is your question about how the tables are used? -- Cyclops_One_Eye- cyclops1eye
- Post #3
- Forum: ANSI_SQL
-
HELP!!!! --> pulling from two tables with one COUNT
HI! I have a fun one here. I am trying to populate a ListBox in Access using two tables... and what I have for fields are these: ID Product_Number Serial_Number Checked -- ------------------- ----------------- ---------- Now, the "Checked" field doesn't go into...- cyclops1eye
- Thread
- Replies: 5
- Forum: ANSI_SQL
