|
FULL_NAME conversion
Hi,
I have a table FULL_NAME with Last, First name ie. Doe, John
Would like it to appear in the report as Doe, J.
I know I should know this but... any help is most appreciated.
Thanks,
...
|
3 |
11.09.2006 21:15:31 |
|
|
Showing Select Records in Reports
Greetings,
I usually find most of my answers to alot of my Access issues through
the search, but I can't quite get this one figured out. This is what I
have:
1. I have a Table with all of my records.
2. I have a Form to enter and browse the records.
3. I have a Report that sums up certain information.
What I need is a report that shows only records that have "CA" in the
address field....
|
3 |
11.09.2006 20:06:01 |
|
|
page totals wrong
When access (2002) prints a report of 18 pages the footer count shows 'page
18 of 17' on the last page. Of course the next to last page shows 'page 17
of 17'. The footer program is '[page] of [pages]'. With appropriate & and
text removed for clarity. Anyone got any ideas. TIA
--
MMAPHQ
...
|
2 |
11.09.2006 20:02:42 |
|
|
Displaying Data Across
My data needs to look like this:
ACROSS THE PAGE
Job/Sub No
Pay Item/Cost Code
Mon – Sun (hours worked under each day with Reg Hours/Overtime/Double Time)
Total Column
At the bottom of the page fields need to sum All billablehours in a field;
All billableOT in a field and All billableDT in a field for each day of the
week worked.
? How do I get the hours worked under the days of...
|
3 |
11.09.2006 20:01:02 |
|
|
No Hyperlinks in Reports
Hello, I have a report that is generated from a form and now the user wants
one of the fields in the report to have a hyperlink back to the original
record in the form. I realized (after a lot of frustration) that reports are
not interactive. I was wondering how other people have dealt with this
problem. I saw one solution that involved saving the report to a PDF but I
don't think tha...
|
4 |
11.09.2006 18:09:18 |
|
|
In an Access report, how can I count specific records in a group?
I'm trying to create a report that has the following fields: Date, Channel,
and Track. The report is grouped by Date, then Channel, and then Date again.
The first Date grouping goes by months.
The track field can only have two values, sales or technical. So
essentially what I have is a list by month, then by channel, of dates that
say sales or technical next to them.
What I wan...
|
2 |
11.09.2006 17:48:47 |
|
|
Subforms, changing record source and page breaks
I'm trying to create a report that brings in data from 5 different
tables. Each table has multiple lines of information for different
people. I'd like to lay out 5 subforms on a report page, each with
records from the same perosn, then force a page break, and display the
5 subforms again with records from the next person. Is it possible to
do this? I just don't see any way to change the recor...
|
2 |
11.09.2006 17:32:50 |
|
|
Multiple IIf Statements
I am trying to provide a verbal discription for different values that are
found in my report and I am only able to make this control work for the first
three IIF statements afterthat I get errors. I would like to put the
following into the control box to evalute the number of [CCATVERB]. Is there
a way I can do this???
=IIf([CCATVerb]>=128,"Very High",IIf([CCATVerb]<=127 And
[CC...
|
2 |
11.09.2006 16:02:40 |
|
|
dates in reports
I have a database that holds billing and inventory information. At the
beginning of every month I print a report on the billing data from the
previous month. Almost every month I get one record in the report which is
old data from last year but the date reads the current year. I change it to
the correct date and redo the report and it is then correct. So far, I have
assumed that it has b...
|
1 |
11.09.2006 14:51:03 |
|
|
Suppress printing of value after it has first appeared.
I have a report which I would like to suppress printing of a values once it
has appeared. I have used the HideDuplicate property, but that only applies
to a single page. I really want to print the value ONLY once within the
entire report. I have a VB script that partially works, by comparing the
current page to the previous page; however, it fails when the data crosses to
a 3rd page.
...
|
3 |
11.09.2006 13:16:02 |
|
|
Carried forward balance and skipping pages in print preview
Greetings one and all,
I have a problem with an Access 2000 report for which I cannot find an
answer so any assistance you can provide would be great. The report is a
statement of account, similar to a bank statement, which lists all relevant
transactions with a running sum balance on each row together with a carried
forward balance at the bottom of each page and a brought forward a...
|
1 |
11.09.2006 13:10:10 |
|
|
User defined print range
In Access 2000, WinXP, I created an Access db and installed it on a single
machine and shared it on a small office network. I set the startup so that
the switchboard is the starting form, and the users cannot access the full
menues, etc. Very basic security which is not a problem in my case.
Everything is working well, except for two items.
The first is I cannot print in excess of 66 pages...
|
3 |
11.09.2006 10:39:33 |
|
|
Memo field
Hi all
Is there a way to print roman, bold or even italic text, thanks
...
|
2 |
11.09.2006 10:29:58 |
|
|
print access report into pdf files using VB6
Hi,
I'm trying to convert the access I have written in access into a pdf, I
used this code below, but somehow it gave me an error user defined type
not defined, so I guess it's because I need to add a reference, but
which one? Can someone tell me?
Cheers!
Claudia
Dim objPDF As New PDFClass
With objPDF
.ReportName = "RptCollection"
.OutputFile = "c:\testing.pdf"
...
|
2 |
11.09.2006 10:29:00 |
|
|
Dates Print as #NAME? Error
I run report based on a parameter query between two dates which appear in the
report header after the user has selected the date range. This works fine and
the two dates appear on the report on screen. The problem occurs when I
attempt to print the report, where the two dates are on the screen they just
print out as #Name? on the hard copy.
Any help much appreciated!!!!!
--
Message pos...
|
2 |
11.09.2006 10:09:37 |
|
|
Help on reports error
I have created 2 Reports based on indepent queries (but child master linked).
The 2nd Report contains a procedure (to insert a set amount of lines 'On
Print)). Both work well alone.
I have inserted the 2nd report as a sub report into the first report.
When I print (or print preview) the 1st report is ok but I get a 'The
expression ON Print you entered as the event property setting produced ...
|
1 |
11.09.2006 09:17:02 |
|
|
chart with aggregate and individual records
I am completely new to making charts (in Excel or Access) and it's
bewildering to me right now. Before I get up too much speed heading into the
learning curve, I would like to get a better sense of how possible is it for
me to create a chart in Access (perhaps an area chart?) that:
1. has on the X axis values or scores of 1-100, and on the Y axis number of
records for a group of records;
...
|
1 |
11.09.2006 03:43:51 |
|
|
Timetable
Hi, I am trying to create a time table report for an organisation I
work with.
I have tried using a crosstab but this doesn't work.
This is what I want the report to look like:
Monday Tuesday Wednesday Thursday Friday
9.00 joe joe
adam dave
sarah
10.00 george
j...
|
5 |
11.09.2006 00:09:51 |
|
|
Report using more than one queries?
Hi !
I am a very basic user of Access. I want to know can we run a single report
using more than one queries?
one field coming from one query and other fields from another query.
Thanks in advance.
Regards....
|
11 |
10.09.2006 16:40:02 |
|
|
a simple report for ASCII (e-mail) output
Dear list members,
I have an MS Access (2003) database that contains news articles. The
data fields include: date, title, author, source and contents. I would
like a Report that generates ASCII output (which can be e-mailed) in
the following format:
10 September 2006
Indian police chase leads after mosque blasts kill 31
International Herald Tribune
MUMBAI, India Indian investigator...
|
1 |
10.09.2006 10:12:25 |
|
|
Subreports being split over pages
Hi I have a report which has 5 seperate subreports (Currently in detail
section however could be moved if required) for showing an employees
productivity in the various tasks they perform. This report normally goes
over at least 2 pages but quite often the subreports get split in half which
makes it a little hard to follow at times. Is there a way of getting each
seperate subreport to either ...
|
2 |
10.09.2006 09:34:44 |
|
|
date range
Dears,
I have a report which pulls info. on date range, but if no data processed
within these dates, it gives me a error. I need the field that shows error
i.e. a total field with either zero or a text message
thanks , any help will be appreciated
...
|
9 |
10.09.2006 04:29:48 |
|
|
Printing reports
I have a button on a form that prints a group of reports. I need to be able
to tell it that if the report has no data, skip it and move to the next
report. The problem is that each report has a date at the top and access is
assuming that qualifies as data, and print empty pages with a data at the top.
Is there a way around this?
...
|
7 |
10.09.2006 02:19:01 |
|
|
repost - bind a virtual recordset to a report
hi folks. i posted this question a week ago - see below - and got no
response. it *is* long-winded, and i apologize for that; i tried to paint a
clear picture so as not to waste anybody's time in a long Q&A. i'm hoping
somebody either has a suggestion, or....even a positive "it's not possible"
response would be helpful to me. any takers?
tia, tina
**********************
hi folks,
...
|
11 |
10.09.2006 01:02:16 |
|
|
Count ONLY once
I've got a report which includes both people and events. All people have
events and all events have people (field name PeopleID), but some people have
more than one event. In the report footer, I want a field that counts the
people only ONCE... regardless of the number of events associated with that
person.
Help?
--
Thanks for your time!...
|
5 |
09.09.2006 22:15:15 |