I'm trying to separate a word/string of characters in a text field from the
rest of the field, but the strings are of varying lengths.  Is there a way to
extract this?  For example, my field contains the following values:
RAST 2006-1 M5

In order to check out an issue with disappearing usernames, I moved a copy of
a client's front end, back end, and mdw files to a virtual machine where I
could reporduce their environment. After some adjustments, I was able to log
in successfully, but the loading of the first form ...

First time I've tried this.  I have created the "WorkingDays2" function from
the mvp/access site.  I Hope I did it correctly as it was my first.
Now, I want to use this function in a query to determine the working days
between two dates.  I have my startdate and enddate fields and ...

trying to construct a query field as follows.
Expr1:DLookup("[Value}","tbl1"," Value1= ClientNum And Value2 = ID"),
where values ClienNum and ID are fields of the same query.
When I try to run query, I get err msg of "MSAccess can't find field

I want to make a query on an OrderDetail table that sums the sales for
year 2007 by customer. This query will be used to make a table, the
table will be used to make a report later on.
Anyway, the detail order table has the item number, qty ordered, and

I have a query that pulls data from 2 tables all works fine if there is data
in both tables. Unfortunatly the possibility exsits that one table might not
have any data therefor not exist for that customer and those results do not
show in my form where the query displays.  I do not ...

Hi everyone, in a previous post I asked your help to have the following result.
SELECT Format([Data Valuta],"yyyy mm") AS [Data Valuta per mese],
Sum([Importo Debito]+[importo credito]) AS [SumOfImporto Debito], [Movimenti
2006-->].[Centro Costo]

I am attempting to create an Append query involving three tables but
am having trouble. This is what I'm trying to do.
Table A has a field called "Email", as does Table B. I start the query
as a SELECT query and in the grid I add the email field from Table A

I have another question about left join & inner join. The below works for
all the fields except [keys] for which I am asked for the value parametres.
I'm sure my problem has to do with misplaced or missing parenthesis', but
can someone please tell where? I have tried several ...

I am trying to complete the following in a query. It has two different
calculations.
Counter    SKU    Record_Counter
1    0783D    1

I have a table and a query and would like to create a query with SQL, which
has all the fields from the table plus one exlusive field from the query.
As I understood this is done by the INNER JOIN function and should look
similar to this approach:

I have a query that counts records of various types . Here is the sql
SELECT Count(tblComplaints.txtcompnbr) AS CountOftxtcompnbr,
DCount("[txtcompnbr]","tblcomplaints","[txtwithdrawn]=-1") AS [Count of
withdrawn], DCount("[txtcompnbr]","tblcomplaints","[txtcompcom]=-1") AS

I'm trying to create a formula for Z in which Z is equal to the entries of Y
multiplied together (instead of added as in the below example).  I've tried
to change the word "sum" to "multiply" or "product" but without any luck!
SELECT Table5.X, Table5.Y, (SELECT sum(Y) AS Z

Is there a way to create an update query to
If [MyDateField] < Date()
Update [MyDateField] to Next 2nd Thursday of month

I read a lot of posts on how to split data in a field. The text field I have
is part numbers and descriptions of parts together. I want to seperate them
to part # and Descrioption. I ran this update query Left([part_#]), " ",
0)-1). Which was successful to an extent. I changed ...