I have a one to many relationship between table-A and table-B.  I need to
list records from table-A where records from a selected group of records in
table-B are not found.   Ex. Members and MembershipDues Tables.  Want to
determine which members have not paid their quarterly ...

I have a Union Query that displays correct values but in an unformatted
table.  Is there any way I can format these fields (they are correctly
formatted in the original queries) and also change the displayed field names
?  Thank you !

I have a table that contains items that are in two locations ( pick)  or (Bulk)
I have been able to total them all together to show grand total
I can query each by location
What I would like to do is to show a line that has the item,  bulk quantity,

Is it possible to create a query to pull transactional data by month stored
in rows and create a result that shows the transactional data in columns?  
Currently, the the numbers are stored in the same column but can be
differentiated by another column that contains the date of ...

Can a crosstab query have two values in its TRANSFORM statement?  I am trying
to create a table that would have a structure that looks something like the
following:
EE Name                   Date of Occurrence             Date of Occurrence  

Good Afternoon, as simple as my question may sound I am having a bit of
difficulty passing the results from multiple queries to multiple texts boxes
on the same report. I most certainly would like to learn how to achieve this
functionality through proper coding! And of course I ...

I have a table containing student # and the projects that they did.  Records
are created one project per record.  For example, if a student A did 4
projects, I would have 4 records, instead of one record with project
information across the record.  Project information contain ...

can someone help me with a way to find whole dollar amonts for
PDetail.DETAIL_LINE_AMT
SELECT PDetail.RECEIPT_NUM, PDetail.DETAIL_LINE_AMT, PDetail.DETAIL_ITEM_PRC
FROM PDetail;

I inherited a .mdb that has no documentation.
One query contains a number of fields, one, "Last Name" is sorted in
ascending order and has for criteria <"iq".  I do not understand where 'iq'
comes from.

I'm trying to use this in a query, but I can't figure out how to remove the
quotes around text ie "Nashville" need to be Nashville.
Company_Name: Replace([CompanyName]," ","")
I'm using Access 2003

I currently have a error message when generating a report. I am getting an
#error when it comes to the age of the person and there are no results on the
report. I have looked at the expression but it is correct.

Your assistance is appreciated.
I have been tasked to manage a backlog of workorders.  I need to select the
first 200 (ie oldest) records to make a report to enable/encourage the
workers to work the oldest orders first.  

I have a table that is in the correct format. When I run a append query
against this table the format is off, there is a number where there should be
text. How do I fix this.

I have 7500 records in my table, which has many columns, one of them being
"CallTotal".  The primary key is the AiringID.
I created an update query that is intended to update the CallTotal.  To do
this, i linked up an excel spreadsheet to my database. I copy and paste info

I have a list of social security numbers within a table.  I want to be able
to link them to another table that has a social security range and the state
in which they are from.  
First Table (1 Field)