Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: kuau
  • Order by date
  1. kuau

    Query Complexity

    Month: Format([PayDate],"yyyy/mm") produces: 2006/01 32 2006/02 85 2006/03 67 This will give you the totals you want in the query and then you use the query as the data source for a report where you can format the dates to display as January, February etc. Group by section as well and it...
  2. kuau

    Query Complexity

    Dear Kyle: Not exactly sure what you mean, but I did a monthly total select query by grouping on the date column [PayDate] using this as the definition of the date field: Month: Format([PayDate],"yyyy/mm") then using "Sum" on the amount columns. Hope this helps. kuau
  3. kuau

    Need Help Moving a MS Access 2002 Database to WinServer 2003

    They will be editing (one location will be adding items to inventory, another selling those items). [thanks for your willingness to help!]
  4. kuau

    Need Help Moving a MS Access 2002 Database to WinServer 2003

    I was advised to submit my question to this forum: I am new to Tek-Tips and new to a managed hosting Windows Server 2003. The managed hosting tech support is useless and I know zero about what is the best way to set things up. All I need is to allow 5 people access to one MS Access 2002...
  5. kuau

    Need help setting up new Win2003 Server please

    I am new to the forum and new to a managed hosting Windows Server 2003. The managed hosting tech support is useless and I know zero about what is the best way to set things up. All I need is to allow 5 people access to one MS Access 2002 database on the server. I was hoping to control what...

Part and Inventory Search

Back
Top