IWETHEY v. 0.3.0 | TODO
1,095 registered users | 0 active users | 0 LpH | Statistics
Login | Create New User
IWETHEY Banner

Welcome to IWETHEY!

IWETHEY Home / IWETHEY Board / Databases Forum / Well the documentation is misleading? :-)
Post #107,567
by ChrisR
6/27/03 2:27:15 PM
Reply
New Well the documentation is misleading? :-)
2 tables that have a field called Serial_Number that is defined as a text field indexed with duplicates allowed.
Did you mean to say that there are 2 tables with serial number columns - one named [Serial_Number] and the [Serial Number] => at least that's the way I read the query.
Post #107,584
by boxley
6/27/03 4:55:32 PM
Reply
New the cut and paste was correct
on the sql but I described it incorrectly. Changed name of hsinventory.Serial Number to hsinventory serial so I wouldnt confuse myself further.
thanx,
bill
will work for cash and other incentives [link|http://home.tampabay.rr.com/boxley/resume/Resume.html|skill set]

questions, help? [link|mailto:pappas@catholic.org|email pappas at catholic.org]

As the Poets have mournfully sung.
Death takes the innocent young,
The rolling in money,
the screamingly funny,
And those who are very well hung.
W.H. Auden
Post #107,591
by orion
Picture of orion
6/27/03 5:21:09 PM
Reply
New I've changed it in my example
I have created a database using the same names you have described in the query, all I have is serial_number in one, and serial in the other. No other column names. They are set as indexed with duplicates allowed. I am doing this to try and replicate the problem you are having. I am entering the data myself, bogus data, but data that works. Not the exact same as your database, but enough of it so I can get a better idea of what is going on.



"I wonder how much of this BS Corporations will continue to shallow before they start looking into alternatives to Microsoft software?" -[link|http://z.iwethey.org/forums/render/content/show?contentid=106839|Orion]
     Have an Access problem - (boxley) - (34) - June 27, 2003, 11:40:35 AM EDT
         The SQL is correct. - (tseliot) - (5) - June 27, 2003, 12:49:43 PM EDT
             run toy data - (tablizer) - June 27, 2003, 01:32:51 PM EDT
             how would I TRIM the above statement? - (boxley) - (3) - June 27, 2003, 01:33:13 PM EDT
                 Try this: - (orion) - (2) - June 27, 2003, 01:51:48 PM EDT
                     your update ran OK, thanks Norm but - (boxley) - (1) - June 27, 2003, 02:18:14 PM EDT
                         Access relationships - (orion) - June 27, 2003, 05:18:27 PM EDT
         Could be a relationship problem - (orion) - (1) - June 27, 2003, 01:37:13 PM EDT
             only relationship, single user -NT - (boxley) - June 27, 2003, 01:41:02 PM EDT
         Well the documentation is misleading? :-) - (ChrisR) - (2) - June 27, 2003, 02:27:15 PM EDT
             the cut and paste was correct - (boxley) - (1) - June 27, 2003, 04:55:32 PM EDT
                 I've changed it in my example - (orion) - June 27, 2003, 05:21:09 PM EDT
         Is "field indexed *with duplicates allowed*" on BOTH tables? - (CRConrad) - (22) - June 27, 2003, 05:52:26 PM EDT
             Re: Is "field indexed *with duplicates allowed*" on BOTH tab - (orion) - (19) - June 27, 2003, 06:41:35 PM EDT
                 The only primary key is on the master table - (boxley) - (2) - June 27, 2003, 07:20:48 PM EDT
                     Re: The only primary key is on the master table - (orion) - (1) - June 27, 2003, 08:22:20 PM EDT
                         the only link is the serial fields - (boxley) - June 27, 2003, 09:35:46 PM EDT
                 That is a major assumption on your part - (tseliot) - (15) - June 27, 2003, 09:35:31 PM EDT
                     Actually, for oce Norm is far more right than wrong; you... - (CRConrad) - (2) - June 28, 2003, 09:30:20 AM EDT
                         We're not disagreeing here. - (tseliot) - (1) - June 28, 2003, 01:13:30 PM EDT
                             Ah... *that* "assumption"! :-) - (CRConrad) - June 28, 2003, 02:58:36 PM EDT
                     ALL tables need PK's. - (mmoffitt) - (11) - June 30, 2003, 11:40:08 PM EDT
                         Sorry; What's an "sp"? - (tseliot) - (2) - July 1, 2003, 10:31:18 AM EDT
                             Probably 'Stored Procedures'.... - (ChrisR) - (1) - July 1, 2003, 10:36:51 AM EDT
                                 In Access they are "Queries" - (orion) - July 1, 2003, 12:32:23 PM EDT
                         Are you disagreeing with me? I can't tell. - (tseliot) - (7) - July 1, 2003, 04:18:35 PM EDT
                             Dunno if I disagree. - (mmoffitt) - (6) - July 3, 2003, 11:23:33 AM EDT
                                 Toy and scale are not the issues. - (tseliot) - (5) - July 3, 2003, 02:10:46 PM EDT
                                     Then you don't need a thirty-line table at all... - (CRConrad) - (2) - July 3, 2003, 03:51:15 PM EDT
                                         Thank you. -NT - (mmoffitt) - July 3, 2003, 10:56:12 PM EDT
                                         Should I answer? - (FuManChu) - July 4, 2003, 01:18:46 PM EDT
                                     But, but, a tool of any value has a serial number and they.. - (a6l6e6x) - (1) - July 3, 2003, 09:56:56 PM EDT
                                         In this particular case - (FuManChu) - July 4, 2003, 01:24:29 PM EDT
             Started with no index on either field - (boxley) - (1) - June 27, 2003, 07:15:57 PM EDT
                 It's probably not a factor in your problem... - (tseliot) - June 27, 2003, 09:37:44 PM EDT

You lucky bastard!
66 ms