Help Creating A Summary Report

Aug 23, 2004

Lets say I have table with the following information:

OrderNo. ProductId Count1 Count2
01 AA 2 0
01 AB 0 1
01 AC 1 0
01 AD 0 3
02 AD 0 2
02 AE 4 0
02 AB 0 1
.
.
.

A count in Count1 means 0 in Count2 and vice-versa

How do I create a report that looks like this:

OrdeeNo. SumCount1/SumCount2
01 (3) / (4)
02 (4) / (1)
.
.
---------------------------
Totals (7) / (5)


Thank you

View Replies


ADVERTISEMENT

Creating Summary Of Data

Dec 19, 2006

I have the detail data in a query working fine in MSAccess 2000 sp3 and I'm trying to create a summary of the data. My query is as follows:

SELECT CUH.CULevel, CUH.AREA, TYPES.Asset, Count(TYPES.Asset) AS Counts
FROM (TYPES LEFT JOIN Broker ON TYPES.[Owner/LastLogin] = Broker.LOGIN_ID) LEFT JOIN CUH ON Broker.COSTUNIT = CUH.COST_UNIT
WHERE (((TYPES.Asset) In ("T30", "DESKTOP")))
GROUP BY CUH.CULevel, CUH.AREA, TYPES.Asset;

with the output like:

CULevelAREA AssetCounts
11000Disease AreasDESKTOP121
11000Disease AreasT3036

but I'm trying to get the output like:
CULevelAREAT30Counts Desktop Count
11000Area136 121

I'm pretty new in MSAccess and I've tried a number of things, but this is the closest I've gotten. Any help from anyone would be greatly appreciated!

View 4 Replies View Related

Multiple Summary Total In A Report

May 19, 2015

How can I generate a report that contains multiple summary total by year. I run the query to give me selected time period(s) for my report. For example: I want to have the summary for the date ranges from the year 1994 to 2001, and then 2002, 2003, 2004 etc. I'm having difficulty for the first summary total which is the date range from 1994 to 2001.

View 3 Replies View Related

Forms :: Report Form With Summary Data

Mar 12, 2013

I am trying to create a report or form (not sure which is most suitable) which when opened will show a summary of my data.

My data is essentially a table of timecards, with various linked tables which together enable time working on a lot of different projects to be recorded and reported on, and the value of the work can also be reported on.

In other words it's a bog standard time-recording system.

I can generate a number of reports, for example a report showing all projects with unbilled time and the value of that time.

What I want to do is produce a Key Performance Indicator (KPI) report/page showing total time worked in the last 7 days, month, quarter, year and the annualised amount of the first three of those.

Also I want to show the value of each of those in billing terms, e.g. what was the time recorded in the last quarter worth, and if that continued all year what would be the annual value.

I have created summary (total) queries which return all of these numbers. Essentially each query has a number for the period and a number for the same figure annualised.

I am trying to get all of these figures onto one page.

If I create a report based on one of my queries (by opening the query and clicking Create/Report) Access generates a lovely report showing my two figures generated by that query.

My problem is that I cannot get all of the different figures based on the different queries onto one report (or form).

Access will only allow me to show the figures that come out of the data source for the report or form. I cannot find a way to have multiple data sources.

I have tried creating text boxes where the data source is a different query. I dial up the query and the value, but all I get in the box is "#Name?".

I guess people must make this kind of KPI report or form all of the time. I read about dashboards and the like and see pictures of nice-looking Access pages containing all sorts of summary data, but nowhere can I find any description as to how to create such a page.

View 1 Replies View Related

General :: Summary Report - Real Time Data

Jun 3, 2014

Is it possible to pull the data real-time? I have this access database, and I need to pull the data every time it was updated.

Process name is given, I need to pull the time according to the process name and the volume,

Attached files is the output. The output should be in a form.

View 1 Replies View Related

Reports :: Summary Of Multiple Records - Open Report With Button

Jan 27, 2014

I have a report that is a summary of multiple records in it. What I have next to the record on the report is a button.I have report that are labeled:

rptIncident Summary
rptIncident Report
and a button labeled
"open report"

I would like to click on the button and then it open the rptIncident Report with all the information, not just the summary. I will put a picture so you know what I am trying to accomplish.Is this a simple Onclick event with a where condition or what? Or does this go beyond to having something to do with VBA?

View 14 Replies View Related

Modules & VBA :: Construct A Query With Number Of DCounts For Summary Report

Dec 16, 2014

I am trying to construct a query with a number of DCounts for a summary report, and each of those counts is to have more than one criteria.So far, the code below is an example of the code, which returns #Error in five rows

Code:
DCount("[ID]","Attendance","[Absent]= True & " And [Date]=" Between [Forms]![DateSelect]![txtStartDate] And [Forms]![DateSelect]![txtEndDate]")

I have a feeling that it is the criteria for the date that I have got wrong, but I cannot see the wood for the trees at the moment.If it makes any difference, all of the DCounts will refer to one table and will all be within the same date range.

View 11 Replies View Related

