Search results

How would I about filtering out all results that contain a letter in them? The entries are in a field called Code, and I only want to display the resources that don't have a letter in the code.

Hello. I'm quite new to this, so this may be an easy question. But i have a combo box, and would like the items in it to be the entries of Events.Name, but only if Events.User1 = "MOS". What would be the expression for this? :) Thanks in advance.

Is there any way of doing this. I know you can use SELECT DISTINCT to not havce multiple records, which I have done in my query, but I want to also removed doubles that the same exact address and email field as others.. Any help would be great. :) Oh, and If possible could I also add a couple...

I have designed a query, but the results are not coming out proper... I have 4 tables, Familes, People, LinksEvent, and Events. I cannot change these because it is a database someone else has done that is used for lots of things. From events, I determine whether it was an MOS event, and then...

I'd like to only show records in my query that either have an address or an email. If both are empty, it shouldn't show up. I don't know how to go about doing it so it tells if one of the two is at least full. I tried Is Not Null And [Email] is not null, in the criteria for address, but this did...

I have an email field. Lots of things have been typed into it for some reason, that I can't go back and change, so in my query I want only the ones containing "@" to show up. I think it can be done, but that it will totally exclude the records without an @, but I still need them to show up, just...

I'm making a query, and for the criteria under the Event field, I only want them to show up if its the same as one of the ones in the "Code" field of another query. I tried putting [zz MOS Stops]![Code] in the Criteria, but it doesn't work. I'm very new to this, so help would be appreciated.

I have a Yes/No field in a table, and I want to generate a report that only shows the records that are a yes. I cannot figure this out. Any hlep would be appreciated.

I have a database, with certain amounts of money owed by certain programs. AT the bottom of the report I need the subtotals of money owed by each. I have the fields program, and item price. So at the bottom It would be like.. Money owed by program A: $500 Money owed by program B: $3 If anyone...