Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: timbar
  • Content: Threads
  • Order by date
  1. timbar

    Filtering records in large tables

    I have a large table of x,y,z coordinate values. The table contains over a million records. Is there a convenient way to select and retain only a certain, lesser number of records using a query? I'd like to select, say, every fourth record and retain that record, and discard the others...
  2. timbar

    Combining the data in three table fields

    I have a table that has 3 columns. I'd like to be able to combine the data included in the 3 columns into one of those columns, or create a fouth field with the combined data. An example would be to combine address information stored in three fields into one field. Although this is not my...
  3. timbar

    Runnig a series of make-table queries

    I have many make-table queries that I run one after the other. These queries simply extract a subset of records from a larger source table. I'd like to automate the process, so that I don't have to run each query one at a time, using a macro (I assume) to initiate and run all the queries that...
  4. timbar

    Counting records in a table (DCount)

    I'd like to extract records from a table using a query. I think that I need to use a query criterion built with the expression builder. In particular, I have a table that contains 1577 records. What I want to do is use a Make-Table Query with a criterion that pulls out the first 256 records...
  5. timbar

    Grouping tables (and queries) in a single database

    I have many tables and queries (hundreds) in a single database (all using the same source data). Is there a way to group the tables and queries within the database (like in a file - folder system)? I currently use naming conventions that allow me to keep track of the tables and queries (i.e...
  6. timbar

    Can the results of a query be used to create a new table?

    I've found this forum to be very useful in just the past few days. My first simple question was answered very professionally. I have another simple question. I am not familiar with Access programming. However, I have a fair amount of experience building Access queries, including some that use...
  7. timbar

    Data Entry - REPEATING VALUES in a field (record to record)

    I have a simple question. It probably has a simple answer. In entering data into a Access table, how do I repeat a value (a number) in a field from record to record, without having to type the value in for each record? Is there a non-programming function in Access? Or, do I have to write a...

Part and Inventory Search

Back
Top