i have a table of stores, products & sales value.  each store can sell up to
500 products.  i want to produce a report, grouped by store showing only the
top 15 products by sales value.
can anyone help?

I'm using Access 2000 - I'm running a query on a table that contains one
field of hyperlinks and using the report to output the findings.  However,
the Hyperlinks are not 'clickable'.  Can this be remedied to allow me use the
hyperlinks when viewing a report?

I have problem with a single page report of statistical data.  The report
contains calculated controls only all using the dcount function and the
report is unbound.  It displays fine in print preview but all fields return
'#Error' when printed.

I need to create a query and/or report that will only display specific pieces
of information. In column/field 'A' I only want to display the records that
have that particular field populated...I also have column/field 'B' and i
only want that information to display along with the ...

I have a database that I developed on my computer but is being run throughout
our office.  On my computer the formula to print the date works correctly,
but on the other stations the result becomes #name?#.  On the stations with
this issue, they are missing the ActiveX control ...

I have a report with this record source:
tblPKCGMaterialAttributes.txtProfileID)) INNER JOIN
tblPKCGFinishingAttributes ON tblProfiles.txtProfileID =
tblPKCGFinishingAttributes.txtProfileID) INNER JOIN tblProfilesRevisions ON

I would suggest a simple feature would be a "print label" option so you can
stick info about a given asset on the asset.  Especially the Asset ID number
and any of the other items that you might want place on the label.

Dynamically changing text boxes and labels based on a
Crosstab Query
I have a crosstab query which gives you the number of
audits performed by auditors for each of the past 5 years

I have made a musical database where the field name is categories. Th
type of music are rock, soft rock, hard rock, rythm and blues, an
classical with the artist names and titles in other fields. I hav
sorted and grouped  and have a total of each category. What I a

Is there a way to do an if then sum in a report
What I want is somthing that will pul
If [Future_int] is <11 and >5 then sum [current_balance
Where the current_balance ends up being the total for all account

I am doing data base design which includes the design of
many reports and mailing labels.  The work is then
installed on other computers which have a range of
different printers.  I understand that the reports and

I would like to change the currency format of values in report details based
on the country of origin, i.e. pd sterling or dollar signs, using the country
field to force the event, is there a VBA process to do this?

In an unbound text box on a report I wrote the statement  
=IIF([Trip]=yes) OR ([Pres]=yes) OR ([Yrs]=>9),([Last Name]&" ,"&[First Name])
I expectd this to return a list of members who met any 1 of the arguements.
Instead I get all sorts of error messages.

When printing off labels I gat a message when open the report stating that
there is not enough horizontal spacing etc etc how can I suppress this
message and stop it from showing everytime?
Thanks

Is there a way to resize a font to "make it fit" as it is in Word?  I am
printing to a label that should fit everything properly, but in case
someone puts longer information in a field, is there a way to
automatically resize the font so it will fit into the text box that is