Search results

Thanks heaps. I will apply them to the real data and see what happens. Thanks Again

Appologies namliam, did not close db, before attaching file. %^%*. Copy attached with what I did. Again thanks Have tried to work out how to use the function bit, not actually sure where to put it? Im only a novice who is very dependant on query builder. ------- Public Function...

thanks for your help, it made me think outside the box. Dont know if its the prettiest way to do this but it works. Hoping it works over a database with thousands of records. If there is a smarter way to do it please provide comments, as they always assist, even if its to push thoughts...

The unmatched query helpes me to match like attributes between tables. Problem is with my tables table1 has single attribute "effectivity" and table2 has multiple attributes to supply the same data in a different format. Access db attached original post. would i be better to create...

Hi i have a question in regards to how would i create a query that would produce the results for the following tables: My expected errors across these two tables are: Effectivity 9 for A000103 rev 2 in Table 1 is not present in Table 2. Effectivity 5 and 6 for A000103 rev 2 in...

SELECT * FROM ciapp WHERE "4" BETWEEN ciapp.appfrom AND ciapp.appto; Thanks for the rewrite, much cleaner.

proven results, it works even with alpha. It may have issues with +10 (not tested by me). My requirement is one char only. refer mdb or or file, to prove for your self.

Thanks brianwarnock, for providing assistance. Hardcode below is simple but very effective when identifying ranges of numbers between multiple fields (see example in original attachment). SELECT ciapp.ci, ciapp.appfrom, ciapp.appto FROM ciapp WHERE (((ciapp.appfrom)<="4") AND...

seems i did not explain correctly i need it to look at the range between appfrom and appto. if appfrom =0 and appto = 6 then the numbers within this range is 0,1,2,3,4,5,6. so the results would be as originally posted. need it to be hardcoded so the query can be used to build on for final...

Think I did not explain to well. A range of numbers between appfrom and appto. so if appfrom = 0 and appto = 6; then the range in between includes 0 and 1 and 2 and 3 and 4 and 5 and 6. so my original post is 100% correct. And I still need help I think it does need to be hardcoded, as...

Can someone please provide info on how I would write querie to select only values that meet criteria for the following scenario. Attachement has data examples one table, 3 columns all text I need to have all CI displayed where appfrom or appto includes the value of "2" in the range. The...