Search results for query: *

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...

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...

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...

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! :)