I am tring to mark up several products in a query by 10%, I know this is
simple but I have went blank on it.
Please Help

I need to create a query that gives me everyone who has a start date that is
45 or more days old.  The field that I am querying is Start Date and the
format is short date.

I have 3 tables I am trying to join in a query. They are as follows:
tblProducts
tblCustomerEquipment
tblEmployees

I have a query that selects certain Zip codes by first 3 digits
SELECT qryContactNameV1.ContactName, Left(Contacts.Zip,3) AS FilterZip,
Contacts.Address1, Contacts.Address2, ([City]) & ", " & ([State]) & " " &
([Zip]) AS RemainAddress, Contacts.Company, Contacts.Title, Contacts ...

First, let me say I love this discussion group.  It has saved me hours of work.
Here's my dilemma.  In a query, I'm trying to convert a text (date) field to
an actual date field.  I used the following IIF statement:
IIf(Year(DateValue([MEMBER_DATE_OF_BIRTH]))>2000,DateAdd("yyyy" ...

and what can I do about it.
The SQL is shown below the #s:
148
154

I do a make-table query and then try to use it to delete records from another
table called RC_Main,  The SQL stmnt looks like:
DELETE RC_Main.*
FROM [Pending Deletion IDs] INNER JOIN RC_Main ON [Pending Deletion

Here is what my table looks like:
Date           QV         GH      Time Slot Total         Morn.        Lunch
    Afternoon
Nov. 1         YES       YES        1                          YES

I am creating a database that includes classroom information, such as:
grades, attendance, etc.  I have one table that is called Student information
and the primary key is the Social Security Number.  The rest of the ten
tables don't have a primary key because I was obtaining a ...

How do I compare 2 number fields btw 2 tables to id records where the numbers
don't match, and return some kind of an error msg? Thnx.

There are several update queries in a db I am maintaining.  They run when a
user enters data in 2 fields on a form and clicks a button.
The button runs 8 queries in succession, then opens a form to see the results.
Several of the queries are update queries.

Is it possible to extract one string from another - so for e.g. if stringA =
"This is a string" and stringB = "is a" then the expression to extract
stingB from StringA should return "This  string".
I would be very grateful if anyone could help me with this.

I have a query that counts the records in a table for each id.  e.g. id 1 is
in the table 6 times so the query gives a count of 6....
I link it to the main table where all the id's are at. Is there a way to
tell  what queries were not used?

I have a form query that returns certain records twice. The scenario that
trips me up is when two instructors share a class instead of returning two
records (ok) it returns four of course two of them are exact dupes.
If I add DISTINCT or use a group by First, it barks that the ...

*I studied a website who has tutors regarding SQL, but it uses more the
ORACLE approach, and they often give complex examples like this, what i
would appreciate is how to make the same work in Access so
MicrosoftJetEngine recognizes it well: