Reports :: Creating Reports From Imported Excel Sheet

Jul 9, 2013

i have an excel data for assets and i have imported it into access 2010 but i want to be able to do the ffg;

1. want to be able to generate reports like how many computers does a particular branch have.
2. i want to be able to sum the no of each field heading per branch

View Replies


ADVERTISEMENT

Creating Excel Sheet From Access

Sep 30, 2004

I have written a piece of code in Access that creates a Excel work book. The work book is populated with the various data and then made visible to the user.

Everything is working perfectly apart from one minor problem.

When creating a new workbook excel automatically puts 3 worksheets in... If the code creates 1 or 2 sheets of data I want it too delete the sheet that is blank. This is easy to do although it always prompts the user for confirmation.

How do I delete a worksheet without the prompt?

I have hunted everywhere for the answer and can't find it anywhere, any help would be great.

Example of code:


Dim XL As Excel.Application
Dim WkBook As Excel.Workbook
Dim WkSheet As Excel.Worksheet

Set XL = CreateObject("Excel.Application")

Set WkBook = XL.Workbooks.Add

Set WkSheet = WkBook.Worksheets(1)

WkSheet.Delete

View 1 Replies View Related

Reports :: Custom Reports Creating Chart Based On Month Not Calendar Year

Jun 15, 2015

I am editing a database that provides the option of creating custom reports, where the user can input a date range of their choice and receive aggregate data for that time frame. Although all of the numbers in the report are correct, I am having trouble with a chart that I inserted into the report.

