I'm sure there's a simple answer to this question. I'm new to Access. I have 2 tables, each with a column titled "Company Name." I would like to use a query...

My query either returns 1.5 million records or it wont run due to the following error. "The SQL statement could not be executed due to an ambiguous...

Hi. I have a sql query that does what I want it to do- gives me, based on contact, the count of animals associate with the contact, and the count of how many...

Good Day all, I have a qry that I use to track my inventory, and for each inventory item there is a field called colours. Which can contain anywhere from 1 to...

Hi, I'm having trouble getting a COUNT() on many fields in a table. I have a table that records the number of times a Student was absent or late on a given...

I am using unbound form fields to create a filter in a query to view it on a continuous form. Works great with : Forms!! Or Forms!! Is Null But now I would...

I have a table of dates and events. I would like to know how to make a query that filters to display on any given day, only records whose events are scheduled...

Hi again, I am starting a new thread because the query turned out to be wrong. Now i am getting the "data mismatch" error on the following...

I am trying to count a sorted number field in a query. For each identical number I want the count to increment by one. For example Number Count 183 ...

The situation is as follows: I created a table that is called "ST-1", it has 14 fields total, 12 of them labeled after every month of the year, 1 labeled...

I’m having an extremely large amount of trouble with a query. My trouble begins when I try to do a query based on the ‘date of research’ field contained in...

I need for access to open my input form as a new record, however if I have the form pulling information off of a query vs a table is keeps giving me an error...

Could some please help me to format the output from my query to my document. I need the output to be in this format $1,111.00 In the table design, I chose this...

I have two tables - Master & Import. They both have the same fields and structure. I would like to update the Master table with the information within...

I am making a system to show why employees are leaving a company, based on a five-point system. 1 being an important reason, 5 being unimportant. At...

I have a query which I would like to display the 10 quickest swimmers. How can I limit the query to show only 10 records. Secondly, 1 swimmer may have many...

I have a table that has records as: ref colour 000001 blu blk gre yel but I am looking to split it so: ref colour 000001 blu 000001...

I have two tables in a data base - New Customer and Old Customer The key relationship fields in each table is the Customer Number The New Customer number in...

Hi. I have a query that sums "Bucks" for each Contact. It works fine. Some Contacts have Spouses that are also Contacts. In these "family" situations I want...

I need to have a field to generate the report number with the following format:- The first part consists of four digits for each year. It could be...