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 an Access 2003 database which is used to print an Invoice into a pre-printed 8.5 x 14 form in the printer.
The report design uses an Ole (Unbound Ole Frame) of Microsoft Word.
The u...
I have built an Access 2007 report that shows 2 rows of sales data from each of a bunch of store locations. My table has the date, the location and the sales_amount. I grouped my query on loca...
I am a novice and do not use VBA. I made an extensive report with data on Organizations and I then I discovered that I want to make hyperlinks with anchors in it so that when I publish this re...
I have a microsoft access report where I want it to count a specific field. The only thing is the field contains text from A thru G and I need to count how many A's, B's, C's, etc and give m...
I have just been made aware that now our company needs to have company registration numbers and possibly Vat numbers on every outgoing email.
Is there a simple way to set a template for al...
Hi all,
I should know better and it's probably laziness (Or I'm just too tired) on my part but can someone help me out here?
I have 2 tables in an access 2003 database.
Each have field1 ...
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 ...
Using Access 2003, I have a report with alternate row back color using the code below. I have a field called CaseWeight. I would like to apply conditional formating with a black background w...
In a field in an Access report what is the syntax to display a date/time field as MM/DD/YYYY HH:MM in 24 hour format not AM/PM?
I have a letter in 2 versions 1 in english and 1 in spanish that group together on a members Zip Code and then the 5 closest help centers to thier zip. I created each version as a subreport i...
msaccess.exe - application error
the instruction at "0x300101fa" referanced memory at "0x00000330" . The memory could not be read.
*We only recieve this error when we run a Access 2003 re...
Hi,
I have a form which sends data to a report. For some reason its throwing up a Runtime error 3075 "Syntax error, missing operator".
Google says its missing a comma somewhere so ive ...
My report contains fields along with 9 subreports in the main detail section. The subreports repeat throughout. For example, for Record 1, the GENERAL info in the detail appears once, SUBREP...
I have 4 fields, lastname, firstname, grade, schoolname
I created sql base on these fields. A report is based on this sql.
Now I would like to have user can selectable sort section , for exa...
For some reason when I try to drag an individual detail field into a header section like I've always been able to in 2003 I cannot, the detail cells are grouped to their headers and I can't se...
Hi Experts,
I am having problems adding up totals in my report colums. What I have is a query that does some basic selects, then a crosstab query groups the data I need for me and counts t...
I have a report that is being Sorted and Grouped by the following fields:
LPName and
Year
Up until today this worked perfectly until I ran across a problem. One of our accounts has two se...
I have a report and in the detail section of the report I have a field that needs more width than 1 line permits so i want to just move it down beneath the other fields but 2007 just moves the...
Ok so I have a table with the major event time timelines and a query which calculates all the days a the unique ID, Application Assigned Number, was suspended.. So I have used an inner join t...
Hello experts!
I have a report in which I would like to skip the footer if a detail value is null -
For example
Header 1
Header 2
Header 3
Detail ----- If a field value ...
I have a SQL view with a line to mask SSN field for specified records written like this:
SSNshow = CASE WHEN C.ID in ('SBAO','MCLT','SBAIPT') THEN " ELSE E.SSN_taxid END,
(C.ID and E.SSN...
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....
hello,
I am creating a database (SprDB), and I generate a report (frameshet) which comes from a table in the database. One field in the table is description (a multi-line summary). I wa...
Following the help of
http://office.microsoft.com/en-au/access/HA011170771033.aspx
I have generated a output of a query as report through a form to input the parameters.
I tried using th...
