Hello MVP's
Please help with my problem
Below is my SQL and Example
SELECT PDetail.TIME_STAMP, PDetail.RECEIPT_NUM, PDetail.DETAIL_FOR_QTY,

I have 2 tables and I am looking to create a query that will display the data
only if it exists in both tables. I have been doing this in the past by
running 2 unmatched queries, but I am assuming that there must be a faster,
better way and I am hopeful that someone here could ...

I have Access 2000, and when I created a query in my computer, the query
automatically adds the asterisk (*) to the end of the query design in SQL
view, but not visible in design view.
Then it causes problems when I try to run total queries.

I'm trying to calculate a backlog (Amount of previous days backlog + amount
received today - Amount processed today= Backlog). Currently I have a query
that calculates amount received - amount processed, but I need it to
reference the previous days backlog to add that to the ...

Is there a way to build/run a make-table query that automatically creates an
empty field with a data type OTHER than text, and OTHER than binary?
I'm trying to automate a process where I don't have to go into the table's
design view to change the text field into another type.

I am attempting to convert a text field into a long integer.
I have two fields in my table.
Field1 (Value COCurr): Text field containing string numbers with
commas, decimals, and trailing negative signs

GGWDAYSOMKT: IIf([liststatus] In ("expired","canceled","withdrawn")
as in the format above, is there a similar way to structure "like" such as:
GGWDAYSOMKT: IIf([liststatus] like  ("*expired*","*canceled*","*withdrawn*")

My second question,
I have the following statement and it counts the days correctly if there is
an intake but it does not count the days correctly if there is a termination:
Days: IIf([Client DOT]<#9/30/2007#,[Client DOT],#9/30/2007#)-[Client DOI]

Can anyone tell my why the following Query causes an Invalid operation? If I
change it to and Inner or Right Join it works fine.
SELECT TotalProdDP.Policy, TotalProdDP.Face, Directory_Corporate.[Division
Name], Directory_Corporate.[Business Unit Name], Directory_Corporate.[Market

I have a query that returns text. SOME text is just text but some text has a
number like X1027 - in front of the text. It might read like "X1027 -
Jonesboro High School". The text lengths vary from school to school and some
don't have the numbers in front. How can I remove the ...

I created a database for a school that tracks infractions.  Each time a
student uses their phone or violates a dress code, they get an infraction
point.  I have created a query and report that sums the infraction points per
student.  I now want to restrict my report to only show ...

I have two fields’ country (Dropdown Text Field listing Countries) and
Individuals (Number field containing the amount of people from that Country).
Is there an easy way to do a percentage?  I.e. How many people overall are
from a particular country?

Hello all,
In my inexperience and probably unconventional ways, I created a crosstab
query that has this SQL statement.
PARAMETERS [Which year?] Short;

Hello all, kinda stumped on this one:  
I have 3 tables, Media, Software and Links
Media is the main CD, and contains an ID number (d4)
Software is various software components we use, also has a serial #

How do I create an Access database front-end to an SQL Server database
back-end so that you can create a front-end/back-end application
(front-end/back-end application: An application consisting of a "back-end"
database file that contains tables, and copies of a "front-end" ...