+ Reply to Thread
Results 1 to 6 of 6

'Overflow' error

  1. #1
    Registered User
    Join Date
    03-11-2014
    Location
    Coventry
    MS-Off Ver
    Excel 2010
    Posts
    24

    'Overflow' error

    Hi

    I am building a query which has numerous fields. I require one of these to be 'Age at Application', but age is not held anywhere in the tables, there is only app date and birth date. I am trying to get age to appear using

    Please Login or Register  to view this content.
    This works when I use it in a query with only a few fields, but with all the rows/records that will be used in the final query. However when I try to incorporate it into the main query, either directly as a field or via another query, I get the 'overflow' error.

    I've had a look around for some ideas as to what is causing this but everything refers to things which don't seem relevant, especially as the formula works fine for the full data-set when there are simply less fields.

    I hope that makes sense, any help would be great.

    Thanks

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: 'Overflow' error

    Are any field Null?

    Is it an update/insert query?
    If posting code please use code tags, see here.

  3. #3
    Registered User
    Join Date
    03-11-2014
    Location
    Coventry
    MS-Off Ver
    Excel 2010
    Posts
    24

    Re: 'Overflow' error

    Hi Norie,

    Yes some of the records have a blank/null 'birthdate' field.

    It's just a select query.

    Thanks

  4. #4
    Registered User
    Join Date
    03-11-2014
    Location
    Coventry
    MS-Off Ver
    Excel 2010
    Posts
    24

    Re: 'Overflow' error

    I've found a work around which is to simply use a make-table query to do the problem calculation (Age @ App) and then use this table in the subsequent query. This is not ideal at all but hopefully it helps explain the problem a little better....
    Last edited by jamie1985; 08-08-2014 at 04:01 AM.

  5. #5
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: 'Overflow' error

    You could use Iif and Nz to handle the nulls.

    PS What subsequent query are you referring to?

  6. #6
    Registered User
    Join Date
    03-11-2014
    Location
    Coventry
    MS-Off Ver
    Excel 2010
    Posts
    24

    Re: 'Overflow' error

    The subsequent query brings in information from other tables.... By the standards of most people on here I'm not too good with Access, and probably d things in a very inefficient way.

    I've found a work around for the problem. The issue was incorrect dates rather than Nulls so I've just used an If statement in a filter... Again, not sure if this is a good way to fix this but it works.

    Thanks for your help

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] OVerflow 6 error
    By Mortada in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-25-2013, 06:09 PM
  2. Explanation of the Run-time error '6': Overflow Error
    By mgphill in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-25-2012, 10:46 AM
  3. Want to do a while-loop but get error message: run error '6' overflow
    By danzi in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-07-2011, 01:48 PM
  4. Overflow error
    By yjmmay34 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-19-2010, 11:27 AM
  5. [SOLVED] Overflow Error
    By DG in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-15-2005, 01:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1