I'm trying to hide a lable if there is no data in the text box. i have tried this with the text box set to "can shrink". i know very little about code but...

Im working with a numeric field that infrequently uses decimals. I know that Access 2003 does not store trailing zeros in the number field but would like to...

Folks I'm trying to create a report group based on the page number. Is this possible ? If so what syntax should I use (I have tried , me. ) ? Thanks ..-alexT

Hi... I'm printing some numbers into tex boxes right aligned. The text boxes are wider than needed, so no reason to cut the numbers showed inside. However the...

I am trying to create a formula in a textbox that will only add a biweekly earnings to sick hours when the total sickhours are below a cap of 1600 hrs. The...

I have simple questions. I don't write code. I am not a programmer. So, when I want to know how to do something, where do I go for real simple straight...

I think I posted this question in a discussion groups area that is old. So I will try again. We are running access 2007 on a vista platform. 2 weeks ago we...

Hi Guys and Gals, I have a number of reports that are based on a temporary table that is generated from code based queries. As I don't want the table to...

I have a report that I use for airline flights. I am looking for a way to sort multiple time fields for connecting flights, by final arrival time. As an...

In my report, I have the field names: RSM, Sales Opportunity, and Sales Converted. I need to be able to find the sum of the Sales Opportunity or each RSM (I...

Please forgive me if I am double posting, I do not mean to. I need help and did not get a response to "Puzzling Problems" and it does not come up when I...

I am using a report which is based on a query and has a subreprot in it. The problem I am having is a report whcih should come in two pages coming in 4 pages...

I have rpt1 based on qry1. rpt1 has sub-rpt1. sub-rpt1 is based on qry2. qry1 and qry2 both have a filter. The two filters are different. My question - how...

I've got a text box in a report that's not returning properly. Here's its Control Source: =!!! +IIf(IsNull(!! !),Null,"") This returns #Error. It's definitely...

I have a form that sets up filters for a report. One is a dropdown box of the different offices that information is being tracked on. What is the best way...

Hi, when I click view, from the toolbar, I see my report, but I notice that in between pages that have data, there is always a blank page; i.e. page one...

Hello I am running a MS Access database from a server connected to several PCs over a LAN. I generated a report which does very simple maths, sums and...

I am trying to create a chart in Access 2003 that will allow the user to enter the parameters from a form for what details they want to see. The query is as...

I have a report which is based on a query. The query has 2 tables tblFees and tblLevy. One of the controls has an IIf statement as its control source. This...

Hi there, I have a question for my report. We used to only put target time and actual time on the report. But recently my boss wanted to list more information...