I Want A Form Like In Northwind Sample Database: Summary Of Sales By Year Report.

Jan 9, 2006

Hi,
I have a problem with form design,
I want a form like in Northwind sample database: Summary of Sales by Year Report.
It use Sorting and Grouping for Footer that I can't find it in Form design.
Is it any other way to do it in Form design so I can get the same result like in Report design?.
The reason why I want it, because I want to control the size.
thankyou in advance for your help.

Gunawan.

View 2 Replies View Related

Creating A Report From A Query

Oct 19, 2004

Sorry about the simple question, but my brain is not functioning today. How do you create a report from a simple query?

View 2 Replies View Related

Creating A Report From Two Or More Tables

May 18, 2006

Hi all,

I am a complete newbie so please beware/be patient.

What I am trying to do is to create a report from two table, using the wizard it starts complaining about the relationships between the two tables, though I only want to produce the table on one report.

Please help.

Thanks,

The Gurkentopf

View 1 Replies View Related

Help Creating A Simple Report

May 17, 2007

AFternoon,

I have never used Access before and i have been asked to create a report that displays the cartridge name and the quantity. This part was easy. But, the problem i am having is that i have a field in the database called "DoNotOrder". If the cartidge has the box ticked in the field "DoNotOrder", I do not want it to be displyed in the report. I was wondering if anybody could give me a clue into writing a statement to do such a thing.

ANy help is much appreciated.

Thanks for your time

Ollie

View 1 Replies View Related

Creating And Running A Query For Report VBA

Sep 6, 2004

I've been reading up quite intensively on using QueryDef's collection to try to pass a Parameter to a Query in order to then Open a Report. But can't seem to get it to work. I've been trying to write an SQL statement that the VB will accept in code but never got it to work. Depite copy/pasting the SQL from the Query Access creates. regardless.. I really need some help with this one. Thanks. Procedure follows. Get error that Report not found... The name is correct... I just want to pass the integer (index) from the ListBox into the Query then Open the Report... Thats all...

Private Sub previewReport_Click()
On Error GoTo Err_previewReport_Click
Dim intSelectMonth As Integer 'The Index of the Item Selected in Form List Box
Dim db As Database
Dim smReport As Report
Dim smQuery As QueryDef
Dim month As Parameter

Set db = CurrentDb
Set smQuery = QueryDef![GetReviewsMonthQuery]
smQuery.Parameters![rvMonth] = 9 'Using 9 as September just for Testing
Set smReport = Reports![Review Schedule by Month/Analyst]

DoCmd.OpenReport smReport, acPreview

Exit_previewReport_Click:
Exit Sub
Err_previewReport_Click:
MsgBox Err.Description
Resume Exit_previewReport_Click

End Sub

View 2 Replies View Related

Creating Report From A Form That Has Subform

Dec 6, 2004

I have a form with a subform in it and I would like to print the contents of that form to a report. I am able to print now, using a "print" command button, but it only prints one record, just the one that is being displayed. I want to be able to print a report with all the records that are in the filtered result.

Also, when the press the "print" button I would like to give them an option "Print this record?" "Print All records?". depending on the input, it would print the report.

Can someone please help me with this? Much appreicated.
Thanks.

ronnie

View 1 Replies View Related

Error Creating A Report From Query

Jul 18, 2005

Hello,

I can run a query but when I try to display this information on a report I get the following message:

The specified field “tblMachineData.TagName’ could refer to more than one table listed in the FROM clause of your SQL Statement.

Here is my SQL code from the quey.

SELECT tblMachineData.TagName, [tblMachineFloat Query].DateAndTime, tblMachineRunTag.TagName, tblMachineFloat.Val
FROM tblMachineRunTag INNER JOIN (tblMachineData INNER JOIN ([tblMachineFloat Query] INNER JOIN tblMachineFloat ON [tblMachineFloat Query].DateAndTime = tblMachineFloat.DateAndTime) ON tblMachineData.TagIndex = [tblMachineFloat Query].TagIndex) ON tblMachineRunTag.TagIndex = tblMachineFloat.TagIndex
WHERE (((tblMachineFloat.TagIndex)=0 Or (tblMachineFloat.TagIndex)=1 Or (tblMachineFloat.TagIndex)=3 Or (tblMachineFloat.TagIndex)=4))
ORDER BY [tblMachineFloat Query].DateAndTime DESC;

Any help is appreciated,
Bob

View 2 Replies View Related

Reports :: Creating IIF Statement In A Report?

May 20, 2013

I am quite new to access 2007 but trying to create an IIF statement in a report but don't know where to start.

My report has lots of 'Label' fields with standard text based on a query for the fields components. I want one of my labels to only appear on the report for print IF a record field called 'Program' (which is from a list) has the word 'RHICHOP' at the beginning of it. If RHICHOP is not in the beginning of the Program then leave out the label text.

View 4 Replies View Related

Tables :: Creating Expression On A Report

Mar 4, 2013

