Recent content by nike2000

Thanks for getting back to me guys. What I am trying to do is merge the results of Bundlet_No and Bundlet_Mirror. But I would like to exclude all of the records that the Reference Entity is null. Thanks again.

Hi, Could you let me know what is wrong with this Union Query? Thanks, SELECT Bundlet_No, ReferenceEntity FROM Tbl_Trades WHERE (((ReferenceEntity) Is Not Null)) GROUP BY Tbl_Trades.Bundlet_No UNION SELECT Bundlet_Mirror, Reference Entity FROM Tbl_Trades WHERE (((ReferenceEntity) Is Not Null))...

Hi, I have a number of records on a continuous from with check boxes. Is there any way that a Select All button could be used so as to 'Check' all of the Tick boxes? Thanks, Nike

Hi, Apologies for posting twice. The query threw back an error message: 'Syntax error (missing operator) in query expression' The SQL of the query is: SELECT Tbl_Trades.[MAD No], Tbl_Trades.[FRD No], Tbl_Trades.[Analytic Direction], Tbl_Trades.Ptf, Tbl_PortfolioLocations2C.Location...

I have three tables in a query the SQL is: SELECT Tbl_Trades.[MAD No], Tbl_Trades.[FRD No], Tbl_Trades.[Analytic Direction], Tbl_Trades.Ptf, Tbl_PortfolioLocations2C.Location, Tbl_Trades.[Portfolio 2], Tbl_PortfolioLocations2C_1.Location FROM Tbl_PortfolioLocations2C AS...

I have three tables in a query the SQL is: SELECT Tbl_Trades.[MAD No], Tbl_Trades.[FRD No], Tbl_Trades.[Analytic Direction], Tbl_Trades.Ptf, Tbl_PortfolioLocations2C.Location, Tbl_Trades.[Portfolio 2], Tbl_PortfolioLocations2C_1.Location FROM Tbl_PortfolioLocations2C AS...

thanks for gettin back to me raye. what you have said is fine but Location 1 and Location 2 are completely seperate fields. they are not together. i would like to see only those records that have London in either of the two fields. Nike

because the same record can have two different locations placing London in both will only return records with London in both fields. There are variations in the two Location fields that can be London New York or New York London. the Iif statement is the best option. can this be done using an...

Hi, I have a query with a number of fields but would like to filter on the following two fields: Location1 and Location2 The records in both of these fields will only have the following data: London, New York, Tokyo, Hong Kong and can also be Null. I would like to be able to show in the...

Hi Pwise, I already have the query built and is quite complex already. It would be asier just to have the If statement, can this be done? Many thanks Nike

hi pwise, Thanks for getting back to me. This suggestion won't work because the Location 1 field can be London but the Location 2 field may have New York. This could also be reversed. These fields are independant of each other. So this would mean that where London was on one field and not the...

Hi, I have a query with a number of fields but would like to filter on the following two fields: Location1 and Location2 The records in both of these fields will only have the following data: London, New York, Tokyo, Hong Kong and can also be Null. I would like to be able to show in the...

Hi, I have a Macro that Outputs a Query into Excel. I would like to insert a Row between the Headings and the first row of data. Can this be done? Thanks, Nike

I have two fields in a query. They are: PV_OverTolerance DeltaOverTolerance The data in the fields is either 'Yes' or 'No'. I would like an If statement that would flag 'Warning' if any of the two fields indicated Yes for any record. Help would be appreciated. Many thanks, Nike

worked a treat thanks very much. Nike