This query will show me the symbols that have 2 symbols on the data table but
I would like to see the symbols that have 2 entrys only on the 16th and 15th.
so if abc is in the data table twice and if the two times have a date of the
16th and 15th then show them to me.

I know it needs a mid expression , left expression and right expression. but
I can't seem to string the expression together without errors.

I have adopted an existing database and associated application (forms,
reports, etc.). It has more bugs than an ant colony, but the users depend on
it heavily.
I want to create a bug reporting tool for my users to track down the

I have a query built by the query builder that has parameters. When I run the
query a window opens asking for the criteria. If I hit the cancel button in
this window, I get an runtime error '2501'. How can i fix this?
Thanks.

My backend database is SQL-Server. The query is in Access via ODBC.
It's running fast when I test it on SQL Query Analyzer but run really slow
in Access.
Please help if you can, TIA.

I have 7 tables in an inventory database with differnet primary keys. The
keys are based on what is being inventoried. Each table has a common field
called SerialNumber. What I want to do is create a query to search each table
for a matching to the serial number that the user had ...

I'm using an update query to change dates in the NewDate field to the first
day of the month that is currently shown in that field.  I'm using the
following query that looks like it's working, but I want to make sure I'm
writing it correctly.  Thanks much!

Query Example
Please can anyone tell me the correct expression to get Pay Field to
calculate running sum for me as below?
SecID    Paid    Rate    TotalHours    Total    Pay

I have a query that asks  users for a date range.It asks the users to put in
a starting date and also asks the user to put an ending date. The query works
fine but the only problem withthe query is that when I enter the same date in
the date range it does not return any records. ...

I'm brand new to acess and have run into a problem. I reviewed previous
queries on this subject but could not find a solution to my exact problem or
at least one easy enough to understand based on my limited access skills. I
have a crosstab query that returns counts of flake type by ...

    I am making a query where I times a field from a table (Annual Salary)
by 1.5 to get a base. How do I get it to round up to the nearest 1,000.
Thanks!

I have an Access 2003 db with 4 tables.
tblFC has FCID and FCName
tblOwners has CompanyID and Owner
tblType has TypeID and TypeName

I have records that have certain classifications.  the classifications are
entered via an option group, so the resulting data in the table is an integer
value.  i want to run reports by classification, so i have a parameter query
that asks the user for a value.  i want the user ...

I'm wondering if MS Access has a way to do Full Text Searching like in MS SQL
Server 2000, in which it can search documents embedded in the database.
I want to do a content search of the documents in a MS Access database in a
ASP.NET project.  Documents are stored as Ole Objects ...

I have a numeric field that is my primary key.  It is employee number (3
digits) and when someone quits we delete them from the database. I need to
know what numbers are free for new employees.  Is there a way to do this?
Thanks!