How do i group fiels in access 2000 report?
404668
In Report Design right-mouse click on the detail section and select "Sorting and Grouping" ... you can select the desired field and set the properties for the group and / or sort.
353682
Go to Options in your right hand corner and then click on Accout information on your left.  This is in Yahoo format.
495673
sure u have \nand try crystal reports\n\ni dont have to tell u the steps .. cause i dont remember really .. but try with msdn
74561
It's hard to tell exactly what you are asking, but it sound like what you are looking for is:\nSELECT Categories.field1, Categories.field2, ...SubCategories.field1, SubCategories.field2, ...\nFROM Categories INNER JOIN subCategories ON Categories .catID = SubCategories.catID\nORDER BY Categories.catID;\n\nWhen you walk through the recordset, you keep track of PreviousCatID. When the Categories.catID doesn't match the PreviousCatID, you print the Category data items before the subcategories and update the PreviousCatID. If CategoryID hasn't changed, you just print the subcategory items.
394506
Use the import data wizard in access. Make sure your Excel sheet has data in a contiguous range with a column label in the first row.
637006
SELECT MAX(Sno), Name FROM Temp GROUP BY Name \n\nyou have to include the GROUP BY clause when using any of the group functions (MAX(), MIN(), SUM(), etc) so the database knows how to relate the data in the other columns to determine the groups.
895660
you just for a appending of the datas ...\nThe dept name should be taken the add the last two didits of year then add the numbering... have each in seperate column and append them
638202
These should all work out correctly provided that\n\n1. dept is a proper field name\n2. salary is a proper field name that has a numeric format to it (i.e. number, currency, etc.) - you cannot take an average of text fields\n3. emp is a proper table name\n4. empid is a proper field name - it won't matter if there aren't duplicate empid's, the query will return results as if the GROUP BY statement weren't there if that's the case\n\nThe semicolon is optional in some database programs - in Access, you don't need a semicolon to separate SQL statements.
861985
********************************************\n\nI have Office 2000, so these instructions may or may not be the same for your version.\nThe easiest way for me is to first know how many rows and columns I need. Then I right click and hold the button down while moving the mouse over the rows and columns I want included in the table. For example: If i want a table that is 4 columns wide, I would select A through D. Then, while still holding the right click down, I select the rows that I want. If I want 10 rows down, I select 1 through 10. After they are all selected in blue, I release the right button on the mouse. The rows and columns selected should remain highlighted.\n\nNext at the top of the page there should be a grid of squares button to select. If there isn't, you can find the little arrows button to find more buttons. It will be in there. Click it or the little arrow pointing down beside it for more selections. This will give you a grid and different types of line thicknesses.\n\nIf you can't find it this way, then after highlighting the areas you want included, right click again in the middle of a highlighted square and another window will open. Click 'Format Cells' in the box that opens. Next click the 'Border' tab. Then choose the formatting you want. You can do this more than once to get more than one effect on your table.\n\nIf none of this is what you want to do, then go to Microsoft Templates at this link: http://office.microsoft.com/en-us/templates/default.aspx\nThere are as many templates there as there are hours that you have to look through them. You can do a search for the specific type of table you want. After you download the template (these are small files) you can customize it how you want it after you open it.\n\nHope this helps. Good luck.\n\n****************************************************
128703
Just go to http://groups.yahoo.com/\nIt's pretty easy to do step-by-step.\nHowever, if this is a professional organization, you may try looking into other services first.
1013881
Look at other procedures within your office. Surely they follow some sort of template.\n\nI suggest doing that. Look at the other procedures and copy the format.
615208
SELECT fromusername, tousername\nFROM table\nGROUP BY tousername, fromusername\nHAVING fromusername = 'name of user'\nAND status = 'open'\n\nAssuming you have a column, named status, that indicates which conversations are active. That will bring in only the unique pairs you describe.\n\nAs described earlier, you could also use DISTINCT:\n\nSELECT DISTINCT tousername, fromusername\nFROM table\nWHERE fromusername = 'name of user'\nAND status = 'open'\n\nThe GROUP BY statement is computationally more efficient, but unless you are dealing with millions of records and thousands of concurrent requests, you shouldn't see a difference in performance.
26959
I'd copy the emails from each sheet & do a vlookup to each set. Delete the ones that are matched & then do a vlookup to the original sheets to bring ini the rest of the details.\nI'd take them into Access tho if you can. You could link the sheets to a data base & export the query results back to Excel.
242294
You can find their organizational charts in their annual reports, such as this one: http://www.searsarchives.com/history/annual_reports/2000annualreport.pdf
292988
Depends on the file that needs to be imported, and how you need to import it.  Enterprise manger comes with an import wizard that you can use to import information.  sometimes it's easier to just import the whole thing and delete what you don't need/want.\n\nanother way would be to make the file into a CVS and import that into access, then by using a linked table, export the table to SQL.
233468
I've uploaded a simple spreadsheet to the link below.  Anything else and you should probably find someone in the office who knows Excel.
207831
yahoo answers\nmyspace\nmyspace groups