Recent content by advpay

There's and Access freeware program that does a great job...go to freeware and its the MDBTask http://www.pb-sys.com/

We have an Access Certified mail program and we scan certified mail cards and use Access with File Magic 5 Series. File Magic is a 32-bit file server document management software suite that provides capture, indexing, retrieval, editing, annotation and distribution of both paper and electronic...

Here's a Select example: SELECT [Sales Order].[Sales Order Number], [Sales Order].[Sales Date], IIf(Not IsNull([Company]),[Company],[Last name] & ", " & [First Name]) AS [Company Display], [Sales Order].Tax, [Sales Order].[Tax 2], [Sales Order].Freight, [Sales Order].Other, [Sales...

What type of query: select, make table...with an inner join? What are the table names and the fields you would like?

Aug 17 ok so no one has a generic payment plan in their database?... ah

get the developers version...from your title I think you want to just make it run time.

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

Thanks, now my table lookup box for that field is MR and the field is still stored in the Customer table as 1; thats great...but on the form I am still getting the 1? I set the control source on the form to the Salutation from the Customer 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, what are you aging? Unpaid Invoices or just balance >0 from some field?, what is your table name and the fields?

Where does change in balance come from...what fields what tables...list the tables that you are using with the field names...please.

Sure...here is the info from my Finance Charge Default table that covers most of the questions. Minimum Days Past Due = 33 Minimum Customer Balance = 0 Minimum Finance Charge = 0 Number Days Between Charges = 33 Use One Month or...

It looks like its stored correctly to me...do you need it summarized for a form or report field?

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

Start by using select queries getting the data you want...then you can add on criteria for what groups of past due periods you want 1-3 months 4-6 months, whatever.<br><br>You mean like this? I want to do an aging of inventory availability....&nbsp;&nbsp;<br><br>SELECT DISTINCTROW...