Re: Finding available customer numbers

From: Hari (hari_prasad_k_at_hotmail.com)
Date: 06/02/04 

Date: Wed, 2 Jun 2004 19:22:16 +0530

Hi,

With this information it is difficult to give a solution. A tip will be,
Check the trasnaction table against the customer master table.
If you have not dealed with that customer , you wont have any transaction in
TRAN table.
With that you can identify the list of customers, query will be some thing
like:-

select cust_num,cust_name from cust_master where cust_num not in (select
cust_num from cust_transaction)

Thanks
Hari
MCDBA

"Mac" <jmcgrath@planesunited.com> wrote in message
news:46ABDDA1-B5FC-4F33-8655-E99A7802D794@microsoft.com...
> Hi All,
> How do I find unused customer numbers in a table?
>
> Thanks
> Mac

Relevant Pages

  • Re: Import BTR files?
    ... party database, to the custom written VFP database. ... has all of the customer data, ... >> Now I have a need to import the customer master table from a pervasive ...
    (microsoft.public.fox.programmer.exchange)
  • Split tables do not flow together
    ... I allowed access wizard to split the Customer table for me. ... table entitled Customer-OLD, plus Customer Master, Customer Contact Title ... information first or leave blank and go back to enter info and then go back ... "You cannot add or change a record because a related record is required in ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Find Inactive
    ... You could add a formula in a column on the Customer Master sheet. ... The second spreadsheet is Customer Master file with "CustomerID" and "SalesRep". ... I am looking for a formula to produce minimal data. ...
    (microsoft.public.excel.worksheet.functions)
  • Error 3201 - Related Record
    ... I allowed access wizard to split the Customer table for me. ... table entitled Customer-OLD, plus Customer Master, Customer Contact Title ... does not contain the email information or contact title info anymore. ... information first or leave blank and go back to enter info and then go back ...
    (microsoft.public.access.tablesdbdesign)
  • Re: PCMag: Louderback praising Mac Pro
    ... Customer looks at the Mac, would like a Mac, but decides not ... So Apple could possibly gain from this market. ... Since this type of customer would never have purchased a Mac then there ... hardware configurations, plus living with all the downsides of such. ...
    (comp.sys.mac.advocacy)