I'm creating a database for someone that contains a list of employees. Every 6 months they need to randomly select employees to partake in testing. I've read...

I need to take a field that has a full name "First M Last" and split it into three different fields. All names use a space to seperate the first, last, and...

I would like to make a query that would assign a value to yes or no. I am working on a database for church. I basically have to keep up with the points for...

I am trying to build a report from a query, and here is what I want to do: We have a table on our main database that lists production, by date, for our...

I have about 20 fields of Yes/No data type. I would like to do a parameter query where I type in the name of a field, and it will display all the "Yes" of...

I have an Access table built with some relationships. It has an autonumber as Primary Key. I have an Excel file with all (except Primary Key) fields the...

Is it possible to somehow set the input to select top to a variable or at least use some other method to get the same effect. If I could just use something...

Since Access XP wont work with templates from 2000, where do I get templates for my version of Access? Microsoft jumps from 2000 to 2003 with absolutely...

Is It Possible To Generate An Auto-Incrementing Field? You know a field which just counts to the last record. Field Name 1

I am trying to setup a query or queries to pull data from a drop down list. Here is the problem: I have 2 tables that store the data. One table contains...

I have two tables. The first is a masterlist of 25,000 city street names, with correct postcodes. The second table has 1,340 streetnames, but no postcodes. I...

THIS IS THE SAMPLE DATE I want to see supplierID, sum of amount shipped and sum of amount not shipped, and group them by suppier, total no of orders accpted...

Hi, I have a table with fields artefact (text), not_damage (text) but i need to write a query so it can shows me which artefact and also count the number of...

I have a table that I've imported to Access 2002 SP3 from SQL Server 2000, and I cannot get two of the columns to display. I've looked in the design window...

I have set up an mdb for a user - when he uses a single-table query to locate and edit column values in a record, the edits appear to be saved, but, if he...

I'm running an UPDATE query, however, when the filed name has a space in front of a bracket, access deletes the space when the query is saved. For example,...

Is there a way to use a combo box or some sort of coding to select specific fields from a query? I have a query that combines data from 2 tables. Each field...

I am querying 2 tables from different sources and the link is customer account number I want to know how to query what account numbers are missing from one...

Hi, I have 2 tables, "monitor_configurations" & "Sensors" Monitor_configurations has fields :VelocityA, VelocityB, VelocityC all text type storing the...

I created a select query to get different fields from different tables. Two of the fields are Memo fields. Both of the fields are truncated at 255...