I have two tables in access, one called "A", which has the following
fields:
VendorID  VendorName  DocumentNumber Amount Period
123     ABC             55545           132             1

I have a form named activity report that takes an employee's id and activity
information for a day and inputs the data into a table called activity
report. The talbe Activity Report is connected to another table called
employees which stores the employees personal information ...

I'm new to MS Access and studies it through exploration and by reading Q&A's
from Microsoft.com.
I entered syntax query IIf([Field1]>1,(([Field1]+1)-[Field2])) in design
view of queries.This becomes Expr1: IIf([To]>1,(([Field1]+1)-[Field2])), when

I have a fairly simple if/then question I cannot figure out.
I'd like to have a query that places [Firstname]+[Lastname] fields into a
new field if data exists in [LastName].  If [LastName] is null, I'd like the
field to fill in [OrganizationName]

I have a top 15 query that works fine except I would like to get the top 15
per day.
So if I have 3 dates it would show each date with 15 in the list.  
How do I get it give me the top 15 of each day?

I get a #error returned if the following Iif statement is false:
Netting_Group: IIf(Trim([NettingGrp])=0,0,Trim(Right([NettingGrp],20)))
Meanwhile, the following statement returns the string expected:
RtNtgGrp: Trim(Right([NettingGrp],20))

Does anybody have a permanent fix for the 'enter parameter value" dialog box
that pops up after closing my query dialog form.
I have gone back and looked at my query, the record source of my combo box.  
I even used some code that will set the recordsource value of the combo box

I'm trying to wirte a query that will display a certain text string. I want
to find all the records that one field is formatted in a certain way. I need
to see the records that start with 3 numeric values followed by 2 alpha
characters and then 3 numeric values ie 123AA456. In ...

I've made a database that allows data to be input through webpages.  I want
to be able to make data entry as fool proof as possible by preventing people
from inputting data that causes impossible situations on the other end of a
calculation.  For example, I'm having people input ...

I have 3 queries that need to run consecutively.  What would be the
best process?  A button click or macro?
Thanks ahead
Maureen

I've got a query that calculates a commission on a transaction, but there is
a minum charge that I can't seem to incorporate.
In other words, my calc in Excel would be =IF((TransactionValue *
CommissionRate) < MinimumCharge, Minimum Charge, TransactionValue *

I have an inherited database set up in a way that I find confusing. I hope
someone can help as I don't have the expertise to normalize this database.
There are three tables, in particular, that are giving me trouble.
One called tblBooks (and this is imported monthly from Excel) has ...

Good morning all,
Is it possible to use a query to preform the Compact and Repair
command?
Thank you,

Is there a query or command somehwere that will take, say, six columns
and combine them into one column, but keep associated data the same?
To give a simple expample, lets say I have a table with a DATE, TIME,
MEASUREMENT, and three columns called SAMPLE1, SAMPLE2, SAMPLE3.

Here's what's going on:
Table A has a series of records.  Table B contains another series of
records.  I want to query all the records in Table A.  However, if Table B
contains the Unique ID of one of the records in Table A, some of the data in