Search results for query: *

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

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

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

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

I need to create a report using a crosstab query that summarizes by month fees incurred. there are three types:license fees, maintenance fees and consulting fees. because consulting fees need to display different information than the other two, I thought of doing a subreport linked to the main...

Hello, I have created a crosstab query to summarize my data by month across RESOURCETYPE. The final column in my report needs to display sum for each RESOURCETYPE. I need to sum over the group and then over the whole report. I think my trouble lies in my YTDTOTAL. My main trouble is that my...