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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.