calculated textbox
Fri, 12 Dec 2008 01:50:01 -0800
i have a report based on a query with many fields among which are:
"gross price" (euro field) and discount zone fields as following: "africa";
"europe"; "special" (number fields e.g. 40,30, etc.).
i have a form that contains a combo that the user can select discount zones
(africa, europe and special). i want ...
|
Export to Excel Cuts Off Data
Thu, 11 Dec 2008 19:43:02 -0800
I have a report that I am exporting to Excel. If the total characters a
field on the report exceed 255, then they will not carry over to Excel. It
will only export the first 255 characters of each field. The fields that are
cutting off during the export are of the MEMO type in my access database. ...
|
Resetting autonumbering in the New Year
Thu, 11 Dec 2008 18:02:03 -0800
We have 35 controlled documents that are issued throughout the year,
generally in packages of 10 to 25. Each controlled document has its own
control number, which is set by the database based on date of issue. So, for
document Walking the first package of 10 issued in 2008 had numbers 08-0001
through 08-00 ...
|
Printing earliest report of name selected
Thu, 11 Dec 2008 17:41:01 -0800
What I need to do is print a report that will only print the last entry of
that selected Name, not the complete last record of all entries. Now I know
how to do a qwery select by name, but I do not know how to get just the last
record of that name. Any help would be greatly appreciated. ...
|
Automatically create multiple reports from a single report
Thu, 11 Dec 2008 16:13:01 -0800
I have a table that has release/project, project manager, issues, risks, etc.
I need to have each release/project in its own separate report. At this
time I'm creating one report for each release/project then printing to a PDF
(using PDFCreator). I'd like to know if there's a better way to do this
automat ...
|
Can Access reports be in another MDB
Thu, 11 Dec 2008 15:30:04 -0800
We have a very large Access database that uses SQL Server as the backend
datasource. Many of the reports in the database apply to all users and
therefore are part of our 'core' .MDB. We are often asked to add new reports
which are 'custom' reports which apply to only certain customers. We do not
want to a ...
|
Querying within a report?
Thu, 11 Dec 2008 13:51:03 -0800
I work with a large database where we track study subjects' participation in
activities and questionnaire returns. I have created a report based on a
query to streamline a certain process using a parameter that allows me to
search by subject ID number to pull up relevant information. Is there any
way, once I ...
|
|
|
Decimal Trailing Zero Formating
Thu, 11 Dec 2008 21:15:30 GMT
Im working with a numeric field that infrequently uses decimals. I know that
Access 2003 does not store trailing zeros in the number field but would like
to show zeros when printing reports.
I would like only to show zeros for non integers so the report would read
1
2
3
4.01
4.02
....
4.10
5
I ...
|
Problem with a Graph Report
Thu, 11 Dec 2008 12:30:17 -0800
I'm trying to create a report with one summary horizontal bar graph that will
change monthly depending upon errors produced. I've got the query done, but
when I insert a chart into my report and try to select the fields I need, I
get the message box, "You can select up to 6 fields to use in your chart".
The ...
|
Reports exporting data to Word/Excel templates?
Thu, 11 Dec 2008 11:25:01 -0800
My main question is whether or not this would even be possible, I'm using
Office 2003. I have a few different Word and Excel templates that I would
like to be filled out with data from my database.
In the word document, there is a table at the top that serves as a header
for the document, and I'd like th ...
|
