Search results for query: *

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

Thank you I will look into Union queries and try to figure it out. As with most questions I have had with Access, the answer is quite simple it is just trying to figure out how to get there that slows me down...thanks for your help thus far.

FeeAmount will be greater than 0 if a Vendor is utilized for software maintenance or license fees or a Vendor Consultant travels thus generating a Travel Expense. If a Vendor Consultant "works" then HoursWorked*Rate will be greater than 0 as well. I hope this answers your question. Can you...

Vendors can have three "fees": software license fees (FeeAmount), software maintenance fees (FeeAmount) and consulting fees. My ONE report needs to display these three GROUPS of fees. The trouble comes for me with the consulting fees...they consist of TWO expense items: travel expense...

The Vendors will be supplied via a combo box. I will ultimately need to incorporate this variable into my crosstab query. The Where clause SHOULD be selecting only those records that have "Travel Expense" or "Consulting Services" in the field DESCRIPTION. I have fixed this since I last sent...

Yes, here is the SQL for one part of the report (software maintenance fees and license fees) .... TRANSFORM Sum(TaskPerformed.FeeAmount) AS SumOfFeeAmount SELECT TaskPerformed.Description, Sum(TaskPerformed.FeeAmount) AS YTDTotal FROM ProjectMember LEFT JOIN TaskPerformed ON...