I try to replicate in Access a query that works fine in MS Query ...
MS Query:
SELECT VEZAK1.Sifra as [SifraP],VEZAK1.Opis as [NazivP],(Data1) as [Znesek]
,VEZAK2.Opis as [Tip]

region               carrier
North
east
west

I am trying to create a query that will determine the elapsed time from a
table.  The table may have up to 4 timeframes.

I am trying calculate percentage from month to month for each client group.
The following query is called "monthbal1"
SELECT LiveMonth.MonthID, Account.ClientGrp, LiveMonth.LiveMonth,
Sum(CurBal.CurBal) AS Total

I have an Excel spreadsheet that has a number of cells where the time value
is greater then 24 hours i.e. 36:58, total number of hours and minutes.
I've imported the spreadsheet into my Access DB and have tried to run a
query against it and other tables I have but the field ...

this is my SQL:
SELECT Portfolio.Portfolio, Sum(Account.FaceVal) AS SumOfFaceVal,
Sum([faceval])/DSum('faceval','account') AS Percentage
FROM Portfolio INNER JOIN Account ON Portfolio.PortfolioID =

I have a table with a "Name" field that contains the First, Last and Middle
Initials and Names in it.  I would like to know how I can split these into 3
seperate fields.  Some of the names have titles with them as well.  What are
the xpressions that i need to build in order to ...

I have this small SQL statement, that says, clear any checkmarks from the
indicator field, in the MasterTbl, where vendor and department = the combo
boxes.  (which works fine).  But it's the last line of the SQL that isn't
working.

Lane                     Transport amt
A                             560
A                             890
A                             560

Every time I create labels from my Query it omits all numbers (street
numbers; apartment numbers and zip codes). The street numbers are in the same
field as the street but it just omits the numbers.  Some apartment numbers
have a letter as well and it only displays the letter not ...

I am running the following query with three parameters  that I enter from
combo boxes  in a form:
SELECT tblPROJECTS.Region, tblPROJECTS.Status, tblSUBJECT.SubjectName,
tblPROJECTS.Projectsymbol, tblPROJECTS.Title, tblPROJECTS.Budget

I have a linked table that I can not adjust. In order to make the adjustments
I need I am using a Make Table Query. There are several fields such as [Last
Name] where the text is a varity on Capatalized, Non-Capatalized and a mix
and match of the two. I tried:

How do I write a function that will give me the number of Mondays that occur
in a given month?

I am not sure to use the replace fuction on this. Please help me.
I have three columns 'lblcode', 'prodcode', 'packcode'
They contain this data:
023443 2343 34

I am trying to do a DMax with 2 criteria. When I put in a constant for the
first criteria ('7000'), it works correctly. When I try to use a form object
value ( 'Me.Market'  ) I either don't get anything or an error depending on
my syntax. Any help!