• ODBC on Linux

    A user on Twitter, @garyvee, has a question for the community: Whats the best solution for ODBC on Linux ? And is anyone actively working with it? The direct link to his question is here.

    JennyMack4,280 pointsBadges:
  • Monthly Average in Access 2007

    Dear All, I need to calculate the monthly average on an array of data the gets added to weekly. Therefore, from Jan to March, the total is divided by 3. Come April, the total should be divided by 4, and so forth. Please, no VB code if possible - my VB sucks Thanks Riaan

    Riaane65 pointsBadges:
  • Biometric based secuity system

    I'm looking for information based on experience that anyone might have with the various technologies used for Biometric time clocks. In particular, the reliability of Retina scans vs Finger print vs Facial Recognition. I've installed a low end system from WASP that works well enough for the company...

    Flame14,925 pointsBadges:
  • join logical files

    Hi, Can i join one physical file's 2nd member to another physical file's 5th member? Is it possible? If so how? can anybody help me out?...thanks

    ten20081,150 pointsBadges:
  • Changing field format in Access 2003

    We have an Access data base that includes date of birth in the format mm/dd/yyyy. For reasons I don't need to go into now, we have to change all of them to a different format - yyyymmdd. Is there a way of doing this without changing every individual record? This would save us hours of work. Thanks

    Britinga425 pointsBadges:
  • Access/Word Mail Merge Currency lost digits

    I made a Donations database which merges with a Word document that provides a receipt. The data that comes over drops zeros after the decimal. Ex: $700.00 appears as $700 ...Even worse $700.60 appears as 700.6 How do I get the decimals to show?

    OBI Girl85 pointsBadges:
  • Permissions for writing stored procedures in MySQL

    Hi Friends, I have been using navicat to connect MySql5.0 in my local evironment.I connect my java project to MySql database as backend. Now my problem is, I generated an sql script to backup my local database. I run the script in server. Tables were created. But in the case of stored procedure, I...

    Ktrramu5 pointsBadges:
  • Need help with Oracle query

    how to display the third highest salary from an employees table thanks in advance

    Xaviervicky30 pointsBadges:
  • Vertical text in MS Access 2003 report

    I'm trying to create report headings that are perpendicular to the data fields. I have lots of fields with numbers and the headings fit on the page if they print at a 90 angle -- on a slant would be nice too. When I make a label (or text box) and change the properties to 'Vertical = yes' the words...

    Carey5 pointsBadges:
  • journalling a file

    Is journalling a must for commitment control of a file on AS/400

    ten20081,150 pointsBadges:
  • Pivot table error when sourcing data from Access

    Pivot table error when sourcing data from Access reads: Invalid bracketing of name 'mdb.'.

    LittleKro5 pointsBadges:
  • Oracle – Deleting a row from a complex view

    why we can delete a row from a complex view if it does not contains group by clause,group functions,distinct keywords,pseudocolumn

    Avej10 pointsBadges:
  • Linked Server Question

    I am trying to link an existing Access 2003 password protected database to a newly installed SQL Server 2005 Express database engine. I am using the ‘Add Linked Server Access MDB’ template in Management Studio to create the linked server. The linked server is created without error, however when...

    AN5gel675 pointsBadges:
  • rolling average VBA code MS Access

    Hi All Anyone know how to create a VBA function and or SQL statement which will work in Access to find the rolling average as per example below + see excel file for working example in excel. Should work for a unknown amount of records. Not an easy one I think :-). If it can be done without using...

    Astakeil35 pointsBadges:
  • Unable to use delete statement in SQLRPG

    Hi I want to use this query delete from abc a where rrn(a) between 1 and 10 in an sqlrpg prog.I was getting error messages saying rrn keyword not allowed.Am not sure how to execute this in an embeddd sql program.

    0 pointsBadges:
  • Sum of Donations for current year

    I have a query that sums donations and groups them by year. When I print receipts, it gives me two receipts -- one for year-to-date donations for 2009, and another that includes 2008 and 2009 donations. How do I get just the one receipt to print?

    RonleeG5 pointsBadges:
  • Date insert problem into Access from .NET

    I have a procedure that inserts a record including a date into an Access database. If the dd portion of the date can equate to a month then the dd and mm parts of the date are switched otherwise the date remains as is. eg 12/11/2007 is being stored as 11/12/2007 but 13/12/2007 is stored as...

    RobOfTage5 pointsBadges:
  • can you help on this query?

    I am new to sql and cannot work out the query for this: >>>List the films in which 'Harrison Ford' has appeared <<< movie(id, title, yr, score, votes, director) actor(id, name) casting(movieid, actorid, ord) The whole exercises can be found on http://sqlzoo.net/3.htm thanks in...

    Cateye5 pointsBadges:
  • Problem MS Queries Refresh in excel file located on client network

    I am having a problem refreshing the Ms Queries in an excel file located on client network, when connected through vpn. It is showing an error window such as "ODBC Microsoft Access Driver Login Failed" Disk or network error.

    Pavin5 pointsBadges:
  • CPYTOIMPF and EXCEL defaults

    I have an issue when copying an AS400 file to the IFS. One field that is defined as 15 charachter and contains numeric data does not show up in .csv format correctly without reformatting the column to special. I also tried defining the field as numeric, and had the same result. Example of data...

    Sbarnes5 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