Ok, have a report with page header header #1 header #2 header #3 detail #1 detail #2 detail #3 What I want is the details to go across the page instead of...

Currently I have a basic Report that runs from a query. Statements are created for employees in a single multi-page report. I need to run something similar,...

In my query I have two fields totaled in a field: Expr1:format(DateDiff("n",,)/60,"fixed"). I want to be able to Group on the report by Job# and Sum the Expr1...

I've looked at the below statement too many times and I can't figure out why it won't work. I've tried using AND as well. I have 10 regions broken out by...

I have an access database with three tables: pre *Protocol ---- Protocol ----- Protocol Approval Date Drug Action Author ...

I am very new to Access as the following question will prove. I have declared some public variables and wish to display them on a Report Form. What syntax do...

When I am trying to create a reoirt I am getting the following error " You have chosen feilds from record sources which the wizard can't connect. You may have...

On my main contract header form, I have a total field being calculated in the "Total" field control source...

I am trying to create a XY Scatter Chart but I know I'm doing something wrong. What I want is a chart that will plot the intersection of two numbers and show...

I have a table that looks up CompanyName, in alphabetical order, using a query. Query consists of CompanyID (Number) & CompanyName (Text), in that order, sort...

Newly created records are sorted separately from existing records that were imported into my original database. They sort fine on any report except the labels.

Don't understand why, but I have an attendance database with forms and reports in my laptop. When I copy this database in another PC I had issues with the...

I get "ODBC failu invalid date format" Other date fields display fine. Help! Please!

I am trying to format a text box with two different fields from a query. I want to show the "Subject" and then the "Description". My problem is that I want...

I have a report that has several subreports. On the main report I have the detail format property "Force New Page" set to "After Section". When the report...

I am getting StrConv prompt when I run a report on this pc, but not on others and I get #Error on the name list instead of the name.

I am working on a report that is organized by a clients unique ID number. It prints out the ID number as a heading, then each of the client's...

I have a Report that I would like to Group on a Date . So it will be only two Groups. 1. That has dates in it. 2. That will have the one that do not have the...

I have a listbox with a choice of 5 items. How can I get Access to count the number of entries for each item?

Hi, Been trying to get this to work, but what do you mean by "Me." ? Many thanks Lee If Len(Me.YourDataControlName & "") = 0 Then