I am creating a pop-up form to filter a report. I have created five drop down menus, however one of them is not working. The other four work perfectly but when I try to filter using the firs...
I have an access report with several subreports. I have gotten the subreport totals on the main report to show "0" when there are no values but I need the main form calculation to show "0" if...
I am creating an Access report and need to have a subreport on the page that repeats lines until the bottom of the page. The report is a call sheet that contains text boxes and subreports at ...
There are 2 questions I want answered.
1) I have a report which has several sub-reports within it. I want each sub-report to begin on a new page.
2) In one of my sub-reports I want to sh...
Hello,
I have a report based on a query. However the query does not aggregate data.
In the report I have created a text box which counts the number of records satisfying a criteria in a ...
This Access reports stuff is really hard :(
I basically want to do this:
SELECT *
FROM Applications
WHERE Week Beginning =txtInput;
Where txtInput is the input box on the form....
I understand that there is no "Distinct Count" in Access and I can read and understand the logic of most things, but I am not that DB savvy and have been trying to get substrings to work or so...
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 have one tabular design report width many fields (+40). The report width limit (22 inches/55.88 cm) is too small. Is it possible to "break" the report in two "design" pages? I.e in print/pre...
I'm tring to get a Report to sort (OrderBy) AND Filter (Filter) the same way that the user may have specified in the datasheet view in fSubFilingCalendar. (Clicking on the little down arrow in...
Hello Experts,
I have a query (actually many different ones) but for now, just this one that must be ran every month. It finds activity codes from users which are then exported to Excel and...
Hello, I've got a little Macro that prints 8 reports one after the other, however my user wants to have them in one Excel Spreadsheet, with individual tabs for each report. Is there a way to...
I need a master detail report in SQLPlus where the linesize is 200 and has 14 columns of data.
I want the report to break on an insurance company by claim number. Once all the calims have pri...
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...
I have an Access 2003 Report in which I'd like to insert a Word Document as an OLE Object. I need to be able to specify the path of the word document at runtime. How can I accomplish this?
I have an Access report based on a crosstab query. The report is about a single patient and displays about eight different data values that were captured each time the patient was seen. I ha...
Hello
Here is a strange thing. I have an Access database linked to SQL Server back end. I have several reports that run from queries. On one PC when I open a report in design mode and set t...
In my access DB i have 4 columns
A, B,C,D
A=1, B=2300,C=3, D=11
I would like to have another column that has the sum/total of the other Columns by row
1+2300+3+11 E =2315
I don't want...
have a report that I have grouping levels of cities
City1
City2
City3
City4
What I want to do is if City4 happens to be the same as City3 (the group above) th...
I bought a new printer, and now when I try and print a report in Access by clicking the Print Button on a form - i receive the folowing error.
"There was a problem retrieving printer inform...
I am using Access 2007.
I have a report that actually opens a WORD file that contains the report instead of using the Access report writer. I setup the WORD file so that the merge fields co...
How to string manipulation in ACCESS 2003? I have a string "Doe, John M" and I would like to convert this to "John M Doe". How can I accomplish this in query or report? And how to do it vice...
I have a report thats control source = table1. Table1 has the following fields: (1,2,3,4,5).
A combo box on this report has a control source = 72 . Because 72 is not a field on table1, w...
Hi,
In Access I have a query which accepts a start_date and end_dat. To open a report that is based on this query how do I pass in both these dates from a form. See the code below on how far ...
I have a basic Helpdesk CRM tool in Access. There is a form called HelpDesk which uses three combo boxes and writes to a table titled Contacts_CustServTbl
Within the Contacts_CustSe...
