Hi, I hope this can be done. I have a big data resource that has fields like this: Student Name Subject Question1category Question1subcategory...

I have 2 fields in a table JobNo Employee 1 A 1 B 2 X 2 Y 3 H 3 J 3 ...

Hi I am trying to use a delete query where any records that contain the Word Proprietor is removed. In My current table there are hundreds of records...

My goal is to automatically update the End Date to display the create date from a record previously reported. For example the end date for the first record...

How can I automatically update the End Date to display the create date from a record previously reported. For example the end date for the first record...

Hi, I'd be really grateful if someone could please assist with my query. I'm trying to identify all records where is equal to 'Atlas' that has matching...

Hi, I have a table with FieldA, FieldB, FieldC. I want to delete records based on FieldA, leaving me with one unique record. The corresponding data in...

Hi, Given this image, http://members.dslextreme.com/users/madforplaid/queryCount.jpg, and its SQL as follows: SELECT Q.FullKey, Q.TimeBucket,...

I have made a Join Query that works OK. In this Query I have a column that I use to make comments. This column is in the table used to make up this query as...

TRANSFORM Count(MyQuery.ID) as CountOfID SELECT MyQuery.Code, DCount("*" , "tblActivityDetails" , = #3/14/2010# and = #3/20/2010# and =...

Just to be clear. I can NOT create a passthrough query that references a form control for criteria. I would have to generate a stored SQL with the value of...

I HAVE 2 QUERIES FROM 2 SEPARATE TABLES ONE HAS THE TREATMENT SALES FOR THERAPIST BY DATE ONE HAS THE RETAIL SALES FOR THERAPIST BY DATE I JOIN THE INFORMATION...

if i am reading it correctly, you just want the names that appear in both tables? That would be a regular Select query Joining the tables. SELECT...

I have two tables, one table listing names of people who did not receive a gift card and a second table of people who were taxed for the gift cards. Both...

Looking at the Northwind database as an example, I need to take all the products from the Orders table and put them into one field in a table for each...

How can I convert a text field to numeric value? The text values a 35 15 1.5 0.015 9900 The desired result need to be:

Hi there! I am setting up a database for our branch offices to use in a distributed (FE/BE) format, and am wondering which would be better for speed: 1. A...

Good Morning, I read the threads about creating parameters in crosstab queries and this helped me to get it to work but the parameter box pops up when I try...

How can I refresh the updated pricing on a list of items?

I have a Union Query that returns these results: Department # Department Name IOD Paid WC Paid 106011 HRR THERESE SMITH ...