Access report date problem.11149 (6/6/2010 9:42:08 AM) UtfI have created a lot of graphs to show various information. The problem I'm
having is that I need the graphs to show the last 14 days of data. The
criteria I have used is >Now()-15. This seems to work fine ...
Prevent skip to new page after last page prints31493 (6/4/2010 10:18:44 PM) UtfI have a page header section, a group header section, a group footer section
and a page footer section on my report. The group header I am trying to use
separates groups of records and skips to a new page a...
report in access (Count)2992 (5/29/2010 3:06:01 PM) UtfIf i have data in CSV file and it show like belwo
Firstname plus Middlename??10936 (6/3/2010 5:31:08 PM) UtfApologies if this is a silly question. I'm trying to combine Lastname,
Firstname Middlename in a report. I have
=([surname]+", "+[firstname]+" "+[middlename]).
The only time it works is if all three fields ...
Total is off by a couple of cents4726 (5/25/2010 8:50:01 PM) UtfI have a report that feeds of a query. The query has the following fields
matsales: [order details]!unitprice*[order details]!quantity
scharge: [order details]!surcharge*[order details]!quantity
filrter several reports21171 (6/3/2010 6:51:42 PM) JOSELUISI create an unbound form to filter a report and i paste the following code in
the filter button of the form, and it works perfectly; but my problem is that
I need to build this filter to most of my reports s...
Opening Report Closes Database11061 (6/3/2010 3:59:54 PM) UtfI have a report with a subreport that closes the database every time I try to
Preview it or open it in Design View. The subreport will also do this if I
try to open it independently. The queries work fine...
Report formatting hangs31903 (6/2/2010 5:23:07 PM) UtfI have a report (rptHV) that uses a query (qryHV) as its record source. The
user opens a form (frmHVClient), chooses a name from a combo box, and then
clicks a command button (cmdClient) to run the report....
Report only displaying some info1830 (6/3/2010 5:17:05 PM) UtfBackground first:
I have a database for tracking contracts. Some contracts are
straightforward and only cover one service but the bulk cover multiple
services that will be performed at different times. ...
Need Specific Data31027 (6/3/2010 2:27:56 PM) UtfI want to be able to count data in a field in my database. The field is
Under attendance are options like ATTENDED and REFUSED and SICK etc.
I want to sum up all of a persons attendance...
Printing a report 2-up31995 (6/2/2010 10:47:37 PM) UtfHow do I go about creating a report that retrieves data from my table and
produces a report of that data 2-up (side by side). ! record on the left and
the next record on the right?
Thank you for your...
Display multiple records from same ControlSource11151 (6/2/2010 5:43:43 PM) UtfI am trying to display multiple records in one text box on a report. I can
get it to work if I put the text box in the "Details" section of the report,
but I need it to be displayed at the bottom of the rep...
Subreport Keeps Repeating Itself65920 (6/1/2010 4:52:04 AM) Joel_123Hello,
I am having a problem with a report. I am trying to print out paystubs for
employees over a given time period. I have a start up form in which the user
types in the “StartDate” and the “EndDate” o...
Highlighting a word when it shows up on a report1745 (6/2/2010 5:43:42 PM) UtfHello experts. This may be wishful thinking, but can access do the following:
lets say I have a table with 5 fields and the data in each field is at least
an entire sentence (exclu...
Multiple Queries...?2629 (6/2/2010 4:36:18 PM) UtfHello all... This question may be in the wrong place and sorry if so...
This delima throwing me for a loop and any help is appreciated.
Our clients make multiple payments for the same order. They may m...
Creating a Report using Tables (that have no relationships)0939 (6/2/2010 9:02:39 PM) grupyIm looking to create an invoice report that uses data from three different
tables that are created dynamically by a query. The data for these will
but I would like to simply pull the data from thes...
Create Categories1795 (6/2/2010 7:08:04 PM) UtfI have data in a table which I imported from a Survey Monkey excel file. I
have begun to create a report (in design view) using the fields from this
table. My problem is I don't know how to separate (or gro...