I want to be able to count data in a field in my database. The field is called ATTENDANCE. Under attendance are options like ATTENDED and REFUSED and SICK...

Background first: I have a database for tracking contracts. Some contracts are straightforward and only cover one service but the bulk cover multiple...

I have a report (rptHV) that uses a query (qryHV) as its record source. The user opens a form (frmHVClient), chooses a name from a combo box, and then...

I have a report with a subreport that closes the database every time I try to Preview it or open it in Design View. The subreport will also do this if I try...

I create an unbound form to filter a report and i paste the following code in the filter button of the form, and it works perfectly; but my problem is that I...

I have a report that feeds of a query. The query has the following fields matsales: !unitprice*!quantity scharge: !surcharge*!quantity Taxes:...

Apologies if this is a silly question. I'm trying to combine Lastname, Firstname Middlename in a report. I have =(+", "++" "+). The only time it works is if...

If i have data in CSV file and it show like belwo Column1 Column2 ABCD Saturday ABCD Saturday EFGH ...

Hi All, I have a report whose record source is a query, the query consists of dynamic Select and Where clause and so the columns are user driven (based on...

I have a page header section, a group header section, a group footer section and a page footer section on my report. The group header I am trying to use...

ola jordy

I have created a lot of graphs to show various information. The problem I'm having is that I need the graphs to show the last 14 days of data. The criteria I...

Hi Team, I am desperately seeking help for a solution by which I would be able to merge the data for all records of any one field in a table to appear in the...

I am trying to calculate the difference between two times in an access report and don't know what the correct expression is. My report has a column of...

I provide help with Access applications. I specialize in designing the tables for a new database and fixing problems and adding new functionality in existing...

I have a report that uses one area to display either a percentage or a count I'd like to format the report field output so that if the value is less than 1...

Does anyone know an easy way to create gridlines in an Access 2003 report so that it resembles a spreadsheet, other than manually drawing vertical and...

Hi everyone It must be very simple for you guys but i can't find it: How to make a report, made of a query cross table, but only show records that the total...

Hello All I recently had some mdb corruption problems, that I THINK I've solved - by creating a new mdb and importing all objects. A new problem has now...

We have just upgraded to 2007 and are having a few minor problems. I've seen similar threads online but can't find the solution exactly for us. If I open a...