I have a database of students that have taken tests. That database includes how many attempts it took them to pass. I have successfully generated reports that sort the exams by type, date, student, etc. I would like to also somehow insert a formula to show the pass rate of those exams on the top of the report. I know I can get into design view and build an expression, but how would I build an expression that would create a pass rate percentage based on whether or not a student passed an exam on the first attempt.

I have a DB with a column titled "Attempt" and the options "First, Second, Third, Fourth". I would like the expression to generate a percentage of students that have "First" in their box (as opposed to anything else) out of the total number of student records.

We need to track student pass rates in my school for a re-certification process.

View 3 Replies View Related

Reports :: Creating SKU By Store Report

May 21, 2014

I have a table, it is fairly large but pretty simple.

It lists store numbers in the first column. Each column that follows is a SKU, and in the field it either has a 1 or a 0 to represent 1 if it is stocked in the store, and 0 if it is not.

Can I write a report that will show what each store has, and how do I do that? I basically want it to return the sku number (and its description) if it has a one in the box, but not if it doesn't.

View 5 Replies View Related

General :: Creating Report Or Query

Nov 9, 2014

I am quite new to MS access and started to develop a small database for my practice. I have made four tables that are for Patient details, their doctor detail, their problem and their treatment. I have successfully created form to enter the data.However I an unable to proceed, now I want to create a discharge letter which will be addressed to the doctor (based on the tables described above)

I want to make this in a way that if I enter the patient details i-e date of birth, ID and / or name a letter is created based on the tables above. I also want this letter to be saved for future use. how to design that letter and should it be a query or report.

View 6 Replies View Related

Creating A Dropdown To Generate Report

Jun 9, 2015

I couldn't find a better way to organize my data for an ongoing history project and so am trying my hand at Access.

So, I've got an Access 2000 database built, with 3 main tables - have relationships set up and which look to be working fine (two of the tables each link to one field in the third, main, table).

What I want to do now, is to be able to have a combo box - whether on my existing form (or likely a separate one), that I can just pick the town I want, then the database would return all the records in the main table for that town, and put that into a report.

View 5 Replies View Related

Creating A Report With Filled In Data?

Oct 1, 2015

I have a form that allows users to input data into a field called "Checked out". I was wondering how I can create a report that shows the forms (I have about a couple thousand) only with the "checked out" field filled in.

View 7 Replies View Related

Creating Chart Using Field Values From The Report

Apr 18, 2007

I have created a report using a query. Further to this, I have added some fields from the query into the report which calculates the sum of records and the count of records.

My problem here is, using the chart wizard, I am only able to select the fields existing in a 'Table' or a 'Query'.

Can anywone help me to create a Bar chart / Pie chart using the fields in the report? :confused:

View 2 Replies View Related

Creating A Report From Multiple Tables/forms

Jun 2, 2006

Could you please help me out.

I am trying to develop a DB that is multi user. i ahve not split the data from the forms into separate db's as the users are in different locations and our network can be very slow.

part of the requirerment is to produce a drawing approval form, my current sticking point is that the method i am currently using to create the forms only allows one person at a time to use the process.

currently i have a command button that runs a query and then creates a table from the results. the table is then used as the data source for a mail merged form in word.

what i ultimatly need is a process which allows multiple users to generate these forms at the same time and have the ability to save the form (with no code behind it) as a word document (either RTF etc)

i am thinking that if i create a query on the fly in VB and then use the results to use in a report this would allow me to do the above.....

So my questions are:

1) is my assumption correct
2) If so, how do i do it as i have never done it before
3) If the above is not the best solution/ does not work... what will/is

View 4 Replies View Related

Creating A Checkbox That Returns Text On A Report

Apr 12, 2005

Dear All:

I have created a form with students information, name, address, ID number, etc.

Is there a way to place a checkbox on this form that when it is checked, it displays text on a SPECIFIC AREA ON A REPORT?

I wish it to return this text on a report: "HONORS COLLEGE"

Many thanks in advance,

Dion

View 2 Replies View Related

Help Creating Report With Multiple Detail Sections

Mar 27, 2008

Hi,

I need to create a report for each employee in my company of all compensation information. The report is going to need to have multiple detail sections on the report for example to list all benefits specific to the employee and all beneficiaries.

I tried using a subreport to produce those detail sections that I needed but once I placed this subreport inside a box on the main report each detail I created increased the size of the box. I also thought about making the detail section a list box and writing all of the information there. Would there be a better or easy way to accomplish this?

I am also thinking I am going to have to save all of this information in a table and based the report on that table?

Any help would be greatly appreciated.

Thanks,

tones

View 12 Replies View Related

Creating A Report Based On A Date Range

Jun 19, 2007

I have a database with several clients who have a series of appointments. I want to be able to create a report of all the clients to be seen during a range of dates to be inputted by the user. All help would be greatly appreciated.

Andrew

View 1 Replies View Related

General :: Creating Report From Multiple Sources?

Jan 28, 2013

i want to create a summary report from multiple queries.

what are the best possible methods for this ? should i need to use subreport function or anything else?

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved