Recent content by sowhatnow

Oh..you're a doll! Thank you ever so much! We are excited over here. Now I have to understand views and what my customers can and can't do.

Hi, okay now I'm really feeling inadequate. How do I name a query in SQL query (I'm using SQL server and stored procedure)? Thank you for all your help.

Hi, Sadly, no this doesn't work either. I get an error: Invalid object name 'glno filter'. Thank you for all your help.

Hi, Actually, I want all the sourceid for the grouping of contactno and glno which totals to 0. example: 344 and 345 shows up because their contactno 0000001 and glno PCP summed together (1 + -1) = 0. Can it be done?

Hi, sourceid contactno glno totalamount (int) (varchar) (varchar) (money) 265 8652240 AR 42.1 269 8655704 AR 13 219 4530329 AR 315 344 0000001 PCP 1 345 0000001 PCP -1 207 4264319 AR 79.02 247 6632467 AR 32.4 sourceid 344...

Hi, No errors but still didn't work. I should have had two sourceid displayed.

Hi Fred, Thanks for the catch. It is table tempForARTable3 and your solution did not work. I got an error. Server: Msg 147, Level 15, State 1, Line 1 An aggregate may not appear in the WHERE clause unless it is in a subquery contained in a HAVING clause or a select list, and the column being...

I need help by today if possible. I have a table called TABLE1 containing sourceid, contactno, glno, totalamount I need to pull all the sourceid where the totalamount =0 for the grouping of contactno and glno. Here is what I have so far but it keeps erroring out. select sourceid from...

Just to let you know, Crystal 9 will not support windows 95 and lower.

Got the same problem. I ended up putting it on the page header instead of report header..

here is what I do: in the mdi form: Private Sub MDIForm_Resize() 'centers the child form Call Module1.CenterChild(ChildForm) End Sub in the module: Public ChildForm As Form Sub CenterChild(child As Form) Dim xTop As Integer Dim xLeft As Integer If child.WindowState = 0...

Thank you everyone for your response. Wayne1954, I saw an example on what you gave me. I understood it if the data resides in .mdb. How on earth would I modify it to grab the data from a .dbf file and the correct syntax? strSQL = "select * into [tblRecords] in _...

Thank you but we don't want to use the DTS package and the import wizards. We tried to program that capibilities but no luck. This is why we are doing the data environment method. the network guys changed SQL server stuff so we can't use BCP. I tried the insert statment but I didn't know how...

I need an answer today if possible! I have a dBase file (apimport.dbf) attached to deChase data environment with connection called cn_dBase. That table is called apimport. I have another connection called cn_SQL with a table called tblRecords. That is connected to the SQL server 7.0. Using...

Thank you for your quick response. The datareport is the data designer for reports in vb. I was thinking on the line of "on page 1, page break after 12th records, else page break on 14th record." I don't know how to code this and neither could the other two programmers in my area.