Search results for query: *

thanks jo for your assistance - works fine! djh

Dear All, Does anyone know how I can control the use of an InputBox when using VBA? For example, if the end-user enters data into the InputBox and hits the "OK" button, then I want to then call a particular sub-procedure (eg. continue with the application). If the end-user however...

bp, finally solved the query! as you will see below, we were so close! thanks for your assistance :) djh select flightno from flight where flightno <> 'EA056' and flightno not in (select flightno from flight C where C.fto not in (select fto from flight...

bp, much appreciated the time you have spent on this query of mine - i shall too endeavour to find a solution. if so, i shall post it immediately to the forum! cheers, djh.

bperry, my mistake, the query above is not returning the correct results i am after for the reason you mention. if we go back a step and look at the below query, we can see that the result is a list of flights that fly to at least one of the destinations that EA056 flies to (note that other...

thanks bperry! the result of your requested query is listed below; note that all i need to do now is get the query to give me a result of flight EA154 as this is the only flight that fliess to ALL of flight's EA056 destinations....can we count once again where count = 3? thanks for your help...

bperry, i have managed so far to obtain all flights that fly to at least one of the destinations that flight EA31 flies to. i am thinking now, if i can count the number of destinations that flight EA31 flies to, and then apply this to an outer query, i should be almost there......any...

Dear All, Can anyone assist with writing the below query in syntax that Oracle will understand? I am having trouble with the cross join syntax.... Please excuse my ignorance, I am new to SQL! ** THANKS TO bperry FOR THE SOURCE SQL** Select f2.flightno, COUNT(f2.flightno) as NumCities From...

BTW: thanks bp for the source sql!

Hi All, Can anyone assist with the following MS SQL Server qeury that I need to run on Oracle? I am having trouble converting the syntax for cross join..... Any help would be appreciated. Djh Select f2.flightno, COUNT(f2.flightno) as NumCities From FLIGHT f2 cross join ( Select...

hi bp, thanks for your assistance - i am still working on it as my deadline is approaching. you will have to excuse my ignorance re: SQL terminology - i am very new to SQL. re: the type of syntax - i am using an old version of oracle hence SQL is all i have. not to worry, i shall...

hi bperry, thanks so much for your assistance; only problem is, i am using SQL not SQL2 hence can not do any JOINS. bummer. i was thinking of getting around the problem usine exists / not exists.....here is what i have so far, however it is still not giving me the desired results!: select...

hi bp, you are correct on both accounts - the number of destinations will vary depending on which flight you query, and if a flight has 4 destinations, 3 of which match 'EA031' flight destinations, then it does counts. i tried to look at it as follows: * give me a list of the destinations...

Hi bp, Unfortunately I do need a single SQL statement. I also tried using the exists / not exists functions, and referencing the innner query to the outside query - any with that line of thought? Thanks for your help! DJH

Hi bp, Appreciate your comments / reply; hope this helps: Relations Involved: DAYS(FLIGHT, DAY) FLIGHT(FID,FFROM,FTO,DEPTTIME,ARRVTIME,DAYS,FLIGHTNO) Note: Days.Flight = Flight.Fid Question: I need to obtain the flight numbers (flight.flightno) of any flights that travel to ALL of the...

Hi, Hopefully someone can assist.........I need to query a sub-query, based on the outer query criteria matching ALL of the attributes obtained from the inner query. For example, I have two relations A and B. My inner query creates a new relation with 3 attributes from relation A. I then want...

Forum Users: Any advise on the best approach to investigate a large Access database, with the ultimate goal to gain an understanding of the data stored, the tables created and the relationships that they hold, and ultimately where (ie. the tables etc.) certain reported figures are sourced? I...

Thanks Skip and dsi for your help. Daniel.

Thanks Skip, for your suggestion. I have enabled the Excel 9.0 Object Library via Tools/References and hence are able to open a new worksheet in MS Excel. What I am still having difficulty with though is actually operating MS Excel from VB - ie. what is the code to get control of MS...

As mentioned above, I am attempting to automate the process of copying a particular portion of data from a MS Word document, paste it into MS Excel, manipulate this data, and then create a new MS Word document and paste back into word. So far I have managed to create an object in MS Excel (via...