Search results for query: *

Thank you! I tried the first of the two and it worked. To answer your questions, I was trying to troubleshoot my query, so made a new one with just the basics, unjoining all the tables and starting with the one giving me trouble. What I was working on was just the troublesome part of a larger...

Ok, the Resolution-Code is the field that is sometimes null in TT:TroubleTicket. This is as-is: SELECT [TT:TroubleTicket].[Ticket-Number], [TT:TroubleTicket].[Resolution-Code], [TT:TroubleTicket].[Status-History-Closed-TIME] FROM [Ticket Source Lookup], ([TT:TroubleTicket] INNER JOIN...

I have a query that pulls from a couple of tables that are linked based on a Code field. As it turns out, the Code field is sometimes null in the Main table, but I'd like to see the record anyway, even if what I get from the link is not there. I thought I could change the Join Properties in...

Can anyone figure out why this wouldn't work when[First Stop Time] is null. First: IIf([Dispatch]=0 Or IsNull([First Stop Time]) Or [First Stop Time]=0 Or [First Stop Time]>=[Dispatch],"No","Yes") Thanks!

I have a report I've grouped by ({Ticket Closed},"monthly"), which I am unable to group by in a formula to calculate a summary by month. Is there a way I can still use the system date grouping, and then refer to this grouping in a formula? Can't group by {Ticket Closed}, as it is...

Conversion from Access 97 to 2000 issue...you have to add Me.Requery everywhere that calls for a form refresh. This is the second such issue I've run across. The first time I had to add a second requery at the beginning of the function. Adding a requery on form load solved my stuck tab...

I'm having a problem after making changes (checking boxes) on the first tab of many on a form. The whole form freezes except that I am still able to check additional boxes on the first tabbed subform. If I enter the tabbed forms, don't make entries on the first one but switch tabs, then go...

Thanks your responses. The problem turned out to be that there was code assigning a value to this particular check box. I just missed it during my first couple of searches. Thanks, again!

I have been unable to get a checkbox to default to being checked. I changed the Default Value property of the subform's checkbox field and of the record source table to 1 or true/yes. None of this changes the display when I open the subform on a tab from the main form. I'm using Access 2000...

I'm not sure how to go about converting an existing function to use a list of search values from an additional, new recordset. It presently opens one (1) recordset and searches a memo field for values that match a certain format (& tallies, using arrays). I want to, instead, get names from a...

GeekGirlau, Thanks - that did the trick!

I think that would work if I had a cell range, by my work log is in a single cell. Mahalo!

How might I go about counting the instances of a particular string in a memo field? For example, in a work log field, I want to count the number of entries for "John Doe". Please give details - thank you! :)

How might I go about counting the instances of a particular string in a memo field? For example, in a work log field, I want to count the number of entries for "John Doe". Please give me details - thank you! :)