Search results

I have Multiple Table all in the same Format... I Can create a query to select all the data which has "Name" in Collum1.. But i Dont want to have to recreate this query for all 700 Tables.. So can i create a query that ask for Table Name or Source Table before running???

yes that is just what i was hoping to achieve to have it like describe do u no how i would go about this then, because the few ideas i have tried e.g. UNION one isnt working or having the affect the we wld have predicted

Yea this is just what i got im glad it wasnt just my code going wrong...but it does beg the question is there not a statement other than SELECT which will add to whats all ready there or a statement other than UNION which will add to whats already there?

oh i see well sometimes it is single words sometimes it will be multiple because its software names it could be "adobe" or "windows live messenger" so i need it to count up the contence of cells single word or sentence does this help and the UNION method is working because the second UNION or...

so would this be correct if the fields and in tbl "test" and are called "P (1) and PC (2)" SELECT [PC (1).Version] As Tempfield From test Where [PC (1).Version] Is Not Null UNION SELECT [PC (2).Version] As Tempfield From test Where [PC (2).Version] Is Not Null; this doesnt actually...

the only other way i can see of doing it, is someone finding a way create a query which will take in vertical colum and stack them ontop of each other in one long colum so i can then run duplicate on this, however that itself isnt easy however this then raises the issue of not showing when...

What the data actually is, is "softwarenames" and "no. of pcs that contain it".... so it will say "Access" "9" and this way, when we update our contract at work we no we require "9" licence keys for "access" so on, but sadly i dnt get to choose the format at which the data comes to me i have...

I have no idea what you just said lol... I need the query to finish with a table that in colum1 lists the text in each Cell for example down colum 1 i would have "sam" "John" "james" etc. in "coloum 2" how many times they appear..so the query continues reading through if it comes across "sam"...

no it wasnt it was very bad lol, corrected anyway so anyhelp???

Ok the latest task, i have to create a query, that works in a similar way to the find duplicates query... however is has to look through "query1" and count common phrases for example.. if the word "sand" appears in query1 "row 7 colum 4" and "row 8 colum 9", it would produce a table which...

all i want to do is that find it, for example when u build the basic find record button and find next button it jst keeps doing down finding the word u typed in till it cant find it anymore in yr list...what i need is this, however i need to button on the main form instead of the subform

I have a "mainForm" which contains a "subForm" (container) Can i create a button on the "mainForm" which will search for a record and find next record for which ever form i currently have in the "subForm (container)" thank you

I tried this method and it just seems to produce one table with only the common data in nothing else, am i doing it right ??? because that wasnt what i was aiming for

Would this not then give me 30 popup boxes that require the same peice of information over and over again? e.g. one popup box for every quiery i created

No im still getting the syntex wrong it doesnt seem to be picking up my data at all thanks anyway i guess ill have to figure something else out

Thank you for all ya help its now working a treat...

thank you ill try this now

they are basically name tables like example class1 and class2 at school, i need a query that will search both together and go" u have 4 Sams or even better u hav 4sams 3 in class1 and 1 in class2 "if u follow?

ok how do i create the union ive never heard of this method before???

"sam" will appearing in the same field in many different tables, even the field name will be the same which is in this case "name" so same field in each table but many tables yes