I'm using Access to build a database at work. I am entering data on a daily basis from invoices that I wish to sumarize by various periods of time (daily,...

Hi all, This is one of those things that I should know, but just can't remember right now. I'm creating a database for an extra-curricular program that will...

Marsh, In case you missed my reply, I posted the sort table on 9/15/2007 to your attention. Thx for your help. Tom -- Tom

Hello, I need a report filtered by the distances of cities based on a starting city (radius search). For example, if the starting point is Buffalo NY, I...

The company has an odd way of summarizing data - their fiscal months start before or after the actual first day of the month (but always on a Mon). The...

After creating a snapshot file which contains text and graphs, is there an editor to modify the snapshot file? I would like to blur/remove sensitive...

We produce reports that are invoices.. The reports are really a group of compined reports if this matters... When we print the reports I would like to have...

I have adapted Duane Hookum's great monthly calendar report available at http://www.access.hookom.net/Samples.htm. The only changes are to the date formats...

Hi, I have form based charts and tables and reports as sub-objects in one report, "Appendix". This takes one report header and nine section headers, no...

Hi I have a text field in a report with =Date() as the control source and format as medium date, the problem I have is when I send the report to Excel it...

I am creating a report to record and provide information on how long a water pump station has been operating over the last 45 days. I have created the form...

I have a Form with multiple fields, if a certain field is empty then I don't want all fields printed. For Ex.: EmpName Address1 Phone Email if Employees...

Whenever I try to embed a subreport within a subreport, Access crashes displaying the --A problem has occurred and Access must close-- dialog box. What am I...

Hello, I have a client who is still using an Access 97 DB application and it has been giving me the fits recently. They are thinking about upgrading to 2003,...

I have a report with 340 names...there are five fields grouped under a location code. The report looks great EXCEPT twice within the report the first name...

The report I run comes from information that needs to be updated manually each week. Unfortunately, we don't always take the time to stay on top of this and...

Hi again everybody, I am updating a report by adding a field to it that is tied to a text field on a table. I have two problems that are occuring. 1. When...

Duplicate records are shown in the queries window e.g. if there are 10 records in the main table. 1000 records are shown in the queries windows. Plz. help to...

Hi there, I've got a report that has on 1 user's machine diplays #name? for some (not all) of the text fields. Running the exact same report on other...

Hi, I have read the question: 'Hide a section based on contents at run time' and followed the recommendations but the groupheaders were hiden on the data of...