I have a table that has five different columns with checkboxes.  I made a
query for this table and i want the last column to show the final group
responible based on the number of checks filled and checks not filled.  For
exmaple:

Anyone know Query Builder tool which can be used to build SQL Queries in MS
Access and MS SQL
Thanks, JohS

I have a query which does this: "Min(FormatCurrency([Claim
Finder].[BILLED]))" to show me the minimum billed amount in Currency format.  
That works fine.  But when I do this "Sum(FormatCurrency([Claim
Finder].[PAID]))" to show the sum of paid in Currency format, the number

I have a series of command buttons number 1 to 12 that open a new form where
I can select different attributes which then updates information on the
original form (reason for this is the editing is password protected)  one of
them is a combo box which has a list from a table ...

I have 2 tables (tServers and tTimezone) with the following structure:
tServers:
servername
city

I have 2 tables with the following structure:
tServers:
servername
city

I have a query that searches a database for matching zip codes.  The user
enters the desired 5 digit zip code and the query displays the necessary
information.
The database has zip codes stored as 3 digit (first 3 digits of zip) and 5

I'm having a problem with new records that I put in through my table
in Access.  When I go to the query where it should come up it
doesn't.  I only have to lines of criteria that are not very long.
This is a retiree database and there are 7 people which don't show

Dim wI_Qty, wL_FinalQty, wM_Qty, wS_Qty, wW_KittedQty, wK_QtyIf NewRecord
Then   'nothingElse  
wI_Qty = Nz(DSum("[I_Qty]", "Incoming", "[PartNumber]=""" & Forms!Inventory!
PartNumber & """"), 0)  

I need to create a make-table query containing 6 fields..
I have 16 fields in the original table.  The first is a primary key, the next
fifteen and actually three groups of five (a,b,c,d,e,a1,b1,c1,d1,e1,a2,b2,c2,
d2,e2) the need to be output as a,a1,a2 into a field called last name ...

I am trying to find all records where two fields have changed by 10 percent
year to date
I have weekly data of 40,000 unique names my table looks like this
date -element- subs- utilization

Anyone knows of a utility or software that will convert MS Access
queries to SQL Queries. I need to convert my existing ms access
queries to SQL queries as i need to use them in a software which only
takes SQL queries. I tried to copy and paste "SQLVIEW" of the queries

First off, I hope I am posting this to the right group.
Here's what I got.
I have a table that contains a type of service, cost and a comment.  I
have created a query, in which I want to combine two types of service

I added two fields to a table a date field and a Day field. The table
already had approximately 40,000 records. Is there a query I can use that
will add the date and day to the already existing data. I know moving
forward I can get update with an append query.

I have an update query with the simple criteria of 'Update Table Month
to 999 if QueryMonth is less than TableMonth'. This is part of a
rolling process to be executed by Macro. The Table containing
TableMonth is created bya  maketable query, and TableMonth defaults to