Specifically, if the date range requested spans 2 calendar years (i.e. April 2014 through January 2015), the data for January 2015 appears at the beginning of the year (so the chart x-axis is for Jan through Dec, and the Jan 2015 data is showing up in Jan (as if it was 2014, not the end of the given range in 2015). When I try with smaller time frames within a calendar year, it adjusts just fine (i.e. shrinking the window so just March-May is displayed on the graph).

How to adjust the axis so that it properly records the data range- so that it would start the axis with April and end in January, for example?

View 2 Replies View Related

Imported Table Not Included In Reports!

Sep 2, 2004

I have an imported table that I created a form for (containing 400+ entries). I created a subform on it for a new table that I will be entering information to tie in with the imported form.

However, when I try to create a report, the report won't acknowledge any of the information. It's all outlined in the SQL, but nothing appears.

I did discover, though, that if I create a new entry on the imported table, that information appears on the report, but nothing for the existing data that was imported.

Please help!!!!!

View 1 Replies View Related

Reports :: Attendance Sheet - How To Make Crosstab Query

Mar 15, 2013

I am making some attendance sheet on access as follows

Name !09:00!10:00!11:00!12:00!13:00!14:00!15:00
------!-----!------!-----!------!-----!------!
Test1 !Prsnt! ! ! ! ! !
test2 !Absnt! ! ! ! ! !
test3 !Vction! ! ! ! ! !

I have tables like

workersmaster(workerid,workername,joiningdate,stat us)
Workerdetail (Workerid,workername,entreetime,attendance)
timing(timing(0900to1500)

Now I wanted to make report as mentioned above, how can i do this?

View 4 Replies View Related

Reports :: Making Sales Sheet On Access Using Existing Table

Aug 29, 2013

I have a table which has the fields: Agentname,SaleDate,Branch,Sales, Percentage, Comission, Corrections, rent and Total

Total = Sales-comission+Corrections+rent

This table has the name of the agent that made the sale, the branch(location) where he made it, the date, the commission of how much he gets from the sale, Corrections which is various correction that need to be made like a refund and or bonuses, Rent which he pays and the total.

what i want to do is to get access to make me a sheet( a sales invoice) where i can see the sales for a specific agent for a specific branch. agents can work at multiple branches.

so lets say agent A on branch A sold 400 on 1/8, 300 on 2/8 and 500 on 5/8 i want to get a list of all the days from 1/8 till 31/8 and the records of 1/8, 2/8 and 5/8 automatically attached to the correct dates and the rest of the dates should have a value of 0.

View 4 Replies View Related

Creating New Queries And Reports

Aug 9, 2005

I am trying to create a new query and a new report in my database. The program will not let me. The "new" is grayed out. Can anyone help me? :confused:

View 14 Replies View Related

Creating Reports On The Fly Via Form Checkboxes

Apr 5, 2006

I have been searching and searching for a solution to this problem, but have been coming up short.

I have a database which lists tests done on certain products. Each product requires different tests, so it is not feasible to make a static report for each product.

My problem lies in creating a report which has the product name and number at the top of the report, and below that, I want to list test results based on information passed from a form through checkboxes. I really am not sure how to create this report because the tests change with each product, so I cannot include static headers for each test.

The way my form is set up is I have the Product Name/Number at the top, and right below that are several checkboxes which are named after each test. I want the data from these tests to populate the report.

Any help would be greatly appreciated!

View 3 Replies View Related

Creating Reports On The Fly Via Form Checkboxes

Apr 5, 2006

I have been searching and searching for a solution to this problem, but have been coming up short.

I have a database which lists tests done on certain products. Each product requires different tests, so it is not feasible to make a static report for each product.

My problem lies in creating a report which has the product name and number at the top of the report, and below that, I want to list test results based on information passed from a form through checkboxes. I really am not sure how to create this report because the tests change with each product, so I cannot include static headers for each test.

The way my form is set up is I have the Product Name/Number at the top, and right below that are several checkboxes which are named after each test. I want the data from these tests to populate the report.

Any help would be greatly appreciated!

View 1 Replies View Related

Reports :: Creating A Pie Chart Format?

Apr 20, 2013

I have browsed a few forums and am still having trouble creating a pie chart that has the proper layout that I would prefer.

I have created a query that will list the data I would like to organize into a pie chart. The query, when run, will prompt the user for a start date and an end date and then display the data in this form:

EmployeeX | SumofProject hours | SumofDemo Hours | SumofAdministration hours | SumofEtc hours (5 other categories of hours)
EmployeeY | SumofProject hours | SumofDemo Hours | SumofAdministration hours | SumofEtc hours (5 other categories of hours)

OK, now that I have the data in this format I would like to create a report that includes tabs for each employee, each tab will have a pie chart that has one employee and a pie chart showing how their hours are allocated to each task. e.g. tab 1 would have Employee X and the pie chart would show what percentage of this employee's hours was dedicated to project/demo/admin/etc...

View 1 Replies View Related

Reports :: Creating A Classroom Schedule?

Apr 6, 2015

how to go about creating a report that lists a traditional style class schedule?

I would like the times on the X axis and the days of the week along the Y axis. Ideally, the name of the class and student list would be included.

I have all this information in a database, but right now my classes are being generated in an excel program (by hand) and I'd like to automate it somewhat since some class information is being changed on weekly basis.

View 14 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

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

Creating Reports Using Combobox User Input

Apr 10, 2008

Please could somebody point me in the right direction of code.

I have a database which I would like to query using a form with a combobox or two, each of which containing a list of eg. Customer Names, or Reference Numbers, which will then produce a report which can be printed out.

I know basic ADO, like get the database, open it, find records, update and delete records, however I have been unsuccesfully searching for the code to open a report, which will respond to certain sql parameters that correspond with the values in the combobox. And then be able to print that report if possible.

I would be much appreciative if anyone would point me in the right direction,
Thanks!!

View 2 Replies View Related

Creating Reports From 3 User Defined Critera

Nov 16, 2004

Please advise, how do I set up a form for this:

Based on one particular report style, have multi select criteria to produce user selected criteria

based on selections from a. Interest, b. State, c. Type

Report 1. sorts on Interest, 2. sorts by State, 3. sorts by Type ... and each report includes selections of the other 3 selections plus basic data common to all.

Plus, the Interests have a table where the main interest data is stored in a ContactInterest table, while the specific interest selections, per contact, are stored in the Contact table as Interest_1 through Interest_20.

In the Report, when it is sorted by Interest, while I have a concantated output for 5 of the selections, they also, want to sort alphabetically by the interest selections (which changes per Contact).

There is already a form for printing reports that are more static, and I wanted to add these selections on that form, perhaps as a subform, to allow printing of the reports, mentioned, and associated mail labels to the targeted addresses per group.

Any help, direction, guidance, or redirection would really help and is MUCH appreciated. I've tried many options, and as a newbie, have not yet found a solutions- or solutions.

Thank you so much. (time is of the essence and my skills are small so far.)

__________________

View 1 Replies View Related

Reports :: Creating Report Similar To A Spreadsheet

Jun 19, 2015

I'm working on a project where I'm supposed to take an excel spreadsheet and replace it's function with Access. So far I have created the form, table, and query, now I just need the report which (according to my boss) needs to mimic the existing spreadsheet.

I know this is probably not going to be fun, but hopefully somewhere out there can give me a few pointers?

Attached is an example of what the spreadsheet looks like (Capture1) and what I currently have in my report (Capture 2).

View 6 Replies View Related

Reports :: Creating Field Using Expression Builder

Dec 18, 2014

I am using expression builder to specify a field in a report but it is acting more like a filter.So I have a report based on a query. However I want to add a field that is not in the query but is in a related table - called tblAgent.

So using expression builder I select the tblAgent in Expression Elements and then select the field from this table. This creates the expression =[Agent]![AgentAddress] however when I try to run the report it asks for a Agent parameter? Do I need to go back to reports 101?

View 1 Replies View Related

Reports :: Creating Calculated Fields On Report

Feb 5, 2014

I have a field I need to create on my report that needs to be based on what is in another field on my report.

If Note (that's my field name) = 1,2,3,4,5, or 6, I want to sum a field called PlateNumbers.

What is the syntax?

View 10 Replies View Related

Reports :: Creating Delivery Report - Week View

May 9, 2015

Im creating a database that we can enter jobs into.A job will consist of 3 seperate parts, Called "Trusses", "Walls", "Posis". They will each have a different delivery date and possibly a delivery time.

I am having trouble creating a report that gives me a week view, Monday to Friday, that shows what deliveries are on each day.The main thing here is there is one job entry, with the 3 parts. So there will need to be 3 seperate entries on the report for each part of that job.

View 8 Replies View Related

Help With MP3 List Imported From Excel

Apr 17, 2006

I have impotred a table of my MP3 music collection from Excel in to Access.

The Fields it contains are: "Artist" - "Album" - "Track Name" - "Track No." - & "Duration"

I would like an option to be able to list only the Artist & Albums - However, when I try I end up with a list of duplicate values for the Album field (as these relate to track 1, track 2, track , etc...)

I'm sure there's a simple solution..

Can anyone please help....

Thanks,

Alun Kane

View 2 Replies View Related

Excel Imported To Access

Nov 9, 2006

Hi,

I have a table in Excel, and when I import the table in Access, some records from a specific field shows #Num! after importing, even before I imported the table, I selected the entire field in Excel and I Formated all cells to text.

The specific field hosts records in digit format[34222256], and sometime in mixed letter-digit format[M22228778], but are supposed to be as TEXT! After importing I see the first as #Num!, and the second as M22228778.

How can I get around this issue in Excel or Access.

Thank you!

View 6 Replies View Related

Imported Excel File

Apr 25, 2008

I have imported a worksheet from excel.

I am trying to use query criteria to seach.
the feild I am trying to search was a custom 000-000-000 cell.

I have been trying to use like "001*" but am getting nothing back.

what should I do. Do I need to change the info in excel and start over?

thanks

View 3 Replies View Related

Printing Reports In Excel

Jul 17, 2006

hi. i am working first time with query and reports. i have created a database. i have reports and query. i have a button in my form by the name of (View reports) if a user clicks on that button it opens another form with 3 options
1) Problems all report
2) problems resolved
3) Problems not resolved
Now what i really want is when a user clicks on Problems all report it should go directly into excel worksheet based on my query which i have assigned and the width, column should be perfect in excel so then a user can print. secondly same thing goes for problems resolved based on my query which wil show all the problems which have been resolved and should open it in excel with everything alligned and ready to print. i know it is possible and i have been able to just print Problems all based on report not with my query and the formatting was really bad. i need to print reports based on my query directly in Excel worksheet with everything perfectly formatted. any help will be really appreciated.
Thanks alot

View 1 Replies View Related

Reports In Excel Format

Aug 9, 2006

hi guys. i just wanna know if the reports that will be generated by ms access can be in ms excel format.

btw, i am using ms access 2003.

thanks in advance. =)

View 2 Replies View Related

Reports :: Export To Excel

Jul 2, 2013

I'm trying to Export one of my Access Report to Excel, I kept getting this error message.. "There is an Invalid used the Dot, or ! Operator or Invalid of Parentheses..My report is working fine, except when I try to export it to Excel, then this error message pop up..

View 1 Replies View Related

Reports :: Creating Report That Show Only One Record From Query Or Table?

Feb 19, 2014

I am using Access 2007. creating a report that show only one record from my query or table.

View 5 Replies View Related







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