I have the following query:
SELECT tblNominals.NomCode AS Code, tblNominals.NomName AS Name,
Sum(qryIdNominals.Nett) AS Balance
FROM qryIdNominals RIGHT JOIN tblNominals ON qryIdNominals.NomID =

Trying to average hours/minutes and I'm getting an error on my query for data
mismatch...I have a query which gives me the orders by Rep in hours/minutes
represented by column i. i: [tti]\60 & Format([tti] Mod 60,"\:00"
Example:

I'm trying to mimic an excell spreadsheet type summary report with a crosstab
query that has a project number in the first row, SumBudgeted Rev,
SumProjected Rev, SumActual Rev in the second row that belong to that project
number and the Columns are Dates in "mm-yyyy" format.  ...

I have a query that includes two expressions(with calcs) named 'SC_amt' and
'Bal_due'
SC_amt: ([Balance]*[Serv_ch])
Bal_due: [Balance]*(1+[Serv_ch])

Hi to all,
on a form I'm filling a "box" (I don't know the english name, is like a
combo without the input selection row) from a table on the same database.
To do that, I'm using the property "RowSource", also to change the ordering

I want to create a field where the nickname is used instead of the firstname
if there is a nickname - but use the first name if there is no nickname.
Here's what I'm working with:
Expr1: [tContacts_2.CFirstName]+"" & [tContacts_2.CNickname]

I have the Group By query below :
SELECT "Price" AS CALC_KPI, tblGroup.GroupName, tblData.Time,
Sum([tblData].[Value]/[tblData_1].[Value]) AS [Value]
FROM (tblGroup INNER JOIN tblRegion ON tblGroup.GroupID =

I am looking for a way to format a criteria line to search for a specific
character within a group of letters/numbers. Specifically, I am working with
17 digit automotive VIN #'s (Vehicle Identification Numbers) and need to
create hits on all VIN's within a table that have a ...

I've recently upsized an Access b.e. to SQL Server 2000.  Most of it is
running great, with very few application modifications.  However, I am having
trouble with one report.  The query that this report is based on is based on
two subqueries (both of which run fine from within ...

Good day
this works fine except but for a vehicle change March 16
SELECT MIN([start mileage]) AS [Start of year mileage],
 MAX([home mileage]) AS [End of year mileage],

i have a query with ten different fields. all fields contain vehicles, e.g.
alfa romeo,fiat,chrysler,etc. i have created a form with check boxes for each
vehicle.
i aim for my query to return data according to the check boxes (usually more

I'm trying to add a field to a query that would find the difference between
two dates and some math like:
Serv_ch:(((( DateDiff("d",Now() - [OrderDate]))/30)-1)*.015)
To derive the number of 30 day intervals from OrderDate to Current date,

I have a table that has a list of Equipment (tblEquip)
I need to search from either on of 2 fields. But only one of the values
may be "known"- I may know the value of Equip or the value of RecvNum
How can I query these 2 fields, I have tried:

I have an access query where I have to import data into an excel sheet
to sort and group information by it's velocity code and percentage.
This is starting to take up majority of my day sometimes. I would like
to have a function where it would rank percetages by the velocity code

On my form, I need to put a button to run a query. When using the toolbox in
the Design View, I use the Command Button Toolbar, then use MIscellaneous,
then Run Query. I select the correct one, and save it to the form. When I try
to use it, I get an error message, and it will not ...