Need a report or query(?)

I have a table of class information that contains class name, start date, 
instructor, start time and days held - the days held (if more than one day) 
repeat in separate records.

I need to end up with one record per class that shows class name, 
instructor, start date and the days and times held. (Also in the mix is that 
times held can be different each day held.)

Where do I start? A query? Two queries?

I started by creating a table and grouping on class name so I have a table 
with non-dup class names...now, I am dead in the water!

Thanks in advance!
0
Utf
5/18/2010 3:45:01 PM
access 16762 articles. 3 followers. Follow

1 Replies
699 Views

Similar Articles

[PageSpeed] 38

On Tue, 18 May 2010 08:45:01 -0700, PeggyG <PeggyG@discussions.microsoft.com>
wrote:

>I have a table of class information that contains class name, start date, 
>instructor, start time and days held - the days held (if more than one day) 
>repeat in separate records.
>
>I need to end up with one record per class that shows class name, 
>instructor, start date and the days and times held. (Also in the mix is that 
>times held can be different each day held.)
>
>Where do I start? A query? Two queries?
>
>I started by creating a table and grouping on class name so I have a table 
>with non-dup class names...now, I am dead in the water!
>
>Thanks in advance!

Tables store data.

Queries (based on tables) select, combine, and arrange data.

Reports (based on queries) print data.

You need all three, but you certainly do not want to create a new table just
for this information. You would create a Query based on the table of class
information, and base a Report on that query, I would guess; you can use the
Report's Sorting and Grouping feature to let you put class name and instructor
and so on in a Header and the details of individual class sessions in a Detail
section.
-- 

             John W. Vinson [MVP]
0
John
5/18/2010 4:54:40 PM
Reply:

Similar Artilces:

Field names in an append query
I am attempting to append one table with another. I have several fields whose names are in the form of xxx - yyyy, aaaa - bb, etc. There is a space on either side of the hyphen. One of the fields, named "name - last" (no quotes) is not being recognized, for a reason I can not understand. Therefore the query will not run. I have tripled checked that the names are in fact exactly duplicated in each table and that the properties are likewise duplicated. I am at loss to determine what the problem might be????? Thanks Paul Are you doing this from the QBE grid in design m...

Windows Terminal Server 2008 / non-clients need to access internet
I have a terminal server environment. I have access points all over the school. I would like visitors to be able to access the internet but in order to get on you have to open a session. How do I get it shared to non-client pcs? -- rubantin ------------------------------------------------------------------------ rubantin's Profile: http://forums.techarena.in/members/190718.htm View this thread: http://forums.techarena.in/windows-server-help/1311934.htm http://forums.techarena.in Hello rubantin, "How do I get it shared to non-client pcs?" Do you mean with ...

Need a report or query(?)
I have a table of class information that contains class name, start date, instructor, start time and days held - the days held (if more than one day) repeat in separate records. I need to end up with one record per class that shows class name, instructor, start date and the days and times held. (Also in the mix is that times held can be different each day held.) Where do I start? A query? Two queries? I started by creating a table and grouping on class name so I have a table with non-dup class names...now, I am dead in the water! Thanks in advance! On Tue, 18 May 2010 0...

excel pivot table with sql query and visual basic macros
I have a pivot table that runs off a sql query, it has macros and parameters built into the report. It worked until the client updated their server and db software. When debugging this, on the module under the closedb it stops here: Sub CloseDB() 'IF CONNECTION IS OPEN IT NEEDS TO BE CLOSED SO AN ERROR IS NOT THROWN If rsData.State = 1 Then rsData.Close Set rsData = Nothing End If cnData.Close Set cnData = Nothing Set Cmd = Nothing End Sub Thanks ...

Top Sales days top z report days report
Does anyone know how to find my top sales dates/ days with highest sales /highest z reports ? Does any one know how to find those in RMS? Is there a custom report for this ? Thanks Robert Robert: Do you want to look at your past journals/Z reports and print a new report in descending order by sales showing dates? Over what period of time: last month, quarter, year...? Aloha, Miles miles@pacificcomp.biz Pacific Computer Systems Miles Baidack Supporting Business Since 1985 Phone: (808)395-8156 or (808)277-8156 "Robert" wrote: > Does anyone know how to find my top sale...

Quote reports
Hi, I have gone thru 3 months of this newsgroups and i can not find one definate answer on how or if it is possible to change the layout of how the form prints out and the content within the printed report. I do not see where in crystal it is generated is it possible to create a custom layout or report? Any help is REALLY appreciated Dan Dan you need to load crystal reports 8.5 on a machine other than the crm servers. You then load up the crystal addon for CRM on top of your crystal reports install. Once you have this you can get crystal reports to open a report from the crm server t...

