Search results

  1. C

    Matching words partially

    I have to match two tables and I'm having a problem. Let me explain with an example. I am using address as a way opf joining them. One table has 6549 N High St as the address for customer A. The other has 6549 N. High Street, with the "." and the whole word street. Is there a way to match them...
  2. C

    Deleting records from a table based on the relationship to another table

    I would like to join two tables, and delete matching records from one of the tables. Customer Id Address dues Coca-cola 23 1 oak street $75 Customer Id Address dues City State Coca-cola 23 1 oak street $75...
  3. C

    summarizing records

    I would like to sum a specific field for 2 records. Ex.: Customer Id Address dues Coca-cola 23 1 oak street $75 Coca-cola 24 1 oak street $100 If, in my query, I just included the field "customer", "address", and...
  4. C

    Upper/lower case fonts

    One of the fiels of my report (made out of a query), I have employees' last names, all in uppercase. How can I switch them to Uppercase on the first name's letter and lowercase on the others? Thanks, Camedeiros
  5. C

    Reports

    I have a report made from a table that works nicely. In case I want to change the table to a new one where everything is the same, except that the new one has two more fields and the table itself has a different name, how can I use the same report design? Thanks, Camedeiros
Back
Top Bottom