Search results

Thanks Rich. One small problem. When I input the sales data for the salesperson I select whether the vehicle is NEW or USED. So for each month I need to see the total of NEW and the total of USED. The crosstab worked beautifully but it is totaling the NEW & USED instead of separating the...

I am having a tough time getting my report format to look like my old Excel results. I would like to have SalesPerson down the first column and JAN FEB etc across the top. Earch SalesPerson row would contain 2 numbers one for new and used cars sold for that particular month. Currently I...

It is the company goal for the month NEW and USED. Not tied to individual salesmen. There is another form where I will enter the daily sales totals based on individual salesmen. Clear as mud?

Hello All, I'm not quite sure how to ask this question, but here goes. I am attempting to build a database for a car dealership. They have sales objectives that they want to enter for each month. What I would like to do is build a form and subform to all them to enter: MONTH YEAR combo for...

Solved by Me Well after typing out that post a thought began to materialize in my brain and this is what I came up with: zz = Me.InputDate.Value - Me.SourceDate.Value xx = Int(zz / 14) mydate = (Me.SourceDate + (xx * 14)) Me.StartDate = mydate Me.EndDate = mydate + 13...

Maybe it won't be a challenge for you all. Here is what I need to accomplish: I have developed a database to help me with payroll. Currently I use a table for the start date of each pay period (every two weeks starting on a Thursday and ending on a Wednesday). So it is a simple thing to...

I have a query that lists a SalesPersons information for the month. Date of Sale (MONTH YEAR) Date of Goals (MONTH YEAR) we set this at the beginning of the month Date of UPPS (MONTH YEAR) total of customer visits he has done for the month I have a form that allows me to search through my...

Are you using a query to generate your report? You can do a count entries within the query and then average from there.

Sorry I edited my post as I answered my own question before your reply. Anyway thanks again for the help.

Thanks for the help this is what I finally came up with from your push. SELECT DISTINCTROW tblEntry.tblPilot, tblEntry.tblBase, Sum(tblEntry.tblRevenue_Hours) AS [Sum Of tblRevenue_Hours], Count(*) AS [Count Of tblEntry], tblEntry.tblDate, tblEntry.tblTime_In, tblEntry.tblTime_out...

Hello All, I am trying to open a report filtered by a date range (that part works fine) and also based on a value from a listbox when the user selects another criteria for the filtered report. That is where the problem is occurring. I have a report named rpt_DutyTime (under properties filter...

Are these pictures ever going to be approved for posting? It has said pending for quite some time.

Thanks fellas. I can always count on this forum to help me through. Both suggestions worked just fine, BTW. I went with the DateAdd since this was the line I was taking before I came to you all.

Hello All, I am having problems getting the following lines to do what I need exactly. The formatting is kicking my butt basically. Bob helped with these lines but I actually need the result to be last month. For instance it is now Jan. 07 and I need the query to total up the hours flown for...

Ugh. I really wish I understood queries better. Bob you're a genius, it works especially when I follow what you say EXACTLY. Thanks.

Except I need it to show ALL months in this year and not just the current month and year. Back to the drawing board.

Ok I continued to tinker with what you sent and I used: Format(Date(),"mmmm yyyy") And all is working great. Thanks for the help Bob.

Maybe it would help if I showed you what I have now: Field: Format$([tblEntry].[tblDate],'mmmm yyyy') Criteria: "january 2007" or "february 2007" etc..

The way it is now is on the switchboard form they click a button which then opens a small form that displays the results of the query in a list box. January 2007 128.3 February 2007 229.4 (assuming it was actually next month) But you get the idea. So I put your suggestion in the...

I have a query that allows the user to see how many hours we've flown, sorted by month for the current year. Problem is that in the query I have to manually put in the criteria "january 2007" or "february 2007" or etc.... What I would like it to be able to do is based on the current year (2007...