Report Header Question
Hi, hope someone can help me with a problem I've run into whilecreating a report.I have a report where I must use three different Headers to obtain theinformation I need (Downtime, ProductNumber, and CustomerLotNumber).The information is in three headers, but in different locations ineach header (which if combined, could be in a straight line). Theclient wants totals for the information pertaining to Downtime,ProductNumber, and CustomerLotNumber, but he doesn't want them bydetail. The only way I could think to accomplish this was to createseparate Headers which would give the informa...

Need to build a MS Dynamics GP Test Server
Hi, I need to build a MS Dynamics GP Test Server. The plan was to install SQL Server 2005 and Dynamics GP 10 on a server, then copy and attach two production databases. I've done that, but the users IDs are invalid. The user ID can't be deleted because GP says the IDs are not in the Database. I found an alternative in the article "How to transfer an existing Microsoft Dynamics GP, Microsoft Small Business Financials, or Microsoft Small Business Manager installation to a new server that is running Microsoft SQL Server" but a crucial script is unavailable. If anyone has ...

Modifying and creating custom reports
Hi all, I just started working on custom reports for CRM. I followed a useful post here and set up Visual Studio to view the CRM original reports. I am a little lost on how to start so if anyone could answer me these questions, it would help: - Am I supposed to use Visual Studio to edit reports and create new ones? Or maybe Crystal? - Can I customize the filter? How about those Include/Exclude drop- down boxes--can I default them? - Where should I setup the connection? Do I use Windows or MS SQL authentification? Any starter help or link would be appreciated. Thank you. Mohamed Hi: Visua...

Using a dll to generate report data
Hi All I am assessing whether we should move to reporting services to make available various company reports via the web. While most reports have a stored procedure origin for their data, there are a few of our reports that require some programatic massaging. These reports typically involve some specialised data pivoting and/or formatting. My question is, can reporting services utilise a custom dll as the source of data for a report? As an example, reporting services can generate a report from a stored procedure via a select statement. Can reporting services build a rep...

"Spending by category report"
Hey everyone, I am using Money 2004 Small Business and when I goto "Personal Reports | Income & Expenses | Spending By Category" and I try to "Customize..." the report there is 1 "Asset" account missing from the list! I have a loan account setup and I have the interest set to "Business | Interest Income"... unfortunately this income doesn't show in this list. Even when I pick the "Interest Income" category! It appears the problem is that the account in question is my list of "Accounts". I can't for the life of m...

Run SSRS stored procedure report from a CRM 2011 for a current record
Hi All, we need to run a SSRS report created via stored procedure for the current record in a custom CRM entity . we completed creating stored procedure , but pre-filtering is not working . when we tried to preview in visual studio it is picking up the lastest record values only . Could any one give some suggestion to resolve this issue ? Thanks, Sandy ...

Varying page Excel report
I have an Excel template in which I import data that is of varying records. Sometimes there are 3 records, sometimes there are 50 or 200 records. I do not know how to make a varying page Excel report. (For example, my clients sometimes want to see data on top 3 occupations, sometimes on top 50 occupations.) (The template is formatted, has headers, footers, a few links, works fine.) Using Excel 2002. Hi Judy- Perhaps I'm missing something, but there should not be any need for adjustment. The number of pages will be based on the number of records being printed as long as you have ...

I need elegance.....
I'm stumped and asking for elegance here.... I have a table that doesn't scale in a linear fashion (it is for use with computing the langolier pool water index) when I check the water I get a test result to compare to my table, and I then take the result from the other side for further computation 32 0 37 0.1 46 0.2 53 0.3 60 0.4 66 0.5 76 0.6 84 0.7 94 0.8 105 0.9 what I want is for a test result like 35- I'd like to get a formula response that is .06 so I'd like a formula that finds which two table numbers it...

