I have a database and a query.  Little background.  The database is
Emergency Run information for my Fire Department.  What I am attempting to
do, with little success, is create a query that will generate data based on
time spent times number of responders for each run.

WTF?
This Query:SELECT [Distribution Step2].old_sku, Sum([Distribution
Step2].Popularity) AS SumOfPopularity, Sum([Distribution
Step2].[OrigPopularityif notover]) AS [SumOfOrigPopularityif notover]

I have used the working day function (from The Access Web) to construct a
query which calculates working days and leaves out weekends. I am now trying
to filter out working days over 3. However, when I put >3 in the criteria
box, I get an error message saying something like 'type ...

I have a number field that I want to convert to a date type field.  The field
is in this format:  200706 where the year is 2007 and the 06 is the month.  I
want to convert this to a field where I would have a date field of month and
year, i.e. 06/2007.  Then I want to delete any ...

When I construct a query using Access, I can get data from a form by doing
something like ExchRate:Forms!frm_Menu.TodaysRate
Now I am trying to do this with a Query (View) in an Access adp project and
I cannot see how to do it.  I am trying to produce a stock valuation report

Hello everyone!  Using A02 on XP. I am trying to combine 2 select queries
into an SQL so I can have one set of data.  I am getting the error saying I
am 'missing semicolon (;) at end of SQL statement'.
Here is my SQL:

I have a (complex) query that uses a [Run_No] for it's criteria, which when
entered, it finds any matching Run_No's (that are related via other
criteria). All works well, except I also get the inputted Criteria Run_No in
the result too. I want to be able to get all the other ...

Hello, my problem is access 97 started not to recognise the built-in
functions suddenly, such as month() or year(). Could anyone help me how to
resolve this? Do you know what the reason might be? I need urgent help...

I cannot find anything in the help files to assist me with computed columns
in a Access Queries using adp/SQL.  For example when using Access (mdb) I
could put Member:iif([Paid]>0,"YES","NO"), which would result in a column
called Member with a value of either Y or N depending on ...

Hi. I want to create a querie with multiple criterias.
In my form, I have several fileds to find a product.
Nop    Name     Family     Brand     Type    Factory
So imagine that in the form user only fill the NOP field, or fill only the

I have a database that lists media contacts, the regions they are from and
the different categories of media releases they have signed up to receive. I
have queries that allow you to search on release category or region or both.
The problem I'm having is that when I search on two ...

I need a criteria to run a query to pick up the last four number of seven
digit  number. Is it possable to use a parameter such as  Between [Enter
Begin Sequece] And [Enter End sequence] Or Like "*"  with an additional
criteria to just pick up the last four numbers?

Hello.  I've read several posts regarding this issue, but have not been able
for find the solution.
A vendor gave me this equation to determine total minues, based on military
time.

I used a database in multiple PC and now I cannot make any entry in the query
or forms.
I changed the Recordset type to  Dynaset (Inconsistent Updates) but now I
cannot scroll though the records, only the last enry is dispalyed. What did I

I am using the contacts db that comes standard with MS Access. What I
am trying to do is create a query that gives me all the contacts that
have had no calls. I have no trouble finding all the ones that have
had a call, I just can't do the opposite. This is what I have so far