• Using Access query data in Excel

    I have a need to use some employee data that is contained in an Access database in a dashboard like application in Excel. I have tried several attempts at getting this data but have not had any success. I can move the entire file, but I really need to move only the data that meets some selection...

    Ronmcnaughton5 pointsBadges:
  • SQL Query to return a single value for each record based on max FIELD, not max record

    I have a table with 12 date columns per record (D1 thru D12) and I want to select from each record, the max date of those columns (not the max of the records).  I know: select max(D1) from table1 will yield max of D1, but say I want D3 from record1, D1 from record2, etc (using the following...

    Schlingel0015 pointsBadges:
  • Relational Database

    What kind of tables are used in a membership database other than name & address.

    4jab15 pointsBadges:
  • Importing from an Excel worksheet to Access form

    I have set up my database in access including the form that I want to import my information into, however when I try to import from an excel worksheet into access, it changes all my field names to field 1,2,3 etc. Then when I look at the form page all my sections have the word #NAME? in them. How...

    Horses5 pointsBadges:
  • How do I run Excel Reports?

    Is is possible to run reports similar to how you run reports in Access in Excel 2007? If so, how?

    Lysprice5 pointsBadges:
  • Conversion from FileMaker Pro to Microsoft Access database

    How do you convert FileMaker Pro 7 database to an Access 2007 database file?

    Ccardona5 pointsBadges:
  • Access 2007 IIF statement in query criteria

    This is a query design looking at a checkbox on a form, if its checked, I would like to return only the database fields (ConfigData) that contain text. If it isn't checked, return all the fields whether they have text or not...Pretty basic filter I thought. It seems like I'm getting close but can't...

    Scubacy25 pointsBadges:
  • Connect DB2 from MS-Excel

    Hi all! I'm trying to connect the AS/400 DB2 from MS-Excel but I'm Getting Communication link failure .comm rc=10061 - CWBO1049 - The IBM i server application is not started or the connection was blocked by a firewall. I have tried STRTCPSVR *ALL STRHOSTSVR *ALL and PING from PC to SERVER is ok....

    Sureyz2,475 pointsBadges:
  • Combo box automation

    How do I get a combo box to take on a value automatically?

    depatterson015 pointsBadges:
  • Left justifying in a query

    The numeric field in my table is left justified and works fine but any queries I use with that field end up being right justified. Is there a simple fix for this.

    posker5 pointsBadges:
  • Zero fill numbers

    I have an address field with a 6 digit zero fill street address. eg, 1032 is 001032. I need to eliminate only the leading zeros.

    timmyd5 pointsBadges:
  • Access database 10 date change

    I want to change a date by 20 days each time a new date is entered. I'm using Access Database 10. I have an input date that I want to increase by 20 days and show that new date each time an input date is generated..

    HELPTECH10 pointsBadges:
  • 24 hr clock in Microsoft Access

    Microsoft Access allows you to open your table in datasheet view, select FIELDS from TABLE TOOLS and select from the drop down MORE FIELDS and then select TIME 24 so you can use military time. Problem is when you attempt to type in military time, it shows a calendar on the side and only allows you...

    MANDONA135 pointsBadges:
  • Trouble creating SQL statement from MS Access Form

    I'm creating an INSERT statement from the text fields in a form. This is a snippet: mySQL = mySQL & Combo0 & "','" & Text3 & "','" & Text5 & "','" & Text7 I am alternating the double and single quotation marks to enclose the entire statement as a single STRING while...

    MarcC5 pointsBadges:
  • MS Access database

    I have a MS Access database with records that I have uploaded to Windows Server. I wish to have an user open the records on their local machine and be able to add/edit records on the remote server. What is the simplest way to accomplish this? I have also created a data access page. It seems that...

    Mgregory0 pointsBadges:
  • MS Access 2007, IIF and Null expressions

    Ok what I want to do is very simple but nothing I have found is helping me. I have a field that sometimes contains a value and but most of the time it is empty. What I want to do is write an expression that says if there is something in this field, then “25”. I believe that I should be using...

    Phil12550120 pointsBadges:
  • 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:

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.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

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

Following