Newbie poster on these forums!  :)   ...and fairly new to Access, so I
appreciate any help that can be offered.
I have the following:
 EOBcode  table

I am trying to recreate a query using the same tables and one of the
expressions is this: Salutation: IIf([company]=([FirstName] & " " &
[LastName])," ",[Salutation1])
What I can't figure out is why it will not display in the new query. The

I have a combobox which is populated from a query. It is used to set a
filter for the records shown on a form. So far so good.
BUT
I want to add a fixed entry of "All" to the top of the list....

Hi..
I have a table of Products and StateID. The products with a field for which
states they are availble using the codes from the StateID table
tbl-Products

In Access2003 I have a query that uses the start and stop date that it gets
from a form. In the query I have entered the fields in the Query Preference.
Form  - "frmSelector"
start date field - [forms]![frmSelector]![txtStartDate]

Hi..
I have a table of Products and StateID. The products with a field for which
states they are availble using the codes from the StateID table
tbl-Products

Some one please look at the code below and tell me how I can modify it so
that the portion of the code containing:
Me![txtItemNumber] = Format(DMax("[ItemNumber]", "[Tracking]") + 1, "000000")
[TimeReceived] = Date

I have a query that requires start and end date.  I would like to add a
parameter to ask for a customer number.  Customer Number is the title of the
Field that I need to derive the information from.  I have included the SQL
below to help you help me.  Thank you .

I have a table with 2 fields labeled "referenceno" and "referenceno2" and am
using a query to pull data from the table.  The query is asking the user to
enter the reference # and it's only pulling half the data.  This particular
problem has a reference # of 081207A and 081207B ...

I have a query that returns 1000+ records, and when I run it selecting 1
column, the rows returned are extremely fast.
If I select more than 1 column in my query, it takes a very long time to
return the dataset. Why is that?

I have a query with many fields but I want the output to show only those
records that have data in one of the fields.  If this particular field is
blank, I do not want the query to show that record.
Thank you.

Consider a simple Structure:
SalesTable: OrderID, DateOrdered, Etc.
InvoicesTable: SalesTable.OrderID, InvoicedAmount, DateCollected
PayablesTable: SalesTable.OrderID, PayedOutAmount, DatePaid

I have this query thatès working fine:
SELECT Max(GI_ACTENREG_TB.DHREACT) AS MaxDeDHREACT, GI_ACTENREG_TB.DOSSIER
FROM [T-Gestion des usagers] INNER JOIN (GI_ACTENREG_TB INNER JOIN
GI_ACTIVITE_TB ON (GI_ACTENREG_TB.ACTCODE_OFFICIEL = GI_ACTIVITE_TB.ACTCODE)

Hi,
I have a text field on my form where I scan barcodes from incoming packages.
What I need is a code that will count the number of digits of the number
scanned from the bar code. In this case all the digits are numeric. If the

There are many queries built into our database.  I changed one of the fields
from Text to Yes/NO.  Is there any way to conduct a search to find out how
many of the queries use that field? Not too hopeful, but I had to ask.  Thanks