Recent content by jfirestone

Here is my query as it stands. SELECT t.AR_OPN_CUS_NO, t.AR_OPN_DOC_DT, t.AR_OPN_DOC_DUE_DT, t.AR_OPN_DOC_TP, t.AR_OPN_DOC_DT, t.AR_OPN_DOC_NO, t.AR_OPN_APPLY_TO, t.AR_OPN_REF, t.AR_OPN_AMT1, t.AR_OPN_AMT2, Sum(t.Sub) AS SumOfSub FROM AROpen AS t INNER JOIN FindBalances AS q ON...

I changed the input mask in the report, I can't change ANY of the settings in the actual table because it is linked.

When I do that, my data returns like this 1234567890 It does not show correctly on the report. Even if these are letter, shouldn't I be able to display them any way I want? Could it be that I cannot modify the information that is directly linked (as opposed to imported) from this other...

I have a silly little problem I need help with. I have a text field in my report that is actually 10 digits (the field is formatted as text - cannot be changed as it is linked to a database in another program) 1234567890 I need it to look like a phone number 123-456-7890 I use this as my...

THATS IT!!! Thanks Pat!! This works perfectly. You are a genius! Lister, I appreciate the effort, but I don't need to enter any info through Access, just look at the info I am inputing through Macola. I moved in my table name, my real field names, played with it a little bit (since I...

The info I am manipulating is all actually handled through another piece of software called Macola. It works on relational databases just like access. There are about 100 different database files that the program uses. So there is a compltely different file that associates each invoice number...

Maybe I need to rethink this for a minute.... i have a different idea of how to solve the problem, just don't know if it is possible. I have a query only showing me the open invoices and payments for my customers. The problem is I don't have any other info than the Customer Name, Apply to...

Okay, here is my follow up. This query you set up works almost too well. What I mean to say is, that it gets rid of too much information. When the qrySubTotal is run, it only shows the open balance on a particular invoice. Is it possible for this to Show all the transactions relating to...

Wow, great breakdown! I do have all the info in one table, which I don't seem to have a choice about as the program I am pulling this database from has everything together. Right now, I have no choice but to pull my data through Excel as the date coming out of the file looks like this 20040404...

HI all! I need a little help with a query that isn't returning EXACTLY the info I want. here is what I am currently getting... Cust NO. , Name , DocType , DocDate , DocNum , DocApply , Subtotal 001436 , NBK , Invoice , 2/3/2004 , 212034 , 212034 , 90.00 001436 , NBK ...