I'll do my best to explain what this chart should look like. My main problem is that in the chart wizard I can't select the custom chart I want to use. Once the chart is created I can't figu...
I have a report that as a variable [BalReason] in it so that when the report is opened it prompts the user for input that is added in to the report. I would like to now have the input box tha...
I need to total selected records (selected by date range), probably in a report and then divide the total sales by the customer count. Here a selection of the records. The total of the sales...
I have a query that pulls information from a table. In the table there are checkboxes. I want to produce a report based of the query which displays the different fields from the query. I also ...
hello experts,
I have a report with the following sql and would like to display only the records that have a count of [FacilityDetailsID] >1 under the tblFacilityAmountHistory. In other word...
This is a simple problem but I cannot figure out what is going on.
I have a report in Access 2003 that shows some data from a table called Tags. That piece works fine. I however, want to s...
I have a Main Report which contains several unlinked Subreports. Within the Page Header of the Main Report, I access the begin date and end date which were populated in another form as follows...
I have the following database named db1.mdb. The database has two tables. Please see below (attached image) for the information. I attached the database as well.
From this two tables I wo...
I am creating a report containing team members, grouped by team supervisors. A team may contain anywhere from 3-5 members. The report must display the team members grouped under their team s...
I recently obtained a solution at the link below where code loops through tblCustomer and match records of each CustomerID in tblW - then it will first print each report as it creates it and t...
where can i find the cr viewer file so I can use Crytal reports 11 in MS access?
i need to open Crytal reports 11 files but from ms access. i have 8.0 view on my system but it does not work. ...
I am trying to build a report in Access 2007 that displays a record (that has a time/date field) with a specified week of the year and also displays a corresponding record from the same table ...
I have a combo box (cboShowNames) and a button (ShowForecastReport)
Goal:
The user selects a show name from the combo box and then clicks a button that is programmed to run a specific repo...
Need assistance on the creation of some professional looking reports from msaccess db.
Actually what is reports ?Why it is used to?How it is made?
Please advice....
I have a Report in a Access 2003 db that Fiilters the records form an open Form using "Forms("Clients").[W/O]". When I use DSum to toal a field value, I get a total of all the records in that ...
Boag2000,
A follow up question to your solution came up.... what is your best idea for making a control within the group visible on successive iterations of the print?
For example, the r...
We've been printing multiple copies of a Word Document on 4in X 2in labels on a Zebra LP2742 label printer and the labels print without pausing after each label printed. Now we're printing...
My Access pie chart is flaky. If I batch report hundreds of reports the pie chart eventually stops printing. I've created a bar chart using colored rectangles and code to reproduce the chart...
I have a couple of reports. They require parameters in order for the query to run.
Right now they popup your standard messagebox per parameter asking for start and end dates or the name of...
Hi experts! I have an access report -- actually an invoice that I generate and email to clients. I chose to create this in snapshot format - and it looks beautiful. recently I had a client s...
I have a report that is based on a composite query that requires a parameter. I want to be able to open this report from a form and pass that parameter programmatically. From what I've seen,...
As i am working with crystal reports i need to set the page width as my web page design.
Hi,
I'm writing reports in Access, using outer joins in the query that the report is based on. This means that some fields will be blank for some records, as there is no data there.
The ...
If I was generating a query I would use
WHERE ((([Application Title and Key].[Application Status])="Eligible" Or ([Application Title and Key].[Application Status])="Suspended" Or ([Applicati...
I am using a text box with '=1' on a report to count the number of records on the report. It's Running Sum is set to 'Over All'. The record source for the report is a query. When the query do...
