Recent content by jmueller

Thanks for replying! To RWahlert, I didn't write the report and am not well-versed in crystal to say the least, but I imagine the sub-report was created because of the one-to-many relation. For each invoice, their can be multiple payments and/or credits applied. Also, thanks kskid for the...

Hello everyone, I have a problem that I have to believe has a simple resolution... hope someone can help me: Quick overview of what i'm trying to do: I am trying to export "monthly statement" information to a CSV file where we would then send the CSV to a company for printing of the...

Thanks Mike. I will try it out and respond. Jack.

Sorry about that... I meant to type: xlValues (with the "s"). Also, xlValues is actually nXlValues and xlMultiply is nXlMultiply. Maybe I should "review" my posts hey? I've never used #Define. I just create variables such as nXlValues and assign the constant value to it (as i've done...

Hello, Could somebody please tell me why the following code written in VFP8 does not work with Excel 2000? xlValue = -4163 XlMultiply = 4 oExcel.Range("H6").PasteSpecial(xlValue,xlMultiply,.F.,.F.) With the last line, I get the following error: "Unable to get PasteSpecial property of the...

Thanks Dan, I will check it out this weekend. You make it sound so simple that I fear it can't be true... but i'll see.

Thanks for your replies. I think for the sake of time & effort, i'll go with Stella's. The XTAB stuff just seems really complicated. I tried using the wizard but was not having any luck. Is there somewhere I can get some "simple" sample code that shows how I would program this using gsXtab1...

Hi everybody, Can someone please tell me the syntax using a SELECT statement to do the following (if there is one, of course): I have the following data: Year Customer# TotalSales 2003 ABC $400 2004 ABC $800 2003 DEF $500 2004 GHI...

Thanks you guys. You're all right in that the data is not normalized. There is not any fields in the child table that adds up to the "Amt subject to Commission". Geoff, I have tried the counting the # of line items in the child table and dividing by that number but as you said it became a...

Hi Everyone, Got this darn recurring situation that seems to rear it's ugly head every 2 or 3 years and I thought i'd finally take a moment to find out if there is a solution to it or if I once again have to find a work-around... I have a one-to-many relationship setup between my parent...

It comes down as a date type field.

I tried #01/01/04# but didn't have any luck. Can you tell me what version of odbc driver you're using? Thanks. Jack.

Not sure Chaz... I'm going to go and see! Thanks for responding... let me ask you (or anyone) another question.... I'm using ProvideX ODBC V3.21 with Visual Foxpro to pull data down from MAS 200 V3.71. Everything works fine except when I perform a SELECT with a DATE field parameter, I get...

Hello everyone! Just found out there's a MAS 90 forum... I sure can use some help on this one... There's got to be a simple answer so here goes: I'm using Visual Foxpro 8.0 to pull data down from our MAS 200 tables. Can someone tell me how to add some additional blank fields in a sql-select...

I was afraid of that. In that case, I will look into the MAS forum for help on this. Thanks Again!