User Profile

Collapse

Profile Sidebar

Collapse
NatronA111
NatronA111
Last Activity: Oct 11 '07, 07:31 PM
Joined: Oct 5 '07
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • NatronA111
    replied to Limitations of Access
    in Access
    Thanks for the help, Linq!
    See more | Go to post

      Leave a comment:

    • NatronA111
      started a topic Limitations of Access
      in Access

      Limitations of Access

      Hello all...

      I'm sure this has been answered before, but I was searching through the threads and can't find an answer...

      What are the record limitations of Access?

      I want to import 10,000 records at a time into a table and run a query on it that has numerous calculated fields. Think this will be okay?

      I just want to make sure that I don't start something I can't finish!

      Thanks......
      See more | Go to post
      • NatronA111
        replied to Help w/ Calculated Fields
        in Access
        Thanks...you rock! Taking the quotes out worked......
        See more | Go to post

          Leave a comment:

        • NatronA111
          started a topic Help w/ Calculated Fields
          in Access

          Help w/ Calculated Fields

          I am having a problem with calculated fields (...the most important one in the database!) in an MS Access query that pulls info from one table and a few other calculated fields stored in other queries.

          [ExpectedPmt] simply adds the values of several fields for each record:

          ExpectedPmt: CLng([InterceptScore]+[StateScore]+[EmploymentScore]+
          [HomePhoneScore]+[WorkPhoneScore]+[BirthdateScore]+[GenderScore]+
          ...
          See more | Go to post
          Last edited by nico5038; Oct 6 '07, 07:38 PM. Reason: Splitted the long "+" line to suppress the horizontal scroll
          No activity results to display
          Show More
          Working...