Sales Per caps CrossTab report
Mon, 1 Dec 2008 20:02:08 -0800
I have a sales database which tracks event based sales. Each event is broken
into classifications of "gold" "silver"and Bronze " depending on event and
expected attendance. The Item sales are summarized into categories of Misc.,
Draft, Wine etc. I have a crosstab query/report which summarizes this:
Category ...
|
Parameter Query and reports
Mon, 1 Dec 2008 19:14:00 -0800
I have a parameter query that I run to pull certain dates (ie - 3/1/08 -
3/31/08) and the name of the event that happened in that date range. The end
result that I want to get is a report that lists these dates (which is easy)
and also same events for the prior month and prior year.
I have tried to creat ...
|
Some report lines showing up bold in adobe acrobat pro
Mon, 1 Dec 2008 16:10:35 -0800 (PST)
I have created a dashed line in my report. Some of my lines when I
view it in adobe acrobat pro are bold. Is there a fix for this?
Thanks,
Kathy
...
|
optimized way to make a report?
Mon, 01 Dec 2008 23:06:43 GMT
If I have a report or form based on 3 queries:
1st query pulls data from table or multiple tables and filter by criteria
(for example date interval)
2nd query is based on 1st - it is a total query that calculates sum
3rd query is based on 2nd query - it converts numbers to words by using a
module VBA code.
...
|
alter some printer settings on several different reports
Mon, 1 Dec 2008 14:08:08 -0800 (PST)
I have a report MDB that uses an ODBC database to do its reports from.
I have gotten a request from one of the users to change the default
settings for a printer. Because of how our network is set it the
printer settings for each of the printers get reset after a document
is closed the only thing that can be ...
|
Report consisting of multiple subreports
Mon, 1 Dec 2008 08:48:01 -0800
I 've build a dosen of reports (in shape of tables and charts) summing the
data from different angles. Every report shows gross numbers for all the
clients combined.
Now I want to nest all the reports in one principal report, wich is destined
to be opened from form by selecting cboClientName (ClientID value) ...
|
Highlighting rows in a report based off of information from two ta
Mon, 1 Dec 2008 08:25:19 -0800
Hello,
I am trying to get rows in a report to highlight based off of two different
tables. What I need is:
If ((Table A) and (Column/Category A)) are equal to ((Table B) and
(Column/Category B)) Then (the row in the report) Highlighted = True
I have tried to do conditional formatting, but when I do that ...
|
|
|
Opening report generates error message
Mon, 1 Dec 2008 07:02:02 -0800
I have been using a Access 2000 database for seven years and all of a sudden
one of the reports doesn't work. The report lists 'transaction by time
period' which is very straightforward. Its underlying query asks for a
beginning date and an ending date and works just fine. The report which was
created usi ...
|
Access Report but now show only random records
Mon, 01 Dec 2008 14:50:34 GMT
I inhereted an MsAccess Report. It shows data by group. The user now wants
(for auditing purposes) a random sampling (20% of records) from each group.
So, if group 1 had 10 rows on the original Access report, he wants to see the
same report but only showing 2 of those records, selected at random. I
should d ...
|
New to Chart/Report - Cant make it work
Mon, 01 Dec 2008 12:32:42 GMT
I created a nice little Query that totals up all my data.
Problem is, I can't seem to get the Chart-Builder to make this for me
correctly.
Here's what my Query returns:
CategoryID R1 R2 R3 R4 R5 R6 AVG
1 91 91 82 82 82 82 86
2 75 75 75 ...
|
