I have two tables, one for the companies' info and one for t selling
In the selling table there is data for customers, companies, prices etc.
What I want to do is making a query to know which company has the large No.
of selling.

Hello. I originally planned on having CompanyName for those companies who are
members. But the users have been entering CompanyName for both companies who
are members and as the place where an individual member works.
So my mailing label to an individual's home address includes ...

Is there any way that I can seperate the maximum values based off of
the seconds in a field? I am trying to find the maximum values for
certains days in various months, but unfortunately they are not
entirely working if the seconds are only a few apart. Here's an exact

I am tring to run a query with 2 tables in Access 2002.  I need to match
customer names on the two tables.  I drag the field Customer Name from one to
Customer Name on the 2nd so that it will pull the information.  But, if the
name doesn't match exactly, it won't find it.  Ex. ...

Is there a shorter way to write this,
perhaps replacing the multiple WHERE
clause so it only needs to be written
once?

I am getting the following  error message:
Microsoft OLE DB Provider for ODBC Drivers (0x80040E14)
[Microsoft][ODBC Microsoft Access Driver] This operation is not allowed in
subqueries.

Does anyone know how to write a SQL Script for Access 2007 that will allow
all fields to be selected?  I created the following script and successfully
executed it in Access 2003 but it will not work in 2007:
UPDATE EXISITNG TABLE

My idea is create a query. The field set as the job number field and the
criteria i set is as
"[Forms]![WIPCategory]![txtC_WIPCategoryID]"
But it simply can't work...

I am trynig to find the maximum value based off of dates that contain
times down to the second. There are a few that are only seconds apart
on the same day, and even my query containing MAX returns the both of
them.

I am looking to have a counter in my dynamic query.  I have a subroutine
incrementing a value but as soon as I scroll in the records, the values are
changing...
How can I make sure that a record stays with the same number (for the same

How do I create a user input query so it can be added on the switchboard?
I need to create a way for a user to input/select specific parms, press a
button, then alacazam! Their query appears! (If you can't tell, the user's
are unfamilar w/Access so it has to be easy for them.)

cannot enter value into blank field on 'one' side of outer join

I try to use IIF and OR functions together, it does work well at MS Excel as
follow
=IF(OR(C1="CC",C1="ZD",C1="CE"),C1&"_"&D1,C1)
I try to implement it at MS Access 2000 as below, but it does not work

i want to round up the value of the calculated field to nearest multiples of
50. In excel we can do this by ceiling function. what do we do in access?