Over 1 million tech questions and answers.

Solved: Add formatting to groups in Access report?

Q: Solved: Add formatting to groups in Access report?

I have an access report that I am having trouble formatting. I have a field of 13 characters and I want them grouped by the first 9 characters so that there is a line once the first 9 characters changes.

For example: If the data shows AAA AA AA.AA, then the next line is AAA AA AA.AB, I want there to be a bold line inbetween those rows on the report so it is easier to see when the sections change.

Is there any way to do that?

Thank you!

Preferred Solution: Solved: Add formatting to groups in Access report?

I recommend downloading and running Reimage. It's a computer repair tool that has been proven to identify and fix many Windows problems with a high level of success.

I've used it in the past to identify and fix everything from blue screens (BSOD's), ActiveX errors, corrupt files and processes, dll/exe/sys errors, recover lost memory, Windows update problems, defragging, malware removal etc.

You can download it direct from this link http://downloadreimage.com/download.php. (This link will automatically start a download of Reimage that you can save to your computer.)

A: Solved: Add formatting to groups in Access report?

Read other 12 answers

Can anyone tell me how I reduce the line spacing in a group in reports. Any help would be greatly appreciated.

A:Access 2007 report formatting in groups

Report Line Spacing is literally controlled by the layout on the Report, so reduce any space between lines and from the "Group Header & Footer".

Read other 1 answers

Ok all, bear with me. I have created a simple database that holds agent statistics for a daily scorecard. There are 6 different types of employees and each type has a certain criteria to meet.

I.E. - An entry level employee must meet a quota of 8 calls per hour (CPH), If he/she meets it then they "Meet Expectations" if it is below then they "Need Improvement"

I have a report tht lists all employees, their employee type (entry, intermediate, advanced, etc) and their "CPH".

I would like their CPH to be color coded based on meeting criteria or not. It would be easy if they all had to meet the same criteria (I would use conditional formatting)but since there are 6 different types, is there a way to write code for this.

Example in plain words:
IF "employee type=entry level"
Then follow these guidelines to color code values.

I know this may be choppy so let me know what detailed information you would need from me. If you want to really help I wouldn't mind sharing my db by email and having you take a look, it is just a very basic database.

This is the code I have so far, i am very new to VB and am not sure if this is correct. It compiles just fine, and I can open the report after saving this code, but it still does not work. Got any ideas???

