Dear NG - Yes, I'm brand new so I will apologize in advance for being such a pest. Lets say you run an update query and at a later date decide you want to see...

I am using Access 2002. I am writing a query can creates a 'flat' result from three other joined tables. One field is a memo field that contains a large amount...

Data Information: table1: tblPayGradeStructure Fields to be used: CurrGrade and CurrBreakpoint table2: tblPredSalary field to be used: PredSalary (note...

Is it possible to create a like relationship? I have two tables but one contains variations on the other ie setup per machine and are called different...

Hello folks! I've got a problem. I guess it's why we always come in here when that's the case :) I have three tables as follows: SIR (PK : id) SIR_D (PK :...

I have included the SQL below: This is a total query that calculates total dollars sold out of each of the 1800 stores. As some of the stores have just...

Hello all, my database lists parts that have the following fields (amongst others), BOM TIME PRICE CABLES CUSTOMER PARTNUMBER

I'm trying to get three buckets of users based on their variation in number of transactions between two years. I get an error message stating "Syntax Error...

I am trying to get the user to input the policy number if auto assign is set to no. wrkfld1 : Iif( = "No", ) Except I get dialog box "Enter Policy Number"...

Hi, I have a Access 2003 database. I run SQL querries via a homegrown application that uses ADO. The database contains 20 tables, each with the same schema,...

I have a database with one line being the sex of the person. I want to count how many people of each sex were input. Also I want to count by age groups hwo...

How can I locate a specific word in a field. For example, my query is asking the question "How many vegetarian recipies have the words "very nurtritious" in...

Hi! I built a Main table, normalized, containing about 800 records. It will grow to about 1600-2000 records. 21 secondary tables (code, description) are...

I have two tables joined one to many. The one is patient name, the many is scan date. When I run my query it will give me the patient name as many times as...

Maybe it's a typo but Value2 is missing a leading double quote. -- Jerry Whittle Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder. "John"...

I added 7 days to a WkEndDate to come up with the paydate in a query. When I use "Between and to get all the pay days in that month, it gives me the right...

I have to perform multiple calculations, based on a date field, for a report. The field is called = "IssueClosedDate" all the calculations are based on this...

I have a table of UK companies whose records I want to filter using a map of postcode regions. For the benfit of people outside the UK, our postcodes are a...

Hello all, I'm trying to achieve a join, and I'm having no luck. I'm hoping someone can help me out. I'm hoping my spacing for the column examples will...

How can I make the output of a calculated field display without decimals? The calcualtion below works to calculate the calculated QT Time which is cardiology...