I created an XTAB query that shows the class status [student
registration-attendance-] for each class we taught this year. The query works
perfectly, however, when I use the wizard to create a report based upon the
same query, it fails. The XTAB query uses fields in a table ...

Hi all, on one of my forms, I have an ubound text box driven by a query.  My
time text box, current_time is set to Short Time in my table as well as my
form. (Time is entered manually since I cannot figure out how to use an
auto-time that SAVES to my table)

Many thanks in advance for you help.
I have 2 sql from 2 tables:
The first sql is:
SELECT F02_Hato.CodProd, F02_Hato.CodPer, Sum(F02_Hato.CodAnimal) AS [Carga

I am trying to sort a querry by a field criteria.  The field is a yes/no so
there is only the check box.  I want the querry to display only the records
that are checked yes.  I have tried using "yes" in the criteria box, but it's
not allowing it.  Any suggestions?

I'm running into an issue where I have a very large table that had a field
reflecting as text, but I need to reflect as numbers for query purpose.  When
I attempt to change an error is returned indicating not enough memory.  
Any suggestions?  I thought I could convert a query ...

May query needs to return current Year only.
I have a seperate column for the Year.
Is there a code to say: ((InvClosed.Year)=CURRENT))
Thanks

I've got a situation where I need to run a query that pulls data from
two different (but related) tables, and then lists the most recent
date for each entry in the second table.
The two tables and fields are

I have a macro set up that runs an update query.  (macro attached to a button)
I am wondering if there is a way to stop the two dialouge boxes that come up
when the query is run.  I don't want to confuse the users.
Not a big deal if it's not possible.  I will just tell them to ...

I have a table called Customer with a CustID field.  I have another table
called Licenses that has this same CustID field.  We update our Customer
Table every day with new customers.  I want to update the Licenses table as
well.  If there is a new customer added to the Customer ...

I am using a parameter query to retrieve records for a report.  I type [Enter
Group Code] in the criteria row.  I type in 115 when prompted and my records
are retrieved and displayed.  But I want records for Group 115 OR 125 when
prompted.  How do I phrase the expression to find ...

I inherited some SQL that needs to be run.  What is the best way to convert
this to be used in access.  There is a lot of code so I will just include the
first few lines.  Is it even possible to recreate this using a query?
CREATE TABLE PPO_RNKDEPSDS_PHYS AS

I am trying to understand how to use the multiselect list box.  Can someone
please write a basic code for this so I can try and breakit down and
understand it.
I have a field called [state] in a table.

Is there  a way to concatenate fields in an Access query or report? For
example if all other data is the same except one field on multiple records,
can you combine the unique field to create one record like:
Jim likes to fish for trout.

Hello Friends,
Finally I achived Running Sum in Query Table with your guidence. But still
one Problem!!!
Here is my Sql Statement_

My data looks like this:
RunDate       Customer         SoldDate
03/26/2007   ABC                 02/26/2007
03/26/2007   ABC                 03/15/2007