I created a new table with one column for the SSN's, imported the SSN's I have to search for. I nned to search the master table for the SSN's that...
I am building a query so I can more easily export accounts. The accounts sometimes contain info on 2 persons in the same account and I want to...
Fantasitc!!!!! Thanks for the tutoring.
Thanks for the help! Trying it now. Our customer will be plaesed to see this report when done.
My previous post results solved one part of the query. Here is the last part that is not working. I have stripped the query down to make it easier to...
OOPS. In the reply, I pasted in test numbers by mistake. Here is the actual query. SELECT DISTINCT Customer.Street1 AS 'Prop#', Customer.Name AS...
The results of SUM master.original1 works great but COUNT master.number gets me the same results for both dates. Here is the query. SELECT DISTINCT...
Thanks for the help! I am trying it out now.
I am building a report that is currently running correctly for cuurent month results with the following query. SELECT DISTINCT Customer.Street1 AS...
Separate names with a comma.
