Search results

Have you tried using DAvg? =DAvg("[theColumn]","tableorqueryname","[theColumn]>0")

Sorry, didn't think it all the way out. I'm still wondering why what you were originally attempting won't work. I like Gemma's needthis() function, although I had a different idea for setting the myarray variable. Using Gemma's needthis function in the query, what about replacing the cmdOK code...

How about taking the 'Like' expression part out as part of your variable strCriteria, and put it in your query criteria? Like "*" & ReturnStrCriteria() I think the problem is getting the query to interpret the 'Like' expression when it's passed as a variable.

Is your 'Tab Stop' property set to 'Yes'?

Just Curious If there are many options, what about putting the combinations in a table and looking the value up? If a combination changed, you would just update the table. Wouldn't this work or is this not advisable and why?

Yes IIF([Percent Complete] = 0, 0, ([Total of Hours Expended]/[Percent Complete]/100)*(100-[Percent Complete]*100))

Yes, I think using the criteria [Enter Year] in DCount is a problem. There is probably a better way to do this, but you could try adding a field (ex. [othertextfield]) with a control source of IIf([field1]='required value',1,0) under 'Detail' and set the 'Visible' property to 'No' and the...

What about... If I understand you correctly, you may not need a query to get you what you want. In your original post, you are trying to flag whether a field has at least one required value in it. I believe you can get that my replacing your [field1] = "Required Value" expression with a...

Oops, I misread your post. I think this will work. If your field is [Current].[feesch], your criteria is <>[New].[feesch]

Have you tried running a 'Find Unmatched Query Wizard'?

Do you want a list by month and a count of full reviews? If so, I would be using a 'Total' query Column----------------------------------Total Row--Criteria Month: month([dtmNPacketSubmitDate])--'Group By' [strRevTypeNIRB]------------------------'Where'----"Full" Full Reviews...

Actually, the Left function should start from the left and take as many characters you specify. ex. Left("Hello, world!",5) should give "Hello" Paul, I like your suggestion better.

Have you tried this? PGM: Format([ProgramCode],'@@@@@@')

Not sure how you want your number to look, but you could try to replace [SSN] in your query with Left([SSN],3) & Mid([SSN],5,2) & Right([SSN],4)

Starting Point You could try something like this... Expr1: IIf([column A] like '*1*' And [column B] like '*2A*',"so close", next condition)

Not sure if this will help, but... Have you tried using the Format function? ex. Format([Enter Start Date],"dd/mm/yy")

Have you tried using =Count([Film Name]) in your text box control source?

Specifically to your question, I don't know. Not sure what you are trying to do. What about putting in a subreport from one query inside a report running another query?

Not sure if this is the best way, but you could add another IIF inside the first one IIf([Online Availability] = "SC", "Online - Yes", IIf([Online Availability] = "DSP","Online - Yes",""))

Maybe I don't understand this correctly, but I suspect you are looking for something like this: =IIF([Location]="Circ",[callnumber]+(Chr(13) & Chr(10)) & [Online Availability]+(Chr(13) & Chr(10)) & [PF Subject],[Location]+(Chr(13) & Chr(10)) & [callnumber]+(Chr(13) & Chr(10)) & [Online...