Search results

thanks for all your help anyway. i found a round-about solution.

they are the same in both queries...AccountNumber...

that does not work...it says it cannot find the expression...i think there must be another way to reference the query the dcount is in

SELECT DW_Account_Rollup.CalendarYearNumber, DW_Account_Rollup.CalendarMonthNumber, DW_Account_Rollup.AccountName, DW_Account_Rollup.AccountNumber, DW_Account_Rollup.Agency, DW_Account_Rollup.SumOfTotalSpend, DW_Account_Rollup.AvgOfAverageDailySpend...

i removed the ME! bit and it still doesnt work.. i am using it in a query, lets say QUERY1 (ME)..and the dcount is on QUERY2 =IIf(DCount("[Status]", "QUERY2","[AccountNumber]=" Me!AccountNumber & " And [Status]= 'Not Paused'")>0,"Not Paused","")

i am not sure what i am doing wrong when i enter that expression into my query it says it does not like this bit "Me!AccountNumber"

hi i have a query that returns a dataset that looks like this: Account Status 123 Paused 123 Paused 123 Not Paused I want to evaluate these results and in a second query, for the account 123 return the value "Not Paused" if there is at least one status set to...

Hi All Not sure if this is the right place for this question But what I want to do is use the date value stored in a cell in an excel spreadsheet in an access query...I am not sure how to do this? I will then display the results of this query back in excel. So from a user perspective, in...

i have found a solution i thought i would share In excel 2007 I was able to add a new ODBC connection (not the default MS Access one) and select the union query. Then under the "get external data" option select "existing connections" and select the connection you just created.

Hi not sure if this is the right section for this question... i want to display the results of a union query in excel. i want it to be automatically refreshed each time so there is no user involvement. i have searched this forum and found other people with the same question and it has gone...

if i change the control source from "code" to "price", then when i select an item in the code combo box, the price combo won't change (to the appropriate price for the item code selected).

hi i have attached a document with print screen of the form and combo box properties i am working on the way it works is, when the user selects a code, the appropriate desciption, uoi and price is displayed. but for some reason the price combo value is not being written to the price field in...