General :: How To Create A Series Of Different Tables And Reports
Aug 3, 2012
I currently have 3 spreadsheets with simliar information. How can I take a database and export only select fields to make either a report or table? Here is the example with types of info i will be using:
100 communities and all their roads. Each of these communities are in a borough, which is then in a region.
Then we have a mileage for each road. Where I have difficulty is that we have another set of data that would be fine if we could just include into this which is all of those roads but additionally they have:
Classification
Surface type/condition
Traffic count
Some roads have two classifications.. each of those having a mileage. I would really like to see all of this data in a database that spits out the needed tables and totals.
View Replies
ADVERTISEMENT
Jul 5, 2013
I have a table in access which captures a couple of bits of information. The database is for tenant management and payment records. This is what i am trying to achieve:
In one table I record payment information, when they paid, and how much they paid.
In the lease table I capture information such as first pay date, and the payment schedule, whether this be weekly, monthly, fortnightly etc.
I would like to create a table of sorts which has the next twelve months worth of payments dates. Then when i add a payment to my payment table it will match it up with the correct payment date. This will allow me to track arrears and missed payments.
View 3 Replies
View Related
Jul 8, 2015
I need to know if possible to create multiple queries or reports at the same time. We have large table that is updated monthly this report gets broken down manually by Manager (30 managers in total) hen email to each manager.
Report or query specs will never change only the data I could do this manually create and save query/report for each manager once but I was wondering if there was code that will create all the queries and reports at the same time.
View 1 Replies
View Related
Sep 6, 2014
My application is a series of checklists, represented each by a table. They all have a common "Job ID" which is entered by the user in the first form/table. This "Job ID" is a common value with all other tables.
What I want, is that the user doesn't have to enter the "Job ID" every in every form. I just want him to enter it once in the first menu, and then it's copied automatically to all the other tables (creating a new record in each table).
View 2 Replies
View Related
Mar 12, 2013
I am trying to find an algorithm to identify patterns in my data.
My task is to accomplish whether the data shows a very sharp decline and whether or not it follows previous fluctuation.
If it declines sharply and doesn't follow previous fluctuations it will indicate a production problem.
My time series data is as follows.Also sharp decline according to the below data is highlighted.
Data
-0.027663709
-0.057051957
-0.077941988
-0.070009989
-0.033860193
[code]....
View 2 Replies
View Related
Oct 21, 2012
I'm pretty new to making databases outside of a basic access class..Is it possible to make a record in one table that makes a new record in 5 different tables using different bits of the initial record?I want to use the data entered in an evaluation form to create a new entry with the basic identifying information in 4 different tables.
View 12 Replies
View Related
Jul 10, 2012
I think what I want is:
1 table(1): record of people & contact details
1 table(2): list of events with check box's with the names of people from the other table
1 report: listing how many events people have attended.
When I add a new person to table 1 I want a field to be added to table 2 in the form of a checkbox, also when I delete this person I want this field to be deleted in table 2.how to make this an automated process.
View 1 Replies
View Related
Aug 19, 2013
The interface being used is a main form with various tabs and a subform on each of these tabs.
There is one field ('max power density') in my database that is calculated using 'Max Rated Power' and 'Cylinder Capacity' however these are in different tables and subforms. The 'max power density' and 'max rated power' are in table and subform 1 but 'cylinder capacity' is in table and subform 2. Is it possible to keep them in separate tables/subforms and still calculate the field?
View 7 Replies
View Related
Sep 7, 2012
I have a client who needs a Database created in Access for him. he would like to regularly auto-populate this Access DB from an Excel file - like twice a week.In addition, he wants me to create Forms, Queries, reports and Macros for him in the Access, which will have 2 Tables from Excel files and about 3 Tables created in Access.I figured that I could do that if I gave him a link to the Tables he needed from the Excel file(s). But how do I work remotely for him- the path to those files is on his computer. I can load them to mine, but then he can't open the files.How can I create Forms etc. in an Access DB which uses links from source files as its Tables?
View 2 Replies
View Related
Apr 2, 2013
I have 4 queries in which data needs to be connected from the date and shown as a single date showing each sections entry in a row and a cumulative total is maintained as the balance .
See the attached image ...
View 7 Replies
View Related
Jan 27, 2014
I have a DB with 3 tables;
1) Customer details (address, phone etc)
2) Equipment they have
3) Service History
So that I can print a report showing all of the above on a A4 form I have a simple query which filters using a tick box (on Customer Details).
This works well unless I tick 2 box's. I then customer details, equipment & Service History get jumbled up and isn't record specific.
View 3 Replies
View Related
Sep 22, 2013
Is there any systematic way of naming Tables, Queries, Forms, and Reports in order to identify easily which of them are connected to each other?
View 1 Replies
View Related
Oct 31, 2013
I created a database and I manage to split it into front end and backend. now I'm going to make an EXE of the front end.My question is when I open the front end, I need the database to be empty, and them create a button that will make the user select which project he wants to open (backend).I also need to create a button that will create a new empty backend and save it as a new project.
View 7 Replies
View Related
Feb 18, 2015
Is there a way to have say five different reports that give out information and at the bottom the totals. I would like to take each of those separate reports to create one report with just the totals.
View 3 Replies
View Related
Feb 18, 2014
In my tables i have used calculated fields. one of the fields is to "total expenses." In a report, i need to show the sum of all the "total expenses", the filed populates in the report but the cents are missing. for example if the amount is 6080.40 it shows as 6080. how can i get around this? I have tried changing the decimal point value to 2 at which point the value turns to 6080.00 when it should be 6080.40 (i am a beginner at this i am assuming the answer will probably involve c++ or visual basic's, two concepts i am not familiar with.)
View 2 Replies
View Related
Apr 21, 2014
I have a database of high-school football players, and I am looking to print out single page reports (or forms) that will show detail from several tables and queries. This will act as their resume when they visit schools on recruiting visits. The reason for needing query items, is that I have developed queries that return the most up to date height, weight, 40 time etc., and that single most up to date number is what should print, not the entire table. When I try to build a report it will let me bring in multiple tables, but not queries.
View 2 Replies
View Related
Sep 5, 2013
I'm trying to create a table for every record I have in a field. I have two tables, one titled "Experiments" and another titled "Students". I want the new tables generated from the field EXP_NAME from Experiments. I need it to have seven fields, one copied from Students, five labeled Trial1 thru Trial5, and a final for a grade.
View 10 Replies
View Related
Jan 18, 2007
Hello all. My client has decided they like the pivotchart format better than the regular chart format, especially for its dynamic quality ( it can expand and contract with form adjustments.
One chart I am having trouble replicating in pivotchart format is one that plots two data series. One series is made of columns representing large numbers, generally several hundred or thousand, and the other data series needs to be a line which usually ranges between 0-10.
Obviously they cannot be represented on a y-axis with the same scale. This is simple to handle in MS Chart.
Is there a way to make a pivotchart with a dual-scaled y-axis, and map a data series to each one?
Thanks in advance.
View 7 Replies
View Related
Jun 17, 2013
I am trying to develop a form in the light of budgeting, therefore, I am designing a form with all possible options being an accountant I can think (it just a try nothing else)
Now here's the scenario
Fiscal Year
Period
Month
Working days
Period - Month - working (are my heading)
1 - Jan - 22
2 - Feb - 18 and so on
This is what I am trying to learn, if I select period 1 "Jan", application/code fill -out remaining months automatically, e.g. Period 2 "Feb"; Period 3 "Mar" .....
and if I select Period 1 "Mar", then period 2 "Apr", Period 3 "May" ......
Currently, I am using combobox, but problem is, if I selection period 1 = "Jan", then I am unable to restrict period 2 using "JAN" as both combobox are separate.
View 1 Replies
View Related
May 22, 2005
Is there a way via code in a module to automatically create a snapshot of a report, save it in a specifed folder location in the code and save it as the current date as the file name when a button is clicked.
I'm looking on how to do this as I have many reports to create, move to an intranet folder and then name it to the current date. It will save me lots of time if this can be done automatically.
I am using MS Access 2000 and the folder location will be on my hard drive.
Thanks
Aden
View 2 Replies
View Related
Nov 26, 2013
I am having a DB and a report is there from query now what i want is ;
if query fields are apple, bat, cat, dog, elephant and I want in report the first three fields like apple, bat, cat to be displayed at first page then remaining on next and so on. Whereas I have a proper report header and footer which I do not want to change for any page means will remain same for all pages..
View 3 Replies
View Related
Jan 30, 2014
I'm having an issue trying to get a report to show a single customers' data on one report. The way I am doing it at the minute isn't really a way I would like to do it, using a query to create the report, but I don't know how to do it via a form. Basically when I do it at the minute, it will create an invoice... but with every customers' data on the same report.
But what I want to do is have it so that when I create a new record in a form, when I press a button it will create a report with just the information in that form and the details of the customer (as the form only uses the customers' ID)...
View 1 Replies
View Related
Feb 12, 2014
1Create a report called rptCustomersByGender. The report should:
a.Print your company's name at the top of the first page only
b.Print your data labels at the top of each page
c.Group your data by gender
d.Display all the customer information in the detail section
e.The customers should display in ascending numerical order by Last Name
f.Below the list of Female customers, it should say: "Total number of Female Customers:" and then the total number of female customers should display. Do the same for the male customers
g.The page number should display at the bottom of every page
h.The list of Female and Male customers should each print starting on a separate page.
i.Make sure the report runs without producing any errors and looks professional.
I created a report and grouped it by gender but I can't do step F. creating two different labels for each group..
View 1 Replies
View Related
Oct 7, 2006
Fantastic site!
This is the first time i've posted - Everything I normally have a Question around is answered already!
Can anyone help with the following.
I have a table with 3 columns
Reference | Supplier Notes | Found |
ABC12312 | Text Text ABC12312 text text | <Yes>|
I want to perform the following test. If Reference is found in the supplier notes match bring back a result of yes If not then leave the detail blank.
It seems simple enough but i can get my head around this
Can anyone help?
View 2 Replies
View Related
Sep 3, 2007
Dear All,
once again I need your help, I have no idea how to tackle the following problem. I am taking records of stock market transactions. As a final result I want to have a query which gives me for every end of the day the total value of my portfolio.
Therefore I have two tables. The first one, called tblTransactions with columns - among others - Date, Ticker, Quantity, Price does contain my transactions. The second one, called tblQuotes with columns Date, Ticker, LastPrice contains prices for each security traded for every day.
The following SQL code gives me the portfolio holdings with the respective LastPrices on an arbitrarily chosen date (03/09/07):
SELECT T.Ticker, sum(T.Qty) AS TotQty, Q.qCl AS [Last Price], (T.Qty*Q.qCl) AS [SubTotalValue]
FROM tblTransactions AS T INNER JOIN tblQuotes AS Q ON T.Ticker=Q.qTicker
WHERE T.Date<=#3/9/2007# And Q.qDate=#3/9/2007#
GROUP BY T.Ticker, Q.qCl, (T.Qty*Q.qCl)
HAVING sum(T.Qty) >0
ORDER BY T.Ticker;
This works so far. However, now I struggle with the next step. I want to have a query, which for each date (I could use the date column of tblQuotes) adds all SubTotalValues, i.e. gives me the total value of my portfolio for each day.
Could you give me please some hints on how to proceed from here? I would be very pleased if somebody could help me with that question.
Best regards
JapanFreak
View 4 Replies
View Related
Nov 2, 2007
Hello Everyone,
I am in need of your vast array of knowledge and experience. I have been fighting with this Access report for a few days now, and I've finally decided to ask for your help.
I am running a report which provides a look at a set of 12 survey results. The 12 items are numerical in nature and are decimals with 2 decimal places. What I am trying to do is have Access automatically highlight the top 3 scores in one color, and the bottom 3 scores in another color.
So what I need is an expression that allows Access to discern the top 3 and bottom 3 from the series of 12 scores. in Excel you can identify the top score with this with the formula "Max(A1:A13)", but seeing as in Access we don't have the cell identifiers, this approach will not work.
I know that I will need to use conditional formatting in order to get the cells to highlight. I also see that there is "Max" and "Min" functions in Access as well, and I attempted to create and expression like this "=Max([field 1] AND [field 2] AND [field 3] AND, etc...)" with no luck. I also tried changing the "AND" to "OR", again without luck.
One thing that I should mention is that the report does contain a lot of other data, so I need to be able to apply whatever the best fix is, to only those 12 fields.
Unfortunately I am not accustomed to using code, and as a result I am unsure of how to input it properly. I am certainly open to code solutions, but I would also need a explanation of how to put it in properly.
The easiest solution for me, if possible, would be an expression that I can enter into the conditional formatting wizard to tell it to highlight the values.
If anyone has any ideas, I would appreciate it. I'll buy you a virtual beer :-)
View 5 Replies
View Related
