I have a crosstab query and I want to make sure it only queries data
from a single year. I have a column that is set up mmmYYYY (this
column in the table is a TEXT column). I want to use that column to
query only the data for a specific year. This is what I have tried and

I have a problem a query in Access 2003 yields both fieldnames thats
are both prefixed and unprefixed. Is there are setting that make all
fields prefixed?
BR

All I want is a basdic contract form

I have a raw query which will show the following data:-
PartNumber Invoice Quantity
1115 INV1 10
1115 INV1 10

I've got a table downloaded from a company's MRP system but I need to have a
3 letter code to identify the company which is the first 3 characters from
the company name field. I created a query and used the Left function to
create this. However, when I tried then to create ...

I have tried a few different things to try and get this to work, but I
can't seem to figure it out. Basically, I have a form with some text
boxes linked to fields on a table, and I want one of two things to
happen (the first one would be preferred, but if that's not possible,

In Access 2003, I am trying to get multiple results in a query using Count
with the same column and table as my source of data. So far I have been
unsuccessful in bringing two results of Count onto a same query.
For example: I have a list of amounts paid to different employees in ...

We have two systems that need to queried on. One is in MS Access 2003 and
the other is in SQL Server 2005. We have Long Integer ID fields in the SQL
Server 2005 to allow the link to Access.
I'm having a real tough time trying to create queries in Access using SQL

SELECT RecordDate, RecordType, Sum(HowMany) AS [Num]
FROM qrySummary1
GROUP BY RecordDate, RecordType;
This query refuses to do the grouping. Is it because one of the columns is a

Helo all,
I am having problems getting some data into the format I need. I'm
wondering if this is even possible actually. I'm sure it is, but I'd
prefer to keep things simple.

Hey is there a way to track and measure run times of queries?  I have a
boatload of queries and sub-queries running that I'd like to benchmark and
see if I can streamline.
Thanks,

Good morning,
I am attempting to use the following in a query:
Score HousCount: Val(IIf(IsNumeric([SPM Housekeeping].[Score A]),Count([SPM
Housekeeping].[Score A]),0)+IIf(IsNumeric([SPM Housekeeping].[Score

Ok, This is going to sound really bad but here it does,
I have tried doing this the write way but i can't figure out so this is the
only way i could think about doing this the wrong way
Queries one returns results

I am try to query a combo box that has list values from Goal 1 to Goal 11.  
When I put the following in:
Between Goal 1 and Goal 3
The data returned is Goal 1 and Goal 2 but also includes Goal 10 and 11.  

I have a table with 5000 records, one of the fields contains first, last name
I want to find all the records that have the same first name.  i am trying to
use the wildcards but am not getting anywhere.  I want to use the parameter
query.  the name will not be the same find all ...