Reports
in [Access]
|
Comparing two fields I am doing a simple IIF statement that comapres two fields(both lastnames). However, the first field(LastName) has only the first letter capitolized and the rest lower case. The second field(FamilySortField) is in all caps. I need to compare the letters and not be case sensitive. Is that possible? Here is the ex... 9 Aug 2006 17:29
Formatting forms I am trying to create a report that lists certain attributes for each company. Each company is a record and each attribute is a field. My final two fields can be rather long, and sometimes run from one page to the next. I was wondering if there was a way to have it so that if a field will run onto the next p... 7 Aug 2006 13:35
Details Section Formatting I have a report with a detail section as follows: Initials: ABC DEF GHI JKL How can I format the data on the report to go across the page horizontally instead of down the page in single column? Thanks! ... 7 Aug 2006 13:35
Graphing Text by Date I have a graph that shows sales. The date is on the x axis, dollars are on the y axis, and the sum of sales are datapoints. These are sales of new products, so sometimes events can happen during the launch of a new product that makes sales swing up or down. I'm trying to plot those events on a graph just below ... 2 Aug 2006 14:07
Access Report Calendar Hello. I have ben trying to create a report in MS Access that fills in a calendar of job/project schedules. I have been searching this topic in Google groups with no luck, i have been given 1 address over and over again that does not work, it has no sample calendars as everybody says (http://www.invisibleinc.com/d... 1 Aug 2006 20:34
Access 2007 How I can use to print the total amount in the last page in a report in Access 2007 as: If (Pages)>1 Then [Totals] print to the last page Else [Totals] print to the first page End If ... 2 Aug 2006 14:07
Report only one page How do l create a report based on my query where the report is created for each record in the query.This is because when l view my report in print preview a second page that's completely blank with nothing on it. l did not create any background on my report . In which property field that l solve my problem repo... 3 Aug 2006 13:02
Report Orderby and Groupby in VB I have a report that needs to be grouped by the same field but sorted by different fields. The group by field must be the last sorted field. Report 1 Order by: Field1 Field2 Field3 Field4 Field5 (also the GroupBy field) Report 2 Order by: Field9 Field10 Field5 (same field as 5 above and also groupe... 17 Jul 2006 23:20
Access 2007 Bug Hello there, In the purchase order menu in the Northwind 2007 database file, when you click purchase order, if you click cancel the purchase order, there is a bug. ... 14 Jul 2006 21:57
access 2003 windows xo report I deleted field nodds from my report. i also deleted it from my query. Now when i go into my report i get the the message ENTER PARAMETER VALUE NODDS. I cant find it nodds anywhere in my report. I did note when i deleted nodds from my report it wasnt titled nodds it was titled text687. I think this means i used... 14 Jul 2006 18:23 |