Here's the scenario... I have a Manufacturer number and a unit price for that
product.  The unit price should always be the same for the product.  If it
isn't, then I need a query/report that will say here are all of the line
items where a product had more than one unit price.  ...

Hi folks.  I'm working on a database project for a real estate firm.
Some of their reports are done manually right now, and they want to
begin using databases to simplify the tasks.
The reports are currently made by hand in an excel spreadsheet.  Each

Is there a special handshake and a secret word I can use to get a response in
one of these forums? Please, Abracadabra, Gates?
I have asked questions in this as well as the reporting services community
with no feedback. So how about this, what is the best source for help with

I have SQL generated at runtime.  I added the WHERE clause, and this has
been giving error messages ever since.  Basically the goal here is to get the
WHERE clause to calculates 3 dates and put this in a conditional IN criteria,
like ... WHERE [BookMth] IN('200610','200609' ...

I've made a function that would calculate only business dates between current
data and a date field (Nxt Cpn Dt).  I've used the function dhCountWorkdaysA
in a query, which works well but if I put a number for the criteria i have
the error "data type mismatch criteria expression. ...

I am trying to append two large tables of contact data. One table has 10,000
entries, the other has 7,000 entries.  This a simple append query.  The Error
message reads:
Microsoft Office Access

Hello. I'm making a database to manage the employees extra working hours. I
have a column that already have the total of worked by hours by day. I want
to calculate the diference between the worked hours in one day with the
official hours that the employee have to work. Imagine ...

Using a query, I'm trying to count the number of records in a table that are
not null.  It looks as though there's actually a space in the fields, so I've
tried all these combinations to no avail.  The values in the field are text,
but it doesn't matter to me what text it is, I just ...

Hi friends,
I would like to know about the SP(Stored Procedure) or a SQL Query
which will copy data from:
DB1 -> tbl_alm3     TO       DB2 -> tbl_alm3

I have an Acess DB with linked SQL tables using ODBC.  I am trying to run a
query which uses a form to specify criteria.  Here's the criteria in the Date
field:
Between [Forms]![frmChooseReqDate]![StartDate] And

Just when you think you think you know Access, you try to do something more
complex and get stuck again....With the help of your discussion group I was
able to come up with a query which outputs two fields. The query is based on
two tables, TbInterp LEFT JOIN TbAo.  The results of ...

I have a database with information on carriers, lanes, and prices.
I need to choose the cheapest 3 carriers for each lane.
The lanes are either 3-digit zips to 3-digit zips or state to state
(410-300 or CA to GA, etc.)

In Northwind, a DLookUp function on the [order details] subform populates
[unitprice] with the price of the product being ordered. This is to record
the Product price (which can change) at the time of sale.  Here's the
question !

Dear group,
I have two queries, which if they are run separately from Access work
as expected. When I run them via the code, each one after another,
unexplainable four records are added to final table.

Here's the situation... Say I have a table of employees who may work at
various sites in teams throughout a year.  I want to be able to supply a
partial team as the criteria to cross reference other teams that may have
included those members.