I am developing an application which is sort an inventory system. What I need
to do is load last month or weeks data minus the new product additions. This,
I want to leave blank for obvious reasons, however, I do not wish to have to
re-enter all the same data again. The data ...

I have 3 tables "Owner", Business" and "Annual Fees". They all have a one to
many relationship ie. one owner to many businesses and one business to
several annual fees.
Every year my user needs to query the businesses to find the ones that have

I am using the 2003 Office Professional Package
In running a query in Access the following error message pops up Error(3085)
- Undefined function"CStr$" in expression.  I have reinstall Access and it
has not corrected the problem.  Help!  

I have a table with the follow data:
Store      Quarter    Month     Sales Percent     ID
245            2          5                3.5%             110
245            2          6                3%               111

I'm trying to set up a cross tab query with the column headings as
payroll dates
(ex. 1/15/2005, 1/31/2005...etc). Is it possible to do this
programmatically? If not then what would be the best way to get the

I'm getting error about 'missing opeartor' with my query below.  Appreciate
it if someone can help me out here.  Thanks, Alpha
UPDATE  VehDetail
set  LastOdometerDate = Max([Data].[d_DateTime]), LastOdometerReading =

I have a query built with a "start date" and "end date" parameter.  What can
I enter in the "end date" to allow the query to run through "current?"

I have a query with 50 peoples names in, some names appear more than once.  
What I want to do it to show all names that appear more than once and not
show any name that appears once.
thanks

I have two tables.  They both have a field "Product_ID", and are linked on
this field.
One table has a field Vendor, every record in this field is empty.
The second table has the field vendor, and they are all filled in.

I designed a query with over 60 columns I need too enter information in each
columns  for the 'Description Property' is there a way to add info into query
properties dynamically (may by in the sql or???)
Thanks

Hello!  I am looking to create an SQL statement, or anything else, that would
allow me to create tables with a variable in their name.  For example, I want
to make a table named tbl092005 where the date (092005) would change
tomorrow, thus creating a new table.  Does anyone know ...

I have a table.  the table has a field called "product_id".  there are many
records with the same product_id.  I would like to run a query that will
delete all the duplicate records so I end up with only one record with a
unique product_id.

I want to create a report that will always give sales for the current week
starting with monday and going to friday.  We are closed on Saturday and
Sunday but if a sales manager runs a report on friday or saturday, it would
give him sales for this week.

I am trying to create a make table query that contains an end value dervied
from numberic fields within the table. I have 9 different columns where I
need to add the values and in the made table, add an additional field which
details the total for each row.

I have 2 tables which have a field whose value is either Yes or No.
After performing a UNION query on both these tables the corresponding
resuting field shows a value of -1 for Yes and 0 for No.
I'm not being able to format that to Yes or No.