I have attached the database with this question. what I am trying to get is the report based on the Classification.
I am looking for something like this
CustimerID 123456
Classificat...
I have a MS Access report that I have grouping by a field. The purpose is to have a set of receipts for purchases, so right now let's say I have 10 customers - it groups their purchases but j...
HI there
I need to identify the first row on a page in an MS Access Report. There may be a Header before the row. Maybe if there is a method to return the number of rows on a page it can ...
Hello,
I have a Access database which contains simple form of the items that entered during the week. I am accessing that records as a all record and it shows in asp all the entered records...
My report is set up to respond to parameters provided by the user. Even if the report is very short (one or two lines of sales) I still get a blank page at the end with my report footer(which ...
I want to run a macro when my report is opened.
In properties - event - onopen I have
Docmd.runmacro.mcrdc
IWhat am i missing?
I have a select box on a form where the user can pick multiple project numbers for the report. I want the numbers selected to show in my report header, however, I can only get it to show the ...
The user would like the Funds and Services for a FileNo to show a certain way on the report. The problem is I don't have the same number of records for both. I might have 2 funds but 3 servi...
I have a database iclude date field. I create a query lie this:
SELECT dataentry.Month
FROM dataentry
WHERE (((dataentry.Month) Between [enter begin date] And [enter end date]));
Now , I c...
I need to limit my details on each page of my report with out losing my Group footer. When I used the suggested solution that was out there.
Private Sub Detail_Format(Cancel As Integer, Form...
I have records in a table that have Date/time field (datefield) in them. I need to sort by Date (Descending) and then by the Time portion (ascending)of the field. I am reading notes from t...
I have developed a main form with several sub forms to pull together cost data for a job.
Specifically, the subreports include labor cost, parts cost, invoice totals, etc.
When, I try to p...
I have a report that has two pages. I used a page break in this report. Then I made a new report and used this report as a sub report in the new report. Problem is that it doesn't recognize th...
I'm new to Access 2007 and am using it to upgrade a wholesale/stock control system. Orders to suppliers might or might not involve FOB charges or agent commissions. I have placed these values ...
I am trying to build a report that uses a date range to filter the report to specific records. The report its self has 6 subreports used to consolidate data and total the number of records. ...
Hello Experts!
Small problem. I have an input form for my database. I alsoI have a search form built for my database. What this form does is, when you do a search, it will return the record...
I have a report containing a graph that looks fine in preview but when printing to pdf or printer, I may only get an empty frame. I tried changing the page size, graph object size, printer set...
I am creating a form in MS access, I'd like to put a button on the form which will e-mail a report to the "relevant people."
I found a button in the tool box and if you click on reports the...
I created a report using the wizard that pulls data from two tables (computer and software). Each Computer can have multiple Software records.
A page from the reports is attached.
I ...
I've created a Ready Mix Concrete Database that tracks all of our orders. I have reports setup that we can pull from any date range we would like and see how much it is costing us to deliver t...
I have an access report that shows labor types. This field is suppsed to be a text format and not numerical. It contains values like Half-Time, Full-Time, Burgers R Us, and fractions like 2/...
I have a report in access 2003, the data source is a query. When there is a left paren "(" in the data I want to add a carriage return and a tab so it appears on a new line...any thoughts?
I am trying to round to the nearest .125 in a control on a report. I've tried using the ceiling function, but I always get a value input box asking for the value of Ceiling. I have a referen...
My Access report is grouped by Hospital, then by Name. There can be more than 1 record per person in 1 hospital. I want to count the number of people per hospital (not counting the multiple re...
>>>Please read carefully... there are a few subtleties to what I am trying to accomplish...
>>>I will be happy to answer any questions to clarify my objectives prior to awarding points.
I ...
