Search results

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

still can't delete Could you please re-explain what it takes to delete the records in table B that match those in table A? In design view (which I'm familiar), I am showing tables A and B, and joining them (inner join) by Account number. I am then dragging the asterix from table B (where the...

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

the reason is that, once I merge those duplicates by summing them, I will have to link them to the table where they originally came from. So I need the unique key in order to link this new table that result from this query, and the big original one. If you all in this thread could please look at...

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

x I think that you problem may be solved by going to the query tab; then you click on the button above the main little window that says "new". Clicking "new" will give you several options of query, one of them being a "find unmatched" option. This will then start a wizard, in which you can...

I think that you problem may be solved by going to the query tab; then you click on the button above the main little window that says "new". Clicking "new" will give you several options of query, one of them being a "find unmatched" option. This will then start a wizard, in which you can...

I think that you problem may be solved by going to the query tab; then you click on the button above the main little window that says "new". Clicking "new" will give you several options of query, one of them being a "find unmatched" option. This will then start a wizard, in which you can...

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

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