Please assist.
I need to create a crosstab query that will count patient visits
between 2 dates in the table.
dates:  report rundate - visit date

My concatenation code is returning:
"Invalid SQL statement. Expected 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT',
or 'UPDATE'.
Can anyone see the problem in my code?

I am creating a "Round Robin" form (an interactive form that lets users
specify the parameters of a report to be run).
Currently the drop down list to choose from is: A, B, C.   The report shows
that all the records are "A" if you select A from the list box, if you select

I have a query which has will group the majors in the university, group the
city the students are from and count each gender (female or male)
I used
major : groupBy

I am trying to setup a very basic report with a Query from the Order Entry
database template. I am trying to get my report to show a gross total for
each order including freight and sales tax. I have the net amount being
generated by: Net Order Total:

Ok, i'm stumped.... This works:
SELECT TRANSDATE, B.TRANDESC,  A.CARDID, D.FIRSTNAME, D.LASTNAME
FROM (CARDTRANSHISTORY AS A
LEFT JOIN TRANSACTIONCODES AS B ON A.TRANSCODE=B.TRANCODE)

I have two tables.  
The first is tblPeriod which lists months including start and end dates. It
also has an AllocatedNo field which gives every month a number such as P1,
P2, P3 etc.

I have a small test table called 'Flavors'. It has 2 fields:
Field 1: 'FlavorID' and
Field 2: 'Flavor'.
In the 'Flavor' field I have different flavors of ice cream like vanilla,

I've got a report I've built for a customer that runs a query that has 2
parameters which requires the user to input a start date and an end date.  
The query runs correctly based on the user's date selections.  How do I
capture the dates selected as parameters and include them in ...

Can someone please help me design an expression in expression builder
that included "equal or grater than".
The example is the query design has a field called "value", which is
the result of a formula (in the source query), Some of the values are

I have a database that is used to log employee compliants.  A query (Details
Qry) is used to summarize all of the compliants within a specified date range
that is entered by the user.  I am trying to put together a report that
includes a field that identifies the oldest report ...

Order ID Order Date      Ship Date      Ship City   Shipping Fee
1             11/14/2005  11/15/2005   Jakarta     $55.00
2             11/14/2005  11/15/2005   Sydney     $76.00
3             11/16/2005  11/17/2005   Sydney     $87.00

I have been working on this little query for the last week and I just can't
get the solution.
I just hope you guys are smarter than I...
Anyway the question is this:

I have a field "0002222 Catheter". I need to create a table that just pulls
out the 2222. I thought I could truncate somehow?

In MS Access i have a field that i have broken down into 6 constituent parts,
2 of the parts are in kilometers and i want to convert them to Miles and Yard.
Does anyone know of a way of doing this I know how to do this in Excel butt
Access is a bit out of my technical range. any ...