Search results for query: *

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

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...

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 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

Hi, I have a field in a table that contains one of the follwoing data. The data is O, M and it can be null. The name of the field is 'Analytic Direction'. Depnedant on the criteria of the field I would like to display more identifiable values for each one. They are: O = Original M = Mirror If...

Hi, Is this Syntax correct?? =IIf([PV_OverTolerance]="No","Yes",IIf([DeltaOverTolerance]="No","Yes","No")) Thanks for looking, Nike

Hi, I have a form that I am trying to calculate time taken to do certain tasks. The fields I have are StartTime and EndTime. I have used: =Sum([StartTime]-[EndTime]) but anything over 24 hours reverts to 01:30 for example. I would like to calculate the number of hours over 24 without taking...

I have a form that displays records filtered by a Combo Box on a previous screen. I want to build an Update Query on the this Form that will update these records. I have built the Update Query for this and it runs from a Command Button, but it updates all of the records not the selected filtered...

Hi there, I have the following If Statement populating a field on a continuous form: =IIf([AllChecks]="Yes","Yes","No") I would like to display in the Form Header the number of records that are "Yes". How can I count the results from this If Statement...

Hi there, I have the following If Statement on a field in a continuous form. =IIf([DatesChange]="Yes" Or [CreditEventsChange]="Yes" Or [RefEntityNameChange]="Yes" Or [RefObNameChange]="Yes" Or [ObCharacteristicsChange]="Yes" Or...

Hi there, Can you let me know if the following code is correct? The logic is; if any of these fields are a 'Yes', 'Yes' should be returned. All should be 'No' but if any are 'Yes' it should be highlighted. Have I written it correctly? Thanks =IIf([DatesChange]="Yes" Or...

Hi there, I have a continuous form with a number of records that are displayed by being filtered using a Combo box. The Combo box is on this form. I would like to run an Update query that only updates those filtered records. The field updated will be from 'No' to 'Yes'. I have created an Update...

I have a field in a Continuous Form that is populated by the following If Statement: =IIf([MigrationTeamOk],"No","Yes") The Field format is a Yes/No Checkbox. At the top of the form can I have a count of all those records that are 'Yes'? The Form works off a Query, and no...

Does Access 97 allow for a field to be formatted in Bold or different colour Font, dependant on the result of an Iif statement? Any help would be appreciated.Thanks, Nike

Hi, I am looking to combine the following IF Statements, I need some help... The statements are: =IIf(Abs(([FOCUS PV]-[MAD PV])/([FOCUS PV])*100)>9,"Yes","No") =IIf(Abs([FOCUS PV])-Abs([MAD PV])>30000,"Yes","No") Thanks, Nike

Hi, I am looking to combine the following IF Statements, I need some help... The statements are: =IIf(Abs(([FOCUS PV]-[MAD PV])/([FOCUS PV])*100)>9,"Yes","No") =IIf(Abs([FOCUS PV])-Abs([MAD PV])>30000,"Yes","No") Thanks, Nike