Here is what i have so far...let me know what questions youhave or if there is anything you need to help me out. Thanks
[SIZE="3"]Private Sub Detail_Format(Cancel As Integer,... Read more

A:Solved: Formatting Access Report with VB

Closing duplicate, please reply here:



Read other 1 answers

I am trying to produce a report in an outline format as follows:

Employee Name
Employee Name
Employee Name


Heading 1

Heading 2

There may be more than 1 employee doing a particular service for a client. They each input their service seperately as a new record. I need to be able to pull out the information for headings and subheadings to display as above. I also need to be able to pull out the information associated with the client. My fields are Department, Employee First Name, Last Name, Client, Heading, Subheading. How do I display this in a report. Have tried many options. Please Help!!

A:Solved: Access 2007 Report Formatting

Read other 15 answers

I have a database for a senior center membership. Members are from a number of area towns. I am trying to write a report showing the demographics by town. ie gender, age etc. I have grouped a count of members by town, and now I want break that down by age groups. It would look something like this:
ANYTOWN 50-60 60-70 70+
members = 20 10 5 5

members = 10 3 3 4


I found a function on line that will compute ages from DOB and assign them to age groups. I use this function in a query that gives me the demographic info I'm looking for, including a column named "AgeGrps" My problem is "How do I get a count of each age group by town in the format shown above?" Any help will be greatly appreciated

A:Counting Age Groups in an Access Report

Ron, it may take 2 queries to do this, one to put them in to the age groups and then a second one to Group and count them by Town. Or you could possibly use a Crosstab to do the Grouping and Counting.

Can you post a zipped Access 2000-2003 copy of the Database for us to look at?

Read other 1 answers

Hey everybody

A report that I have in access messes up when I export it as an Excel spreadsheet. I export it, and then go to open the excel file. When I open the file up, I get the error message "File error. Some formats may have been lost."

When this happens, I look at the excel file, and the some of the dates I have are numbers like "38848". The dates should be dates like 5/25/2006.

The odd thing is, all the dates aren't messed up. Any ideas on what is going on?

A:Solved: Access 2003 - Exporting Report to Flash causes Formatting loss

Hey smooth, for an explanation of the dates turning into numbers, check my signature (Access Dates and Access Date Conversions both have info). I don't know why it would happen with only some, but there must be a common trait among the dates that get swapped.


Read other 3 answers

I am having trouble with a report in Access. I have attached a sample page of the report. In the page footer section, I have a row for "Grand Total", "Delivery and Prep", and "Users". I have 2 problems:

1. The items in the page footer are showing up on every page (which would stand to reason), but I only want them to appear on the last page. What section should these calculated controls be in? And how do I get that section to appear in design view?

2.Why am I getting the #Error in the Grand Total field? The calculation being done is =Sum([Boise]) and of course the city name in brackets changes to the city in the column above. The data in the report is coming from a cross-tab query with fields by the same names and the totals in the report lines are correct in comparison with the query.

A:Report Formatting in Access

Read other 8 answers

In access 2000 the formatting choices for information in a text box are R, L,C
how do you justify both margins. You can do this in Word, is it possible in Access?

A:Access 2000 report formatting

Read other 11 answers

I have a report, where I have these tbl fields

FirstName LastName Title

I would like it to display:
John Doe, President (if title is present)
or John Doe (if title is not present)

I can concatenate the fields just fine, what i can't figure out, is how to have a comma based on "If".....

any help appreciated.

A:Access 2000 Report Formatting

Read other 9 answers

Dears,I have designed a database with many reports of certain importance. basically a report in my DB is one of two types; a Daily Report (requires a single criteria which is the date) and the second is a History report. To view or print a report, I have designed a Filter form to fill in with the report criteria and clicking a button to open the report.The first type (Daily R) work fine without problems. The second type (History R)has a problem. In this report, the criteria are two or three because a history report will retrieve data within a period, so I have to input (FromDate) and (ToDate)and may be adding another criteria which is called a company.In all history reports, the report header will accomodate the two input values of date and extract the rest of report items into the reprot detail area.The problem is, the desigened system doesnot respond well as expected. When I load the filter form to fill in criteria for a history report, I have input the FromDate and ToDate and selected the third criteria (if any), then, the reprot opens without data in it.on the other hand, I tried to load the report directly form opening it, inputing criteria, and it has worked fine without probelms.Would someone expect a key reason for this problem or dirtecly can solve this problem?Appreciate youtr support.Thanks in Advance.mhegazy

A:Solved: MS Access report load from a form having report criteria

Read other 16 answers


I have a report, with 3 sub-reports in. It collects all the data for a particular SiteID. in Each of the sub-reports, there is a cost value. One for Hardware, one for Mobiles, and one for Phone lines. I have fields at the top of report which reflects the values and totals them up. Works great, except:
When i have a SiteID with one of the subforms being empty; i.e no mobiles on the site it displays fine in the report view, but when i go to print or publish as a pdf it strips out the subform with no value, and throws an error in my calculation. I need the calculation there, which means i need it to stop striping out the subform with no value. I however cannot see how to do this...its just bugging me, its fine inthe report view, just when you send it to print.

Would grateful for some help,

Thanks Mike

A:Solved: Access Report removing sub-report when printing etc.

Read other 16 answers

Hi everybody,
ATA V. 1.9.7312.32791 - fresh install, no update
Just recently installed Microsoft's ATA. I only use lightweight deployment option for ata gateways on every domain controller available, no other ata gateways in use. So for my understanding I don't need any configuration of event forwarding since the lightweight
gateways are able to read any event locally.

I am not able to get a report about modifications of sensitive groups, it's greyed out. An informational message below it says: "No modifications of sensitive groups were observed, make sure that events forwarding is properly configured."
I changed many things about my sensitive groups for testing purpose btw.
Any hints?

Thanks, regards, tim

Read other answers

Can anyone help please? I keep thinking that this should be simple and am I just missing something From the example attached, each group of records with the same shelfmark needs to have at least one record with an Ord Status of SV.
How do I find a group or groups with the same shelfmark (5678.000000 in this case) that doesnít have at least one SV Ord Status against any of its records?

A:Solved: Filtering out specific groups of records on Access 2003

Read other 9 answers

I need to read and update a table that has thousands of records in it with multiple record types that need to be grouped. It's an EDI style format. The problem is I can't find a unique value to tie all of the record types together - so I'm thinking I'll just create a unique value for each group of records. Below is an example of the records. I'd like to create a unique ID for each group of Rec_Type 10-95. I was thinking I'd need to create some VBA code that reads the table and just updates a new field that stores a group ID. Here's the english version
Pseaudo Code:
Set counter to 1
Read Table
if rec_type >=10 and rec_type <95 then
Group = Counter
Otherwise If rec_type = 95 Then
Group = Counter
Counter = Counter +1
Else Group = 0

Update Group field on record

Loop - read next record
While I understand how to create modules and how to create update queries, I'm a little fuzzy on how to create the VBA to read through a table and evaluate each record for updating an attribute in that record. Thanks in advance for your help.
ID Rec_Type AllText
1 1 03833
2 10 11201
3 20 77003
4 30 01770
5 31 01770
6 40 01770
7 41 01770
8 50 01770
9 60 01770
10 60 02770
11 70 01770
12 80 01770
13 90 77003
14 95 00000
15 10 13101
16 20 K1367
17 30 01K13
18 31 01K13
19 40 01K13
20 61 01K13
21 61 02K13
22 70 01K13
23 80 01K13
24 90 K1367
25 95 01615
26 99 03833
27 1 03833
28 10 11101 ... Read more

A:Solved: Access 2003 VBA - Read and update a table to create record groups

Read other 12 answers

I have a very simple data base 3 tables

Product table with 2 fields productid and productdescription

Sale1 is the basic information of a sale invoice number and who items are sold to

Sale2 is the details and shows qty , item, price, and GST charged if any (some people or organizations are tax exempt so it becomes zero.

I've got my form and subform to run correctly

I've got my report to print all items correctly but I can't total the value

the line value for each item is a textbox

=Sum([QTY] * [Saleprice])*([GST])+([QTY] * [Saleprice])

This does return the correct value for that line item.

HOW can I correctly total the sum of all items into the reporrt footer???

HELP please the sale is tomorrow through Sunday.

A:Solved: Total in Report Footer ACCESS 2010 Report - Total NOT working

Add a duplicate of your current calculating field and set it's "Running Sum" (under data tab) to yes overall.
Then in the footer use the new field as the totals Control Source.

Read other 2 answers


Read other answers

I have an Access report that I would like to seperate by the month. On the report, I have a date type field that I would liek to use to seperate by months. I then would like to take an average based on a certain filed for each month.

How would I go about doing this?

A:Solved: Access Report

Read other 14 answers

I am trying to print a report based on a selection made on a list box, but I cannot seem to get it to work. The code below is what I have behind a command button.

DoCmd.OpenReport Me.lstReports, acViewPreview

Is there something I missing with the code above?

A:Solved: Access Report

Create a Command button to open one of the reports and then chnage the code that says
"stDocName = "USDA New Families Report""
stDocName = me.lstReports
Assuming that me.lstReports is the name and not the List Index value.

Read other 2 answers


i have just created a report in access 2003. In design view of the report everything is perfect and shows correctly, but when in preview mode nothing shows in the "Details Section" this is really weird and i cannot figure it out.

Can somebody help me please? Thank you for your time.

A:Solved: Access Report HELP

Read other 9 answers

I have an access report that is designed to print on label paper. I added 4 sets of the fields I want but isntead of the 4 sets showing unique records they all show the same records. Is there a way that I can have the report only display unique records in the box.

| | |
| | |
|_same _|same__|

and I want

| | |
| | |
|_DIFF _|Diff__ _|

A:Solved: Access Report

I have not done labels on label paper, but I do not think that you should add the Fields. I think that there should be just one field.
I do know that you can achieve what you want by using one field and with the Report in Preview click Setup>Columns. You can then set the Columns to 2 and set their width to suit your labels, the "Depth" of the Record Detail on the report will position the fields down the page.

Read other 3 answers

How can I format an Access report to look like a spreadsheet?

It is cuurently formatting like this:



I would like this layout.

Location Location Location
Task Task Task
Hours Hours Hours

I know there has to be a way to do it without exporting to Excel.

A:Solved: Formatting Access to spreadsheet look

Read other 9 answers

Can someone tell me if the following is possible. I have a very basic database, and one field on a form has the input options of "Completed" or "Outstanding".

What I want to do is change the bacground colour of a different field to green when the other field is showing as Completed.

I understand how I can change a given field depending on conditions in it's own field, but I can't see how to change conditions of field A depending on the condition of Field B.

Help much appreciated as always.

A:Solved: Access - Conditional Formatting

Read other 9 answers


I'm new to Access so I apologise if this is a silly question. I'm making an orders database and using autonumbers to generate the order numbers. The order numbers start with IT and then have 6 digits, so I have used


in the order numbers format entry in the table. This works fine with one exception. If a user selects the order number in a form by using the mouse then the order number loses the IT. This doesn't happen if the user selects the order number when tabbing into the field. Is there anyway to keep the full formatting when a user selects the entry with the mouse?

A:Solved: Access formatting question.

Read other 16 answers

I have a form in Access that uses information from 2 tables. I need some text boxes to become transparent (appearing 'greyed out') when the value of the Type text box is 'Counsel'. I am assuming this can be done done using an 'if statement' but cant seem to get the code...can anyone help?


A:Solved: Access Conditional Formatting

Read other 7 answers

I am having a problem with an Access/Outlook data transmission. I need to send an access report, as well as an external file, to various users using Outlook. I can send the report using the docmd.sendobject method, but I need to send the external file (an excel spreadsheet) in the same e-mail. I have found I can send the excel file via adding it the the attachment collection, but haven't been able to add a report to the collection. This (the second) is what I would prefer to do if it is possible. Any help is greatly appreciated.

A:Solved: Access Report via E-Mail


Read other 1 answers

In a report that I just finished there is a small change I need to make and I can't find a way to do it. I have a field (Period) and I used it as one of the grouping levels during setup with the wizard. The values of this field are 30 days, 60 days, 90 days. The problem is that on the report the order is backwards listing 90 days, 60 days, and 30 days. The problem is twofold, I can't figure out how to get back to the wizard without starting a new report and even if I do, I didn't see a way to change the sort order on the grouping levels - as the fields that are grouped by are removed from the sort order dropdown box. How can I change the order?

A:Solved: Access Report Question

Look in grouping and sorting options and change the order to descending.


Read other 2 answers

I have a report that is displaying a number field. I want to sort on the report by the numbers, but the sorting is not working properly.

For example, I have numbers: 1,2,3,4,5,6,112,200. Here is how the report is sorting the numbers:


Why will it not sort in a series?

A:Solved: Access 2003 Report

Read other 16 answers

I have created a report in Access 2007. The table that the report is based off of does not have any duplicates. However, my report is showing multiple duplicates. My report is grouped by Provider Name with a title header. Then in the detail section of the report I have the following fields: Measure, Member name, Member ID, Address, City, State, Zip. Since the report is grouped by provider, the member could have different measures listed by their name. In which case, I would expect to see them on the report more than once. However, the report is currently showing multiple members for the same measure; therefore, resulting in duplicate information. How can I get rid of the duplicates in the report?


Read other answers

Hi, i have a report that shows unpaid invoices. I have a problem getting the total of all upaid invoices. I use this expression in the reports footer =sum([total])

The problem i have that it is only showing me the total of the last invoice not the total of all invoices.
any help will be appreciated.

A:Solved: Access Report Expression

Read other 10 answers


I have a report in Access 2003 that I am basing off of a query. I would like to use grouping in the report. For some reason, when I open the grouping box, not all the fields show up from the query. Does anyone know why this is?


A:Solved: Access 2003 and Report

It may be that some fields do not contain the correct data structure to be able to be used for grouping.

Read other 3 answers

Getting my butt kicked here, I'd appreciate any help.

I need to add a field in a report to show a voucher number. It needs to start at a certain number and +1 everytime the report is ran. Not talking records here as every google search I've found deals with records.

Example: I run the report today and the field says it is 33. I run it tomorrow and the field says it is 34.

Any ideas would be helpful.


A:Solved: Access 07 Report Numbering

You need to store the last number used someplace.

Are you current storing the last number used?

Read other 3 answers

I'm trying to generate a formula that will tell me the Median outcome from a query. Is there a standard formula for Median in Access?

If the results of my query (for example) are 1 through 100 rows, I want the formula to count the number of rows, divide by 2 and tell me the value of a particular field in the middle row.

Hypothetical example:

Count of [ID#]=100/2 tell me the value of [Amount] in row 50

Not sure if this makes any sense to anyone but I'd appreciate any help.


A:Solved: Access Formula in report

Paintergrrl, you are the first person to post on here who actually wants a Median value for real, why I don't know, because to me it is a pretty meaningless value.
Access doesn't have such a Function, although it has quite a few simple Statistical functions.
So it will have to be done as you have outlined, you can obtain the record count either in a Query or using a VBA Recordset, but to get the Median Record you have use to use a VBA recordset.

Read other 1 answers

Using Office XP


I have a report that runs on a query. This asks for a date to be entered then the report lists all records that match.
On the report the date entered is shown but as the date is entered in the "dd/mm/yy" format this is how it is shown.
Is there a way that the report shows the full Day and Date eg. Thursday, 01 October 2009.

A:Solved: Access Report - Dates

Read other 7 answers

I have a form open with all the details i need, and i can email a report, using the code below, i just cant get it to email the report that is open for an individual "DevelopmentID". I just dont know how to link the "DevelopmentID"

Private Sub CmdEmail4_Click()
On Error GoTo CmdEmail4_Click_Err
DoCmd.SendObject acReport, "RptClientAll", "PDFFormat(*.pdf)", "", "", "", "All Client Detail", "", True, ""

Exit Sub
MsgBox Error$
Resume CmdEmail4_Click_Exit
End Sub

Any body got any sugestions please? The normal Macro does not link, so im resorting to VBA. ive converted the macro to show the VBA as above. Ive tried different ways like below, but it does not link it still:

Private Sub CmdEmail4_Click()
On Error GoTo CmdEmail4_Click_Err

DoCmd.SendObject acReport, "RptClientAll", "PDFFormat(*.pdf)", "", "", "", "All Client Detail", "", True, "", "[DevelopmentID]=" & Me![DevelopmentID]

Exit Sub
MsgBox Error$
Resume CmdEmail4_Click_Exit

A:Solved: Emailing a report using VBA for Access

Read other 9 answers

Iíd like to know how, if possible to do in Access, a calculation:

I have a 30,000 lines of data. Each line contains, amongst other stuff - a Sitecode, ItemCode, date, value and flag.

Each SiteCode can be categorised by itís prefix letter A,B,C
ItemCodes are TSGxx where xx is 01 to 99

The Flag only appears when a certain value is exceed, but as far as where Iím taking this Ė we neednít give further thought to the value as the flag is coded in the data.

My question is, is it possible for Access to report/query on the percentage % of each code (A,B,C...), The ItemCodes that have been not been flagged

Have attached sample excel for which the data is to exported to Access.

A:Solved: Access, a calculation/report

Read other 7 answers

I am using the Student & classes template to record student grades.
I am trying to figure out how to print a report card per student. As yet all i can do is print a list of all teh students grades & classes all together. Is there a way to print a report that is baseed on a particular record i.e. the student ID.
Thanks in advance

A:(Solved) MS Access Report/per record?

Read other 12 answers

I have created a db that keeps track of employees time worked and leave taken.

I need help getting the time worked by employees to calculate/total on a report. I would like for the time to be totaled for the week, and then again for the month for each employee. The db is setup so that there can either be a manager or non-manager employee. If the employee is a manger, then they have two options when it comes to viewing reports. They can view his or her own report with just the time worked, or they can view all employee's time worked. The non-managers can only view his or her own time worked. The other kicker is that the employees are either salary or hourly. If the employee is salary, then they do not have to clockin and out for lunch. The hourly employees do have to clock in and out for lunch.

I have attached a copy of the db. Any suggestions or guidance will be greatly appreciated. If any further information is needed, please let me know.

A:Solved: Access Report Issue

Posted this thread twice by accident. Please see thread that has not been marked solved.

Read other 1 answers


I have a Vat Report and a Turnover Report. On each report i need to get the total but i keep getting #Error.

I created a text box in the reports footer and set the control source to =Sum([Vat]) an changed the running sum property to over all but i keep getting #Error

I have looked everywhere but cant seem to get it working, i hope one of you will help me out.

Thanks in advance.

A:Solved: Access 2003 Report Help

Read other 6 answers

My boss wants me to make my db so that it exports a report to excel which is not a problem but, he wants the excell to be formatted like the report which displays doubled up headings and doubled up data so that it all fits on letter sized report I think maybe I can make an excel template to output to?? But is there a way to reformat and excel doc to double up the headings and make it my template? Anyone ever done this?

Thanks, Joe

A:Solved: Excel report from access

Does not look like this is possible

Read other 2 answers

I just purchased Office 2007 so that I could e-mail reports as pdf files. This works fine and what I actually e-mail is a portion of the report as defined by a where clause or filter. When the report goes out in the e-mail it uses the report name as the file name i.e. "rpt R1 .pdf" The commands are in vba and are initiated by a button on a form.

Since I am only sending a portion of the data (e.g. item number 1234) and since I am sending the report because I have updated the data I would like my file name in the e-mail to be more descriptive. What would be good is a file name of "1234 revised 4-19-2007.pdf". Does anyone know how to do this?

The only way I have thought of is to use a DoCmd.CopyObject (or rename) to create a copy of my report object with the name "1234 revised 4-19-2007" and then run that and then delete it. I am pretty sure this could work but I feel there might be a better way.

A:Solved: Access Report VBA Question

The solution to this is to first save the report output to a (pdf) file using the a command similar to the following:
DoCmd.OutputTo acReport, stDocName, acFormatPDF, stFileName
and then send an e-mail with the file as an attachment. This cannot be done with DoCmd.OutPutTo but can with a custom subroutine (free) from Peter's Software. Here's a discussion of the issue http://www.peterssoftware.com/c_emfa.htm and a link to the sub. It worked for me: http://www.peterssoftware.com/c_som.txt

Read other 1 answers

I have an Access Table that contains two date type fields. Sometimes one date field will have data and the other will not have any data. Other times they will both have data.

I need a way to display both date fields on a report without having two different fields on the report. What I would like happen, if the second date field is blank/empty/null then display the first date field. If they both contain a date, then display the second date field.

I tried placing a textbox on the report with the following:

iif(Datefield2 = "", Datefield1, Datefield2)

That did not work. Can someone please guide me in the right direction.

A:Solved: Access Table and Report

Read other 14 answers

I have created a report in Access 2003. I would like for the report to display the data in columns. I have went to File -> Page Setup -> Columns Tab. I changed the number fo columns to 2, but when I view the report there is still only one column an dthe remaining data is not visible.

Does anyone know how to fix this issue?

A:Solved: Access 2003 Report

Did you set the column widths?

Read other 3 answers

I'm using ACCESS 2003 and I created a query named 'Key Measures - BESOS' with the criteria set for [Date] as a parameter ('Between [start] And [end]') and it works fine; however, when i run the report based on that query i get an error (#Error)message in all my fields. The report looks at the sum of cases that meet my criteria in several fields. for example, i need to know the sum of cases that are outreach (1) and have the following formula: '=(DSum("[outreach"],"Key Meaures - BESOS","1")*-1).

All the formulas used to work perfectly before I set the criteria in the [Date] field in the query. Why is it that my query is running fine, but the report isn't? I've checked the Record Source and it is OK. I don't know if this is relevant, but the fileds are in the Report Header section to avoid getting 50 pages with the same info. Again, everything used to work fine until the date criteria thing and i didn't change anything else.

please help me, i'm about to quit my job

A:Solved: ACCESS report error

Read other 7 answers

Good morning. I found this forum this morning and I hope someone can help me out. My company is looking for a report that will list purchase orders and invoices paid against them. The PO amounts and invoice amounts are housed in the same table but in separate columns. There are multiple invoices paid against every PO. In order see which invoices were paid on each PO, there is a column for PO number. The PO number gets entered in on every line. I have tried to set up a query that will deduct the invoice amount from the PO. The problem I am running into is when the query runs the PO amount pulls in for every time an invoice is paid against it. For example PO123 is $30,000 and the following invoices are paid against it: INV 3 - $5,000, INV4 - $5,000 and INV5 - $5,000. The query will return $90,000 for the PO amount and a cumulative total for the invoices of $15,000. What do I need to do? Any help would be greatly appreciated. Thank you.

A:Solved: Access 2007 AP Report

Read other 16 answers

I have set a simple conditional format in a report: if $ amount not equal to; font red.
It is working on most records but not all (records 23, 30, 39, 71, 73, 90, 96, 112, 113, 117). I have checked both tables, a data is entered correctly as currency, decimal is auto.

A:Conditional Formatting in Report

Read other 6 answers

Hi guys,

I don't know VBA or SQL, I just click icons and hope for the best.
I have a form in MS Access 2007 being used as a time clock. The 3 parameters I'm working with are:

e_14-15 (a checkbox)
e_16-17 (a checkbox) and
=DLookUp("[TotalTime]","Total Time","[e_ID#] = Form![tc_ID]")

The conditions I have are (and have no idea how to syntax or even where to put):
If e_14-15 is checked AND the value of =DLookUp is between 30-39 OR if e_16-17 is checked AND the value of =DLookUp is between 40-49, then format =DLookUp with a yellow background and red text
And also
If e_14-15 is checked and the value of =DLookUp is >=40 OR if e_16-17 is checked and the value of =DLookUp is >=50, then format =DLookUp with a red background and black text.

We basically need a huge visual clue that the workers we have are about to hit or are over their allotted hours, based upon whether their respective checkboxes are true.

I have no idea where to even start with this. Any help would be greatly appreciated.


A:Solved: conditional formatting in an MS Access form

Read other 12 answers