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 Replies
ADVERTISEMENT
May 2, 2013
What I would like to accomplish is to make a report similar to this, except make it automated so I won't have to change the dates. Users would be able to bring up a current schedule without worry that it's updated or not. The schedule repeats itself every 6 weeks. I made a cross-tab query, but I must admit that I'm not too familiar with working on them.
View 14 Replies
View Related
Jan 26, 2015
I am trying to create a report for 5 different dentists schedule for their current date ( and also allow a search for upcoming appointments)...
I know it requires a query but im not to sure what direction to take as i have never created a report before...
What needs to appear on the query? im aware it would be all the fields i want on the report but do i need to make changes in the criteria etc..
I also dont really know how i can create a report for each dentist because i dont want to have 5 different reports.. is it possible to have the report set where i type the dentist name and select which one i require and then i can view their schedule?
View 1 Replies
View Related
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
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 1 Replies
View Related
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
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
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
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
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
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
Feb 22, 2007
Hey thereI'm currently doing an ICT project for some school work, in which we all have to make access databases. My database is based around a fictional company that provide driving lessons. I've set most of the tables up including clients employees, bookings etc, but i'm wondering if its possible to implement a schedule within access?I would like to know if its possible for say if someone booked 2 hours of lesson, 2 blocks within the schedule table would be filled, or similar to a calender function, e.g. each day has 6 openings within it, and as these become booked the next day is filled.i've searched around a bit and can't really find anything but i'm very new to access so any advice would be much appreciated, or just being told that it isnt possible to implement such a schedule or calender would also be useful as then i wont be wasting time looking :PHope i've posted this in the right place, sorry if i haven't.Thanks in advance.BenJust found this website: http://www.aislebyaisle.com/access/calendartool.htmkinda similar to what i'm looking to do, just wanna know if theres anyway of doing this thats less complex? or free?
View 4 Replies
View Related
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
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
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
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
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
Aug 2, 2007
Hi all,
I'm relatively new to Access and would like a few pointers...
I have been asked by work to create a schedule database. We would like to be able to put in dates and see who's working on that day, pull up an individual and see his/hers rota for a week. Also see if they have meetings, annual leave, sickness etc.... We want it to be a very primitive WFM tool. Is this possible and is it relatively easy? The database doesn't have to create the shifts, they will be imported from Excel....
Which leads me to believe I need to think of it differently to excel... Attached is an excel rota, which would need to be importred - but maybe I need to be think a lot differently.
I know thats a big question but any help would be appreciated, or pointers to more resources... Thanks
Neil
View 4 Replies
View Related
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
Dec 29, 2005
Good Day everyone,
I am looking at setting up appointments and having Access automaticly schedule the next appointment in either 6 months or a year depending on the Vender. I've search the forum and can't find anything.
For Example if their last appointment was 12-1-05 I would like access to automaticly schedule the next appoint 12-1-06.
Any ideas?
Thanks,
View 9 Replies
View Related
Jul 4, 2006
Hello Everyone
I need to make an employee schedule in access. I am not sure if it is possible, but here are my constraints:
20 employees
5-6 different truck locations (sm1, sm2, sm3, sm4, sm5, sm6) These locations are scattered within our service area.
2 employees must meet at the same truck, (each truck has 2 employees working on it)
some employees can only meet at certain locations (ex. paul can meet at either sm2 or sm3)
all employees are PT so they can only work on certain days or a certain amount of days per week. (ex. paul can work up to 4 days a week and jim can work only sat and fri)
I would like to make a program in access that will take all these factors into consideration. EX. if i try to schedule paul on sm4 the program will not let me do it or it will give a warning or if i try to schedule paul for 5 days it will give me a warning.
It would also be great to have a counter that will show how many days each employee has left to be scheduled for, EX: if i scheduled paul for 2 days it will show that he can actually work 2 days more if i need him to.
I know this might be a lot, but i also know there are so many talented people here so i am sure it is feasible. Please let me know if you know how to do this or if you could guide me through it.
or if you know about a different program that can solve this please let me know
Thanks in advance
View 2 Replies
View Related
Oct 25, 2006
Hi i would like to know if it is possible to schedule a a task in access, at the moment i refresh all my excel report by using a button on a form in access and would like ot know if i can do this automatically
View 7 Replies
View Related
Dec 12, 2005
I have a database that is split. We want to be able to schedule a compact & repair on the back end.
Is there a way within access to schedule a compact and repair?
View 2 Replies
View Related
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
Jul 25, 2013
I am having trouble creating a chart within a report. Let me start off by explaing my report.
I have many unbound textboxes on my report that all have the code very similar to this:
" =Count(IIf([Complaints Table]![Month]=1,IIf([Complaints Table]![Decision - Our Favour? (Y/N)]="Y",0))) "
This basically gives a count of for a specific month. There are twelve rows of text boxes and two columns. There is a query applied to the report to input the year, as this is a yearly report.
What I want to do is link a chart to each and every text box to show the data in an easy to view format. But I can't seem to figure it out, and I've had no luck on the web .
View 1 Replies
View Related
Aug 10, 2005
I am trying to create a database to schedule customer visits. I would like to enter a beginning date and a frequency (IE every week or every two weeks) and then be able to print a schedule by entering a date range. Very similar to how MS Outlook calendar performs. Any suggestions appreciated. Thanks Chad
View 2 Replies
View Related