Query Q
Im tring to categorise some records based on a rule which says; we have a 2 hour grace period, then every thing is categorised different. we have a bunch of duration values, ie 2hr, .25hr, 1 hr, whatever. If the event is over 2 hours- then it is category 2. if we have 1.5hr first, then we have .5hr left of grace- anything longer will be cat2. ie, this is what i want the query to return.... ..5hr -grace period (first .5hr grace used) 3hrs - cat2 1hr -grace period (now total grace is 1.5hrs) 2hrs -cat2 1hr - cat2 (because now we have only .5hr grace left) ..5hr -grace (now all 2hrs grace is ...

Microsoft Excel has encountered a problem and needs to close. We are sorry for the inconvenience.
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Hi, <br><br>I am using a MacBook Pro with OS X version 10.5.8, and Excel 2008 version 12.2.4. <br><br>A colleague emailed me an excel file (.xlsx) from a PC, and when I try to open it, excel crashes and the following dialogue box opens &quot;Microsoft Excel has encountered a problem and needs to close. We are sorry for the inconvenience.&quot; <br><br>Below is the error log. I hope you can help. <br><br>Thank you for your time. <br><br>Microsoft Err...

List box (and queries) not sorting dates or showing correct headers
G'day all, I have inherited a system with a search function screen that is acting weird. There are actually two search screens, both constructed in a similar fashion, but the first does what it is supposed to do and the second is misbehaving. The form has a bunch of unbound controls allowing the user to enter search criteria. The only mandatory criteria is the sort order, which is set from a combo box. The data source for the combo box is a table, sys_GAPSSortBy, which contains a list of query names and a user- friendly label for use by the combo box. When the user clicks the "Searc...

Formula help needed #4
Hi, I am very new with excel. If I have several fields, each of which records the number of a particular item - Say Field A (item 1), Field B (item 2), Field C (item 3). When I create a report, I can see how to get the total of items in each individual field. However, I cannot work out how to add together the totals of Field A, Field B, and Field C to get a total of all items. I imagine that this involves inserting a formula somewhere, but I cannot work out how to do this. Can anyone help? if you're very new with excel.. PLEASE i beg of you-- run away while you still can Excel is...

Creating a Report from Landed Cost
Hello Great Plains Gurus! I am attempting to create a custom report in RS2005 to show estimated landed cost VS actual landed costs as well as if the landed costs for each shipment, and I am having a hard time understanding the data structure in order to join the receipt tables together. Basically all I need to get started is a query/or generally how to relate actual Receipt Numbers for landed cost invoices to the Receipt Number of the original shipment. IE I have RCT00216 that is the actual shipment receipt and RCT00220 that is a Landed cost that I am applying to the shipment receipt. I wo...

need help using a checkbox to determine if a cell gets summed
need help using a checkbox to determine if a cell gets summed. i have designed a worksheet with items in one column, and how much the item is in another column. what i want to do is to check a box next to an item and have the cost of that item added to the other items that are checked. if the item is unchecked, then resum the items that are checked. i would also like to add an additional check box that will automatically check or uncheck all of the other checkboxes. any help will be appreciated. I put my items in B2:B20 and the costs in c2:c20. Then I ran this macro to add the che...

data in queries
Hi! From a dataset I retrieve customer names and the products they have purchased: client name product name client 1 product a client 1 product b client 1 product c client 2 product b client 2 product d client 3 product a client 3 product e No problem. But how can I avoid the repetitions in the ClientName column: client name product name client 1 product a product b product c client 2 product b product d client 3 product a product e In Query View. I think in a Report this is done through Group By? Thanks ...

Budget report #2
I have income that is retirement income. The category assigned is recognized by the monthly reports and they correctly show this as income. My problem is the budget report. It will not identify and show this category as income despite a lot of trying. How do I get this to pick up on the budget report? The frustrating thing is that it shows in the monthly reports. I have checked and I show this category in my budget definition. Ideas or help? ...

Report With Tax Sales ...
Hi Can anyone help me to make a report with like ammount of non-taxable sales , and taxable sales, so I can make my accountant happy ?:) Thanks ... Try the detailed sales report. "Ashot" <Ashot@discussions.microsoft.com> wrote in message news:630AF90D-F4BC-4FB8-B90D-909A4F27FCEF@microsoft.com... > Hi > Can anyone help me to make a report with like ammount of non-taxable sales > , > and taxable sales, so I can make my accountant happy ?:) > Thanks ... > Use ths "Sales Tax Anylasis" Report this will give you both Taxable and non-taxable ...

log of printed reports
I have a set of reports that I print on a regular basis. I need to be able to keep a track of the date and time at which each report was printed in a table of query so if it goes missing, i have a record of whether and when it was printed. I have been unable to come up with a way in which i could generate this automatically. I would be thankful if i could be helped with this. Thankyou, Radhika Create a table with columns ReportName and PrintedDate. Let's assume you name the table ReportLog In the Close event of each report, put code like: Dim strSQL As String If MsgBox("Did...

Report/Subreport Help please
I have a main report and subreport. Within subreport there are 5 subreports. When I printview my main report the main report is addressed to one doc and subreport lists pts. Pts can be one or more than one with different reasons. The subreport report is a report that has in the subreports different references for the reasons. I only need to have this part of the report just be listed once even though there are several pts with the type of reason. How do I get the sub report to only only once the reason type. Thank you ...