Hello I am running data extracts from a multisite inventory table, using the criteria on a "make table" . Is there a way that criteria can be used to name...

I am trying to run an append query using a macro and the, Open Query command .. The Query is using information from a form to select the appropriate records to...

I need your help please. I need to create a query that will allow me to compare a students score from multiple scores of one test and identify which is the...

I am running Access 2003. I imported an old excel spreadsheet into a single table in Access. I need to append data into two related tables as...

I am running Access 2003. I imported an old excel spreadsheet into a single table in Access. I need to append data into two related tables as...

Hello! I am a novice writer of Access Queries and I'm having trouble figuring out how to do what I want with one query instead of three. Actually, this will...

I have data like following: Student ID Grade CLASSS Level 1 PASS PIANO A 1 ...

I have a database of historical recipes with a subdatasheet listing every ingredient for each recipe title. I want to produce a query that will return all...

Hello, I have a database of test scores, where I need to figure out averages. However, the test is administered in several ways - computer, paper,...

Although the article below claims that Access 2000 boasts the REPLACE function, it isn't recognized when I try to use it in queries (pity this wasn't made...

Hello all, i would like to show all records printed between two dates. My date format is 01/01/07. The table which i am using has this format My first column...

I have a database that contains several fields that are checkboxes (i.e., Yes/No data types). Using Create Query Design, I know how to easily create a...

I want to calculate totals for Phases from rows that contain multiple Phases. Table is similar to this: Fields:Phase total_usage A ...

I am not a strong access user, but have trying to learn it by writing a scoring program for a Scout event at the end of May. I have created a table for...

I need to submitt a report weekly the lists my project time for the week. I have a form in Access 2003 that I use to input all my daily activities into...

I want to compare todays opening price with yesterdays opening price for 3 stock exchanges with an open price of = $5.00. First pass query I get all the...

Hello - I have a form that sets the default value of field to the value on another form as follows: =!!.!+1 This of course only works if there is...

I reached a roadblock on my current database. I have multiple tables for data entry for each type of product we run. For example, product Crag 4/6 has it's...

Hi everyone, table : Name , Date how to make a query to group records by name having countofname for last 4 weeks as one group and for last 12 weeks (...

Hi Guys, I would greatly appreciated some help in building a Query that would check a Training Date Column and return the results in another Column that if...