I have a database that I made a small edit to last night on my Vista machine
running access 2007.
The database is on a network shared drive (not ntfs).
The query still opens fine on access 2007, but on my XP machine running

I'm newbie on sql structure and syntax.
And I have this problem :
I have 3 table :
Table_A

I have a table that includes the following fields: AccountNumber, AdmitDate,
and DischargeDate.
I need to build a query that allows entry of a date range (for example,
4/1/07 to 4/30/07) and returns a count of the total number of AccountNumbers

I have spent the whole day trying to figure this one out and am not sure if
I am even 1% successful in my attempt. I have a query with two columns. One
contains start dates (dd/mm.yyyy) format and the other the end date in the
same format. I want a third column to calculate the ...

Hiyas,
I often use select queries in the rowsource for combo boxes to display
people's names.  That happens often in most of the apps I build as I'd think
would be fairly common.

I am really stuck. I have tried this a dozen different ways without results.
I want to take a simple query (Query has date formatted to month and a summed
quantity) and create a running average by 12 month groupings as well as
extend out to 6 months beyond for running average ...

What command would I need to use in order to use a query to only display part
of the field:
Example:
aaaaaa\test

I am trying to create a pivot table of sorts with the following query:
Select   o.Rep, count(o1.Order_Type) as [Quotes], sum(o1.subtotal) as
[Value], count(o2.Order_Type) as [Orders], sum(o2.subtotal) as
[Value], count(o3.Order_Type) as [Invoices], sum(o3.subtotal) as

Haven't had an answer to this one, so I'll try again, I really need some
pointers:
I've got a query that I'm not sure how to develop.
My tables:

I've got this sub-query in Access 2003.
(SELECT tblPanelMbr.PanMbrID FROM tblPanelMbr WHERE in
(tblPanelMbr.Archived=yes))
What I am trying to do is to delete records in a sub-table where a field in

I have a field CMS_STDY_PRD
In my query I want to
1) change the data type to character
and

I am trying to eliminate a double entry that we are doing, one in an access
database for schedules, and one in a FoxPro that we use to calculate our
overtime.  I have linked to the FoxPro and have the query built, but it won't
include any schedule where no one is assigned.  I've ...

I have the following query:
SELECT MROs.[Core Part Nbr], Format([Date Open],"mmm-yy") AS [Month], Sum
(MROs.[Ord Qty]) AS Forecast1
FROM MROs

<=[forms]![searchdialogdate]![EndingDate]
EX 04/01/2007 TO 04/30/2007
I AM GETTING A RESULT THAT IS NOT INCLUDING 4/30/2007

I have a form that used to have a value list combo box that controlled a make
table query to create a report.  I got smart and changed the value list combo
box to a table based combo box.  Unfortunately, my make table query no longer
works.  All it makes is  a table with a blank ...