• Count distinct rows on multiple columns

    I want to write a single query that counts each distinct Student ID from the following sample data. Sample Data: ID NAME PLAN DESCR --- ------- ---- ------------------- 101 Michael 010C Cafe- 10.00 Dollars 102 Adam 010C Cafe- 10.00 Dollars 102 Adam 05CC Cafe- 5.00 Dollars 103 Jane 010C Cafe- 10.00...

    Mjackson0 pointsBadges:
  • SQL query – Unique item with latest date of entry

    Hey guys, I have been working on the query running against MS access database. The table has multiple columns and two of them (which are vital to this query) are Date and ItemN ( suggesting Item number). There are multiples which show multiple entries for single itemN, for example. item 1 has three...

    SmurkyIS15 pointsBadges:
  • SharePoint 2010 Capabilities

    Using SharePoint 2010 can I create a page with a template of fields that users can fill out (system change requests) and submit generating an email to a dist list? I also want the page to store the request information, so those can check back on status of their system request changes. I have read...

    SarahBeth5 pointsBadges:
  • How to merge all MDB files

    I have more than 100 Access 2003 .MDB files and all the files have same structures and tables. I want to merge all to one MDB file.

    ssddssdd12310 pointsBadges:
  • MS Access 2007

    How we add 26 years in today date and answer will be 19-03-2039?

    78678678678635 pointsBadges:
  • Best way to set up longitudinal database

    Trying to create a database with enrolled student information and want to query students enrolled for a specific semester who then returned for a different semester - but on a larger scale - who were retained 2nd year, 3rd year, 4th year, etc. Trying to have all my semester data in one table and...

    admstr5 pointsBadges:
  • Updates in Access

    Can multiple users make updates in Access simultaneously?

    prakshabpatel5 pointsBadges:
  • Finding a specific record with user input

    I am very new to Access, but have used Approach in the past. When I used Approach, I could create a find in a form, user would be able to enter the find criteria in the blank field. I can not figure out how to do that in Access. Help!

    5boznme10 pointsBadges:
  • AS/400 pass through query from Microsoft Access

    I am trying to build a pass through query in Microsoft Access. I am trying to retrieve data from a file that has multiple file formats. Here is the code I have so far in my pass through query: SELECT h.lhamt1 balance, h.lhnote account FROM bnkprd01.lnp007 h WHERE h.lhtc1 = 33 AND h.lhposj BETWEEN...

    lionbank5 pointsBadges:
  • Questionnaires List

    I managed to received on MDB files that contains various examination questionnaires. I believe that its possible to take and retrieve answers inside from the file itself. Can someone tell me how?

    themondcyte5 pointsBadges:
  • TIME String using Variable H (0 to 23) & M (0 to 59)

    Working on project to convert a Microsoft Access database application to DB2 10.1. This my first with DB2. 1st I tried SQL Script SQL Script: INSERT INTO "IBNserv"."ChkMe"("Clt")>>> [Column Clt Data Type TIME NOT NULL DEFALUT 00:00:00] VALUES CAST('12:14:00' AS TIME) STATUS INSERT INTO...

    Apcalogic50 pointsBadges:
  • If logical function in MS Access

    I have to use IF logical function in MS Access.

    administrat15 pointsBadges:
  • Table setup

    I am creating my first database. It will hold quote, job write up and invoicing information. We currently have two spreadsheets. One Spreadsheet is for quotes. It has the following info: QUOTES Date - Quote # - Customer - Cust Quote # - Part # - Part Name - Quote Due Date - Qty - Lead Time - Price...

    ValleyGirl10 pointsBadges:
  • Cannot find tables

    I am working with a ms access file. When I look at the objects in the access objects window using a category of "object type" I only see one table, when I use the category "Tables and views" I see three tables, these extra two tables are in the dropdown list if you try to create a new relationship....

    Chucky6665 pointsBadges:
  • SQL Group by Query with aggregate function as well as detail information

    Given a simple table with historical info about Hotelroom occupancies such as name of the guest, date in, type of room, number of nights, ... I want to make a query resulting in 1 output record that shows the highest number of nights someone has ever stayed in the hotel, as well as the...

    idontknowthis20 pointsBadges:
  • access query criteria using LIKE operator and msgbox if no results

    I am using Access 2010. My query criteria looks like this: Like [ENTER THE FIRST LETTER OF THE SUBJECT] & "*"......so the user clicks the button and a box pops up with the above question. If the user types in a letter and there are no subjects that start with that letter it just opens a blank...

    draia10 pointsBadges:
  • editing in grid forms

    How do I add,edit,delete in gridforms with Microsoft Access?

    vidyam5 pointsBadges:
  • Report design Access 2010 / 2007

    I do not know how to design a report that will display the data the way I need. It is hard to describe here, but I will try with a simple example. Each record is based on a date. On each date there are entries to 0-200 accounts for various $$ amounts. IE: on 1/1/12. acct 120100 for $5, acct 120202...

    gc4evr5 pointsBadges:
  • Find a string in text file using MS Access

    I would like to read a multi-row text file, from inside MS Access, search for a string and returns all its occurences. Sample file: ------------ Patch 123456 : applied on Wed Jun 27 15:42:09 CEST 2009 Created on 23 Mar 2009, 00:48:16 hrs PST8PDT ... Patch 654321 : applied on Wed Jun 25 15:41:56...

    masrawi20105 pointsBadges:
  • ms acess trouble

    i am having trouble with my vb programs. I have several vb programs that make data reports from access datatables. All of a sudden my datareports will not update until i close my program and reopen it. Any help would be greatly appreciated.

    Dmattin25 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

Thanks! We'll email you when relevant content is added and updated.

Following