Search results

  1. P

    Filtering Letters

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

    Combo Box.

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

    Record Filtering

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

    Query Problems..

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

    Query Criteria

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

    Another Question.

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

    Query help

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

    Yes/No

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

    Sum Problems

    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...
Back
Top Bottom