I have a chemical database that I'm working on, and in a report on each chemical, I would like it to display the contents of two fields, like this: Label: &...

Access 2000, XP, 2003 Win XP Pro I have a variety of data in a single Text field of a table, some numbers, some dates. I get undesired concatenation when...

I have a Access 2002 database with reports. I am forming a query dynamically in my VB front end with 'where' condition, and opening an access report using...

I am a doctor and I am designing a software for my hospital billing. Now there are various fields like 1. bed charges 2. nursing 3. Initial consultataion 4....

I am currently attempting to create an expression that will sum a particular field for several records in a table based upon a unique id number. For example,...

I have multiple subreports in the detail section of a report which prints out daily items entered into a case management program which I designed. Most of the...

You guys have saved me before so I hope you can do it again! I am using Access 2000. I am trying to create a report that will display two lists of Unit...

Using MS 2003 access i have a DB and a few reports based on querys from the db. Even though we can export the report to Excel to do some simple adding, I'd...

I have a child subfomm that "repeats" based on the number of records it finds in the query which is the recordsoure (sorry if I don't have the terminology...

When I try to click any button to open any form or try to open the module, it always give me the following error and then close the mdb: "Microsoft Access...

I am using Access 2000. I haven't been able to find a way to round down the results of a calculated field in my report. I have set the field properties to...

-- I am building a training database. There are systems within database. Thers are at list 5 sop,s that a person must train on to be qualified to operate...

how can i sort out my record in report. in the query i used for the record source it is sorted descending but when it comes to the report., it does not work....

I need to distinguish in code whether MS access (97 or XP) is printing or previewing. e.g. in the On Activate event what property do I use to indicate if the...

I have a report that is based on a query with parameters. Parameters are of the date type. However, I can type any date regardless of the order. I have a...

Does any version of Access allow for the calculation and placement of barcodes in a report?

I have a report from a query with a range setup so the user can enter to print a range of purchase orders. Each p.o. may have more than one page and the the...

I'm trying to follow the examples in VBAGRP9.CHM and/or VBAGR10.CHM with no success. I'm trying to Chage the Legend Colors based on Content so that I can...

Thanks to Duane for his elegant Concatenate function. One of the Concatenates I'm using involves differing datatypes. The source table is 3 fields: ID, Date...

I have a database in which I track sales results by individuals and type of sales. For performance reviews I have a pie chart that shows the results for a...