Recent content by ineedahelp

I seached for your FAQ on static column headings and found one http://www.invisibleinc.com/divFiles.cfm?divDivID=4...but I received an error message saying that "the page has experienced an unexpected error". If you can refer me to another link I would appreciate it...thanks!

Hi, I am back after trying many attempts to get this report working. As you have stated the subreport is causing some issues, and I did successfully create a union query with my 2 xtab queries, but am having a tough time getting the layout my customer wants. Any suggestions will be very much...

I think I figured it out...I just had to change my heading to text "values" instead of 01-2009..... hopefully this will work and thanks for your help again!

Thank you for your suggestion. I have created a new query and it works for fields FullName, Description, MemberID, YTDTotal. Both crosstab queries calculates totals for each month. Do you know how I can "present" them in each SELECT statement? The query output shows them as 01-2009, 02-2009...

I am trying to produce a report using two crosstab queries. Each query works well on its own. When combined I get an error message "syntax error in query expression Format([DatePerformed],"mm-yyyy") I think I might have too many characters. Any help? Thanks! Here is my SQL... TRANSFORM...

You are the AceMan...thanks...works like a charm and makes sense too!

I have a form (frmMainData) with a combo box (comboFindClient)and a subform (subfrmPayment) with a multi select list box in the header. The SQL for the recordset of the list box is as follows: SELECT JobInfo.JobID, JobInfo.JobDate, JobInfo.JobDescription, JobInfo.BilledOn, JobInfo.Paid...

Thanks for your guidance and your suggestions!

I have a table with a field called [FeeAmount] which represents the cost of a business trip. At month end [FeeAmount] or a portion of [FeeAmount] will be assigned an accounting treatment in field [AcctAction]. For eg, [FeeAmount] could be $1000 and at month end $500 of it will be assigned the...

Thank you very much for all your suggestions. The Load event helped and my problem has been solved.

I keep getting an error "object doesn't support this property or method" whenever I try to set the focus to the control [DatePerformed] on my subform. NOTE: it is a new record which may be an issue... (I added the stars to highlight for purposes here) Private Sub cmbAddTask_Click() Dim...

I keep getting an error "object doesn't support this property or method" whenever I try to set the focus to the control [DatePerformed] on my subform. NOTE: it is a new record which may be an issue... (I added the stars to highlight for purposes here) Private Sub cmbAddTask_Click() Dim...

It seems that if I create a query and select IT as my control source I am ok. I only get this error when I put the SQL as the control source...is this a bug or am I missing something?

I keep getting the error message "cannot use the crosstab of a non-fixed columm as a subquery" when I try to view my report. The SQL for my crosstab is.....TRANSFORM Sum(IIf([FeeAmount]=0,[ProjectMember]![Rate]*[taskperformed]![HoursWorked],[TaskPerformed]![FeeAmount])) AS TotCap SELECT...

I think the union query is going to be my answer...THANK YOU!! I did read somewhere that "don't use aggregate function in union query in Access as it may drop records". Have you had any issues using Aggegate (sum) functions in a union query? I am using ms access 2000 and would like to...