1
  • Creating a report in Access 2007

    I have a table in an Access 2007 database that contains the following fields: Emp. Name, Date Worked, a Yes/No field showing Paperwork received and a Yes/No field showing Paperwork Returned. I am trying to create a report that will be run for a selected month that has each day of the month as a...

    mjp126210 pointsBadges:
  • Link Query to Report on Access 2010

    In an existing database, I have copied an existing query and an existing report so my new report will be in the same format as existing reports. I changed the criteria on the query so that it is pulling only the information I need. Now I need to link the two so the report will pull just that...

    LindaJenkins5 pointsBadges:
  • MS Access Report modifications

    I am using MS Access 2007. I am trying to modify a report and I want to delete the label in the page header section but not the detail field. I cannot find a way to detach the label from the detail field

    Heymon20 pointsBadges:
  • Showing or hiding fields in an Access report

    I have a db created for managing employee records. I would like to build a label report that shows or hides different fields on the label depending if a field has a value. The fields are Office, home address, city, state, and zip. If the member has an office location then i would like to hide the...

    USMCLew5 pointsBadges:
  • Access Report Headers

    I have a problem trying to display a report header at the correct time on a report I am building in Access (2003). Lets pretend I have a report with 3 levels (cuz I do!!!):  Proposal, Supplier and Parts.  The report is for the Proposal.  It is grouped by Supplier and then has a subreport for the...

    Clangingsymbol5 pointsBadges:
  • Erro in Subform in Ms Access Reports

    Hi All! I have a question that i have designed a report in ms access and I put a subform and linked it with the Party Group, I have put vb codes to use calculate some values if value on subform is null then VBA debug for error, I have used below all function but not solution is there: NZ(), Val(),...

    Rahmedarain200510 pointsBadges:
  • Error 2282 in Microsoft Access

    Hello all, I have a database that sends a report by email in pdf format automatically by pressing a button. My problem is that whilst this works perfectly on my computer, I get an error "2282 - the format in which you are attempting to output the current object is not available." on other users...

    Pmallick5 pointsBadges:
  • Microsoft Access Audit Report

    I have an audit with an "Action Taken" field and all of the fields in the original table. If the action is "Changed From", the action in the very next line will be "Changed To". I want the Audit Report to show 'before' and 'after' values for only those fields that changed, with all else blank. I...

    WayneW194720 pointsBadges:
  • Access Reports to PDF file

    Greetings, I have an objective that's been driving me in circles.... Windows XP Office 2007 I need to figure out how to convert "multiple" Microsoft Access reports into one pdf file through vba. Access 2007 has easy way to convert one report at a time to pdf, however, I cannot figure out how to...

    SeenFresh25 pointsBadges:
  • Using Microsoft Access to create reports from MACOLA

    Where can I get instructions on using Microsoft Access to create reports from Macola?

    SQL Server Ask the Experts2,585 pointsBadges:
  • How can I print all picture attachmens attached to a record on an access report

    I have a number of records that each have multiple attachments (pictures)> I have created a report and only the 1st attachment of each record prints on the report. Is the a way to have all the attachments print on the report for each record?

    FBDave5 pointsBadges:
  • Sending more then 1 Access Report to Outlook

    Hi, I have 2 Access Reports which I need to send to Outlook as attachments. I usually use SendObject, but that only allows for 1 attachment. I am using Access 2007 Thanksyou Julie

    JulieSandra15 pointsBadges:
  • Problems with VAL function

    I have a table with an NVarChar field that contains left aligned numeric values. I've tried using the VAL function to return the integer values, but I'm getting back Short Date results. What can I do to get integer results? Thanks, Arlin

    Arlin70 pointsBadges:
  • Hide Header In Access Report

    Hi, I have a report built in Microsoft Access that has a page header and a header for one of my fields named JobNo. Well, I wanted to know if there is a way to not display the page header with the jobno header? I know there is a way to not show the page header with the report header but I haven't...

    RoadDust390 pointsBadges:
  • Justified alignment in Microsoft Access

    Dear Sir, I have put one memo field in Ms-Accees report. I want it to be printed like this : |.....................................| |.....................................| |.....................................| |..................| Please reply, Thanks, Sandip

    Ssandbhor10 pointsBadges:
  • Access 2007 Report displaying the content of three different fields in one box?

    I am creating a report in MS Access 2007. I want to create one box that displays the content of three different fields. i.e. Salutation First Name and Last Name. I used to do this in Access 2003 this way =[Salutation] & " " & [First Name] & " " & [Last Name] but in 2007 I am getting an error. Any...

    JustDave5 pointsBadges:
  • Report Question-Is it possible to get a “new user” report when the only date is used also for date they used services?

    Is it possible to get a "new user" report when the only date is used also for date they used services? The only fields in the table are Student ID, First Name, Last Name, Date of service and hours used.

    Triel5 pointsBadges:
  • Sending MS Access reports in the body of an email.

    How to send a report in MS Access to the body of an email in MS Outlook.

    Rarto10 pointsBadges:
  • Report -Conditional Format with multiple conditions: Access 2007

    I am trying to generate a report that will change the font to different color if of a date field but the total number of days will change if another field = ?. So basically if [TYPE] = CHILD then DATE()-30= (red font), and DATE()-31 BETWEEN DATE()- 60= (yellow font) and DATE()-61 BETWEEN DATE()-...

    Nichalos825 pointsBadges:
  • MS Access – Count of parent table items in a report

    I have an MS Access database with a parent table and a child table. Table A (the parent, an Order table) has a PartID field, an OrderDate field, and an CustomerID field. Table B (the child, Parts) has a PartID primary key field and a PartDescription field. A relationship joins the 2 tables on the...

    LegacyDave5 pointsBadges:
1

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following