Search results for query: *

Hi, how do you relate the stored value from the Customer table with the SuffixDescription value from the Suffix table into the form so you see the related description(MR)? Customer table suffix this is foreign key to Suffix table (1) Suffix table...

Hi, table is Salutations SalutID is autonumber Salutation description ex. MR=1 MRS=2 from SalutID I store the 1 in the customer table for MR, In my form how do get the MR to show up instead of the 1? I just keep getting the 1 for the value. Thanks

Hi, in my Customers table I am converting certain fields into a new created field.<br><br>I created a select query that identifies the records and&nbsp;&nbsp;meets my criteria. I need to move/append them from the [Last Name] field to the [Company Name] field. <br><br><br>SELECT Customers.[First...

Can I use html and ODBC instead of Data Access Pages to eliminate the user from having to have the required Office Product installed on there PC; and still have them view the html)page? What would be the ups and downs?<br><br>Thanks

Hi,<br><br>Bill Type - table<br><br><br>AutoNumber BillType Billing Code<br>&nbsp;&nbsp;&nbsp;&nbsp;1 &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Regular Bill REG<br><br>I have a form with a lookup to this table but I don't know how to get the description field 2 or 3 to be included to view the...

Adding Payment plans to database?<br><br>Hi Kathryn,<br><br>hee hee... well I was wondering what I would have to do to add payment plans to my current database.<br><br>I have customer table, payments and order/invoice in one table...not sure how to set it up...thanks for any help.<br><br>Aaron

Hi, <br><br>I have a database created that handles receivable management. I wanted to add the ability for represenatives to add notes and set the notes to come back up at another date/time (contact management). What tables would I need to add and fields, thanks for the help<br><br>

I need to get just the street that is unique to the actual address so it should end up like this:<br><br>Expr1:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DU11801:&nbsp;&nbsp;&nbsp;CustomerID:<br>Smith St&nbsp;&nbsp;&nbsp;&nbsp;Smith St&nbsp;&nbsp;&nbsp;&nbsp;000444444<br><br><br>I have two tables...

Hi,<br><br>I have a table<br><br>tblCustomer<br>&nbsp;CustomerID<br>&nbsp;LastName<br>&nbsp;FirstName<br>&nbsp;Company<br>&nbsp;Phone<br>&nbsp;Fax<br>&nbsp;MailingAdd<br>&nbsp;MailingAdd2...

Hello,<br><br>When processing receivables for multiple Clients lets say 3 Clients.<br><br>Client1&nbsp;&nbsp;&nbsp;&nbsp;1,2,3...# of customers<br>Client2&nbsp;&nbsp;&nbsp;&nbsp;1,2,3...# of customers<br>Client3&nbsp;&nbsp;&nbsp;&nbsp;1,2,3...# of customers (all unique to Client)<br><br>I have...

<br>The Twelve Days of Christmas:<br>Each year, a National Bank of publishes a Christmas price list. <br><br>(See table 6.11) Write a program that requests an integer from 1 to 12 and <br>then lists the gifts for that day along with that day's cost. On the nth day, <br>the n gifts are 1...

I have a query on a table (that has only one field) that strips out specific rows that I need to process...<br>an example of one of these that I am processing is:<br><br>&nbsp;Query (specific...

Does anyone have a Data Model for receivables system that tracks and applies payments to invoices?<br><br>A simple receivable system has a foreign key from tblCashReceipts on CustomerID...what I need is to track and apply payments by invoices.<br><br>I know that I need to change my foreign key...

I am trying to set this up so that I can do aged receivables and am trying to figure out what other fields&nbsp;&nbsp;I would need...help <br><br>tblCustomer<br>CustomerID/LastName/PrincipleBal/AgencyInt/ CurrentBal<br>&nbsp;&nbsp;990291&nbsp;&nbsp;/&nbsp;&nbsp;&nbsp;RICH&nbsp;&nbsp;&nbsp;/...

Hi,<br><br>I have a bank (lockbox) file that I need to import into 3 different tables on a daily basis.<br><br>tblFileHeaderLayout&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;= 1<br>tblBatchHeaderLayout&nbsp;&nbsp;&nbsp;&nbsp;= 2<br>tblDetailHeaderLayout&nbsp;&nbsp;&nbsp;= 3<br><br>The file has three distinct...