I have a text field that has multiple pieces of data that I need to separate.
For example 1,2,3 is inside one field. Does anyone know of a way to separate
this field into three separate records by using the comma or some other
method????

I have the following in a query and until some data comes at a later date it
will error out. Is it possible to use an IIF statement to return something
other than #error
Gross pct Change:

Is there a way to show duplicates from a query without blank fields showing
in list?
This is what I am using in query grid from duplicate query wizard:
In (SELECT [SERIAL #] FROM [DbArchives] As Tmp GROUP BY [SERIAL #] HAVING

I would like to generate a list of dealers, with date of last claim
for those who have submitted any, and either N/A or null for those who
have not submitted valid entries.
There are 341 records in my dealer table, but the query only returns

I am a fairly novice Access programmer looking for best practices/examples
on building a search form.  Also, on checking for the result of a query.
I would like to build a form that queries for and displays an employee
record.  There should be 2 ways to query:  By the employee ...

I have a call log table with many entries for each client.
Is it possible to run a query that will show all the clients, but only their
last record?
thanks

I have tried everything I can think of to make this work....I have a list of
employees that need to be matched up with an employment status.  I cannot
just add it to my table because it is linked to other employee databases that
I do not have authority to change.  I don't know ...

Currently i import 2 excel files into my database, at different times.
I am looking to update one of the tables depending on the information on the
other. i.e. The first table is stock gained and the second table is the stock
sold.

Hello. I need a little help. Is there a way to find out which records were
grouped in a group by query, and maybe flag that record with a specific tag
for example in this scenario:
ID       Amount     Name

I do not know if this is possible but I would like to have user entered
criteria sent to multiple Query's at the same time. What I have is several
Query's that look for something specific on what was purchased in different
catagories. They need all that info in one report, the ...

I have a complicated query I need to run and am not sure how to
approach it...looking for some guidance.
I have 2 tables:
1) tblPayments (contains a list of payments made to an Applicant)

I am trying to make a query that has Rig1, Rig2, Rig3, Rig4 on the top..
Category 1-15 down the left side and the Totals of each category for that Rig
under the Rig name (Rig1, 2, 3). Sounds simple.. In recent reports I have the
Total = total_value: Sum(Descriptions ...

How can I structure code or a query to find the minimum and maximum [Year]
and [MthNbr] for each [CustID], one record per [CustID], e.g.
Table1
[CustID]            [Year]        [MthNbr]

I am trying to write a query that will assign x number of leads to a certain
sales rep.  I am not sure about the best way to accomplish this, should I
save a top 1 query and then loop through or imbed a select statement in my
update query?

I have a bunch of dates. I just want to pull everything from January
to March (1st quarter) but doesn't care about year.
I will be selecting a Year from a combo box, filtering all the
appropriate data. Then I want to look at all the dates and pick out