Search results for query: *

I have a table that contains account numbers (ACCT), dates (TSD) that the person holding the account visited and then the amount of money spent (ATT). I want to bring back the most recent 5 visits for each patron but when I do count of account or trip date, it just assigns each 1. I need it to...

I am using Outlook 97 with Windows 98 and have set up the Internet Mail service for a pop email address. The problem is, I need to be able to check several pop addresses within Outlook and it seems to only let me set up one instance of the Internet Mail service. I know in Outlook 2000 that I...

I am trying to write a formula for Excel 97 that will combine multiple IF statements in one line.. what I have so far is: =IF(B1=1,E1) I need it to continue to say something like: ELSEIF(B1=2,E2), ELSEIF(B1=3,E3), ELSEIF(B1=4,E4), ELSEIF(B1=5,E5) etc etc... but elseif isnt working. Ive done...

I am using Word 97 and have a table. Word seems to arbitrarily page break even though there is still much more room to add rows - in some cases more than half the page. I try messing with the margins and they are all set low (like .8 top and bottom). Ive tried shrinking to one page but the...

I wanted to take a minute to publicly thank CosmoKramer for going above and beyond the call of duty to help me get the reporting working in my db. I started the project in Feb and in early March started running into problems getting the reports to work as expected. Cosmo and other members of...

I have a report created that runs a combination of 4 subreports for a specific date range. When I first created it, it ran quickly and without problem. Now I have more data entered, although because of the date ranges the reports arent THAT much bigger. However, now when I run the report, it...

I am having trouble creating a union query statement. I have this: UNION SELECT [Tracking Number] FROM [Sales]; UNION SELECT [Tracking Number] FROM [Purchasing]; UNION SELECT [Tracking Number] FROM [Operations]; UNION SELECT [Tracking Number] FROM [Jobber]; But I get this error: Invalid SQL...

Is it possible to create a .pdf file from an Access report? After I spent weeks creating the perfect printing reports, my boss asked me to e-mail them to the sales managers. When I export into Word, it doesn't keep the same formatting and Im spending quite a bit of time fixing the formatting...

Im having an issue with an IIf statement: =IIf(IsNull([Parent Group]),"No Parent Group",[Parent Group]) It should print "No Parent Group" if the field is blank, otherwise print the name of the Parent Group. I use this same type of statement throughout my reports with no...

I have a master report that has 4 subreports. I am having a problem getting the subreport page header to show when I run the master report. I have the header set to visible and Page Header set to yes in all places I can think of (both on the main report and subreport properties).

I have a report that is based on a query with a Between statement in the date criteria. When I run the report, I get a popup where I enter the date range I want. I want to be able to print that date range on the report.

I am using Access 2000 in WinXP. I have a database created that tracks sales calls. Agents submit "sheets" that can have 4 different types of calls: purchasing; sales; operations; and jobber. The first 3 types can only have 1 call per sheet, but jobber can have up to 5 calls per...