I'm not sure if this is the correct place to post this, but here goes:  
I created a lease management database to house lease/rent payment
information for over 200 stores.  Every month, we have to print a rent
remittance report to send with each rent payment.

Thanks in advance for your help!
I have 2 tables: Activity and Correspondence.  The relationship between the
two is a one-to-many.  For each activity, there could be multiple
correspondences.  On the Correspondence table the fields are:

I have a text field. I am trying to find all the rows where this field is
less than 4. The function is not working. It does work if I look for all rows
where it is equal to 4. I have tried < 4, <"4" and < '4'. None of these work.

Hi -
I have a form linked to a table that has 6 specific fields that I do not
allow duplicates.  Is there a way to have the form field tell me when a
dulpicate entry is made before the record is complete and submitted?  

I have 1049 records to append to a table with a 3 field PK.  The append
rejects 789 records due to key violations; no other reasons reported.  A Find
Duplicates Wiz picks out 14 records with Field1 being duplicated.  I also
create a field during this append that identifies the ...

I need to create a sort key to sort a text field in alphabetic order starting
with a different letter each time the report or query is run.  the user will
supply the starting letter (usually different) each time .
If the user wants to start with the letter "J" the sort order wll ...

How can I make a query the will show all the product type from 2 different
tables. 1 table holds the budget and the other one holds the sales. Not all
the productytype are the same from this 2 table but i wanted that everything
will show up in a single query. Thank you for any ...

How do I stop my query from asking me the parameter value everytime I
open it.
this is the query:
SELECT ESR1.[Dptr Date], ESR1.Origin_Destination, NZ(ESR1![SumOfBid

I have a series of do.cmd's that run queries that are executed when I click a
command button from a form.   All of these queries make or append to tables.
What I want is a way to have a summary table that specifies all table names
that just got made or appended to, the date/time ...

I need to set the critera in a number of queries using a macro.   I have 12
macros, one for each month. They set the critery in the month column of
different queries.  I had used the sendkey command but it will not work in
Access 2003.  I upgraded from an old version that worked ...

i have two tables i would like to compare data to.  the fields i need to
compare are date,shift,line,size.  is there a way that i can compare all
these fields at once to another table.  for example  date - 06/04/07,
shift - 1, line - retail, size - 16 oz.  now if my other table ...

I've run into a curious behavior with Access 2003. I would like to
know if Access 2007 handles things differently. I have to provide a
bit of background before I can describe the problem. In this context
I'm using Access 2003 as a tool to analyze and manipulate string sets.

I have a form that asks the client what "batch" to export to excel. I need
the query to export to excel with a sort of parameterized query. I tried
using the control name as a paramter i.e. me.cbBatchNbr, but it didn't work.
How do I get the query to export only a subset?

Anyone who has a sample of Query which make a group of a COUNT of a text
field.
(I have about 15000 records which I would like to have presented in bulks of
500).

I'm creating a database to track inventory movements for reserve calculation
purposes.  I start out with two tables, Inv Mov and Inv Bal.
From Inv Mov, I create a Query "Initial Movements" as a filter.  When I run
this query, all looks good.