Search results for query: *

I have a problem on one of my forms that I think probably has a very easy solution. I have two continuous form subforms on my mainform. I've added a button to the subform named frmSubHypoJobMatches called cmdViewMatches. I'd like for this button to filter the records in the second subform...

Hi All, I don't do things this odd very often so I need someone to point me in the right direction. I have a table name STGDEPTTREE with data as follows Deptid Tree Effdt BU 0000A 12/1/2005 ALL 0000A 1/1/2006 ALL 0000A 2/1/2006 ALL 0000A 3/1/2006 ALL 0000A 4/1/2006 ALL 0000A 5/1/2006 ALL 0000A...

I have a form that has a multi-select list box. I've succeeded passing the string value to a query but my query won't pull any records I suspect because I can't figure out how to delete the last "OR" from the string. Here's my sub: Private Sub lstStatus_AfterUpdate() Dim AwardStatus As...

I have a report that is pretty basic, there are award types and counts by Manager in the detail section and a subtotal of these counts by Next Level Manager in a footer called NLM. I've been asked to add the awards given by the NLM in the detail section and have a grand total of all in the...

I'm trying to calculate a sum of Unique ID's in a query. OTSEmpRec: IIf([tblNomination]![NominationType]=1,Count([tblNomination]![NominationId])) It's not allowing the query to run with the error message "you tried to execute a query that does not include the specified expression "". Can...

Can anyone help me with the following: I have an expression in a query that returns a null value if the month is 12 and the day is 1. Expression works properly on all other dates. Can anyone figure out what's wrong with my syntax? All I'm trying to do is add 1 to the recognition year if the...