query help sought ... I would like a query that returns the itemwith the lowest value ... The above is a simplification, as there will be several groups, each ... statements and temp tables that are iteratively built up? ... (comp.databases.ms-sqlserver)
Complex query ... I would like a query that returns the itemwith the lowest value ... with the restriction that if taht item is in multiple groups it must ... statements and temp tables taht are iteratively built up? ... (comp.databases.sybase)
Re: Truncation Issue w/ Strings ... I was getting the results from an access query, so I ended up having to ... create a temp table, and insert the rows into a memo field in the temp ..."fdhsjak hfdjksh fdshfjkdlsh fjdshfj hdslfh dshfjlshjfhdsjflhdsjlfh...dsjlkhfjdshfjdha jfdhj f " & _ ... (microsoft.public.vb.general.discussion)
Re: query unique count for field ... I am not looking for a 1 to n sequence across the whole ... Start with such a temp table empty of ... >> Having succeeded with Michel's advice, I now have a query with the correct ... >>> where table Iotas has a single field, iota, with values from 1 to nnn, ... (microsoft.public.access.queries)
Re: deleting columns in table ...Doug Steele, Microsoft Access MVP... To delete the contents of the temp table, you need a Delete query:... (microsoft.public.access.modulesdaovba)
