Search results

Is it possible to pull back one field in the detail section on a report under certain circumstances and another field at all other times as per the below code? textbox name = am_units_calc =IIf([id_activity_type]="Trading Fees",[am_units_calc],[am_per_unit]) The textbox is currently producing...

I need to take a value from a subform and use it in a query but I don't seem to be able to come up with the correct criteria in the query.... I have so far tried: [Forms].[frm_Matching].[SubMatching].[txtSingleFixedPayer] [Forms].[frm_Matching].[SubMatching].[form].[txtSingleFixedPayer]...

Hi, Just trying to figure out how I can run a select query on some data I have and how to also include an additional field which has a value counting the number of rows.... eg in the first row there would be the usual results and the new field would have a value of 10001, second row would be...

How can I show the results of a recordset in the same way as you would see if you'd run a select query? eg in my mind it would appear similar to this in code: docmd.openquery rst acviewnormal Thanks, jono

Hi, I'm trying to run a pass thru query into a sybase server from Access. The query contains multiple selects which Access doesn't appear to like very much. The query works fine when run in Sybase. Is there any way of circumventing this problem? I could split the three selects into three...

I've been stumped with this for ages and keep having to go back to DAO to get around it... I have created a recordset using ADOX, but then how do i put the results into a table that already exists or even just add it to a new one? Its been driving me nuts... I've tried adding a new table to...

Hi, I am using DAO and seem to have a problem using a pass through query with an ODBC link to a sybase server... If an incorrect ID and PW are entered for the first time into some text boxes I have set up and then the query is run for the first time it will return no results as expected as no...