I have a database that is split into a front-end (.mde) and a back-end
(.mdb), with the BE residing on a server and the FE installed on each user's
computer. I use several temporary tables in my application, and I currently
have these temporary tables defined in the FE to avoid ...

trying to do a very simple (or so i thought) crosstab report - i've had a
look at the samples at http://www.invisibleinc.com and these are great but
way more complex than i need, i've also tried writing the sql for the report
myself but have got stuck at how to list items in the ...

I tried to follow the instructions below, but I must be doing something
wrong. I have a bill number, amount, and CPT Code. I grouped by Bill Number.
I only want to see the 2 CPT Codes with the highest amounts.
I made a subreport based on a top 2 values. When the subreport runs by

I need to provide for my client Conditional Formatting Fields in Report like
in Forms: say, value appear in read if it above a limit. I was trying write
the code in format event procedure for detail section. It does not work so
far. Please, help.

I have a report that opens up information sorted by month. The problem is I
would like it to sort by month...eg Jan, Feb, March, etc. not by alphabetical
order. I can't remember whether I sorted this during the wizard and don't
know how to get back.

I have a uncomplicated little database that lists certain jobs I have done
when I have done them. I would like to set up a user definable print form
allowing me to specify the start and end dates of the reports to be printed.
Or, even more simply to print a certain month at any ...

I have a report with a label.  Also have a form that builds the report.  This
form has an  optional text field.  If the user leaves the form's text field
blank, I want the report's label to show.  If user enters anything in the
text box, I need that to override the label and show ...

Im trying to create a report which will only show the monthy accounts.
i have table and a query biult .. now Im trying to run a report to show only
the month I need eg January 2005.
How do i do it .. 3 hours later i still cant work it out

I have a form used to enter new records in response to a not-in-list
event.  It contains 2 fields which do not allow duplicates.  Niether of
these two fields is the primary key.  The problem is that the user
doesn't see that they have entered a duplicate until after they have

I'm trying to use a report which prints out 4 5X3 cards per book entry.  
This would work fine for 8 1/2" by 14", but for the card paper I have, it
needs to be 8 1/2" by 11" or 8" by 12".  So, when I print out the cards, it
prints out 3 for the first page and 1 for the second and ...

I wish to print a text box as the page header on every
page after page 2   how do i do this please
i know that this works
[TextBox].Visible = Me.[Page]>2

I downloaded your concatenate code sample and worked fine.  
I have since accumulated more modules from the CalendarLV code (this
creates a calendar form with a shortcut to the form that has your code in
it) everything was working great until I imported the other CalendarLV

Hello, Mi name is Hector,
I have a problem with a report.
I have a field named contractor, this field have 3
characters long (text), whit contractor, I have the field

I posted this earlier  with a not-very-descriptive Subject, so I thought I'd
try again.
Pivot tables are nifty, but is there no way of adding headings or
annotations?  And shouldn't there be a way of emailing a pivot table?  It

Is there any chance to alternate colors in report with tabular data?
Ladi