#Name? - Access 2007-Windows 7
Sat, 20 Mar 2010 17:18:54 -0400
Anyone have an idea?
Access 2007, Windows 7 - a report shows #Name?
Access 2007, Windows XP - report shows the values
The code is identical on both computers.
#Name? is showing for a for a text box - Here's what's in the text box
=[breedname] & ". " & Right([Title],Len([title])-15) & " " &
Right([sexorder ...
|
Print Access report along with an outside checklist
Sat, 20 Mar 2010 11:28:01 -0700
Good afternoon
Is it possible to print a report that's in Access and then right after print
an Excel checklist?
Background:
I work for a large construction company that does regular maintenance on
their equipment. Right now we print a parts ticket of the parts required for
the particular service they ...
|
Can I add a map to an Access report?
Sat, 20 Mar 2010 10:12:01 -0700
I'd like to create a prospect sheet for salesmen with a business address,
other info and a printed map from Yahoo, Google, or Bing so they can easily
find their next location. Can I do this through an Access report using a
control object or ActiveX object? If so, what is the object and how is it
used? ...
|
Summing a column in a report
Sat, 20 Mar 2010 06:37:01 -0700
My report has a column of numbers. Below the column, I would like to show a
text box with the sum of these numbers. In Excel I would just use something
like "= Sum(C3:C56)", but I don't know how to do this in Access. My real
problem is that each report has a different number of rows. Any clues??
Thanks
...
|
Drawing a grid on a Report
Sat, 20 Mar 2010 06:05:01 -0700
greetings
I have a report based on a Crosstab query. Both the Query and the Report
work just fine. They have 2 row headers on the left side of the table and a
variable number of PivotField headers.
I've been asked to have the Report's table in a grid when printed. Normally
I would just use line segmen ...
|
A Year to Date Report Question
Fri, 19 Mar 2010 23:37:17 GMT
I need to create a YTD Report in the following format:
CurrMonth PrevMonth CurrYear
PrevYear
Customer1 2 1 7
5
Customer2 6 19 15
12 etc...
...
|
Another **** Year to Date Report Question
Fri, 19 Mar 2010 23:36:06 GMT
I need to create a YTD Report in the following format:
CurrMonth PrevMonth CurrYear
PrevYear
Customer1 2 1 7
5
Customer2 6 19 15
12 etc...
...
|
|
|
Print every other record in a form
Fri, 19 Mar 2010 10:39:02 -0700
Hi,
I have a continious form that gets selected records from a table. From the
records shown in the form I want to print pages for a book (left-facing,
right-facing). Is there a way to print two reports using the records shown
on my form? One report would select records 1, 3, 5 etc and the second
report ...
|
Keep Data together in a Report
Fri, 19 Mar 2010 10:06:12 -0700
I have a report which has fields in the header and a field in the detail.
How do I keep the fields in the header with the detail together for each
page.
Right now part of the detail goes to the next page if there isn't enough
room on the current page.
Thanks.
--
Denise B. ...
|
Count Reports Sent Before A Specific Time
Fri, 19 Mar 2010 08:48:01 -0700
I am trying to count the number of reports were sent before 4 pm each day. If
the time difference between 4 PM and when the report is sent is greater than
1, then I want that to count as 1. If the time difference is a negative
number, then I do not want that report to be counted.
My formula so far is:
=Coun ...
|
