I have 4 combo box dropdowns and I need to build a WHERE clause based on any
combination of them or all using VBA. Can someone show me or point me in the
right direction?
Thanks.

below is the union query statement that had been built.  up until last week,
it had been working, however, for some reason, it is not cooperating:
SELECT A.EMPIDValidation AS EMPLOYEE, [Period ending] AS PEREND, "WEEK" AS
TIMECARD, 2 AS CATEGORY, A.ecode AS EARNDED, "" AS UNI, A ...

I have a table with four fields:
Group                        Under Group                Primary Group
=====                      ===========             ============
Sundry Debtors           Current Assets            Current Assets

Good afternoon,
I have tried my best on this but am unable to figure it out.  
---------------------------------------------------------------------
Scenario:

How can i express the percent margin in a query? I have a field PurchasePrice
and a field Salesprice. the field Purchaseprice is the price at which we buy
the products and the field salesprice is the field at which we sell the
products.I tried to substract the salesprice to the ...

I have a query that is showing an average of hours worked over 6 weeks. I
need to query by both the range of weeks and by the employee's department.
The issue is that some employees changed department during the 6 weeks. Is
there a way for the query to get the last 6 weeks based ...

I am using a crosstab query for selecting data for a date range spanning 12
months over two different years using a "Between & And" date range e.g
Between #01/04/07# And #31/03/08#
For the following 12 month period I can manually change the Year numbers in

Good Afternoon,
I have a rather challenging question for your consideration. Please consider
my existing process/sample data....
                                 tblReservationData

Good day ,
I have been trying to find a fix for my problem with no luck. I am trying to
run a CrossTab query that is based on another nested query and I keep on
getting Error 3070. I don't have a parameter in any of my queries and I

Hi, all
I am trying to figure out an effective routine to comparing a number of
fields (around 20) between two tables (The two tables are identical) the
results would be the record source for a form.

       As you can see below I have a query which includes records from the
reservation table, but I want to show only those records which their arrival
date ARRIVAL of the RESERVATIONS table is equal to the value of RUNDAY in
the HOUSEKEEPING DATA Query.

I have a query that calculates numbers. The numbers are like 14.7256589 or
10.2356343. How do you round those to 2 decimal places? I could do a left
function and just cut them off at 2 decimal places but I actually want
rounding. I also tried the round function and I couldn't get ...

I am not sure how to design the following query. Please reference the two
sample tables...
TABLE A
FNAME       LNAME        ADDR1           CONFO

I have a query like this:
SELECT vCashTransactions0.Zone, vCashTransactions0.TDate,
vCashTransactions0.ACCode, vCashTransactions0.Amount,
vCashTransactions0.ItemAmount, Accounts.AccountID,

Whenever I open a query in an application, it takes over the whole
application.  Is there any way to open a query like a popup.  My objective is
to open a query from a form, have it appear over the form and have the
ability to close the form and continue on my way.  It doesnt ...