I have a crosstab query with parameter which works when I open the query
while design my app.
I use the crosstab for my report. I assign the paramter using VBA code at
run time.

I am trying to sort some data in a report. What I am trying to do is for
exemple, I have these datas: 20056, 10048, 60071, 30025
I want to sort in ascending order but from the 4th number, like this:
30025

Why am i getting duplicates in this query?
SELECT DISTINCT DailyData.IntakeID, DailyData.HGB, DailyData.DDDate
FROM qryMinHgb1 INNER JOIN DailyData ON (qryMinHgb1.MinOfHGB =
DailyData.HGB) AND (qryMinHgb1.IntakeID = DailyData.IntakeID);

I am looking for a function to convert a field that is Date Time (mm/dd/yyyy
hh:mm:ss).  To just Date (mm/dd/yyyy).  Changing the format will not work for
what I am looking for.  Usually in excel I would just find month, day, and
year seperately and then combine them again.  Is ...

I set up a query in Access with a where block of:  Model  Like "*470*".  It
runs successfully.  I embedded the same code in a web page and it does not
pull any data.  It works if the astericks are removed and the full model
number is typed.  Does anyone know of any quirks using ...

i have this table :
ID      Course  Detail1 Detail2 Detail3
St_1    Curse1  1       2       3
St_1    Curse2  1       2       3

I am trying to make the DSum work for me, but I am not an expert.  I have
read many posts and still cannot get the DSum to show what I want.
I have a table (tblQty) that has 4 fields:  Item, Whse, Week, and Quantity.
I am trying to create a running total field by week, grouped by ...

Is it possible to do the following?  I've got a table, called 'Cases'
and a table called 'Users'
Within these tables are numerous fields, however what I want to be
able to do is the following:

I have a database with 3 instances of the same field for 3 different records
('Unit Cost').
I want to run a query to show the final cost but I need to add the field
'Unit Cost' 3 times for each of the 3 components in the database.

I am trying to sort some data in a report. What I am trying to do is for
exemple, I have these datas: 10056, 10048, 10071, 10025
I want to sort in ascending order but by the 4th number, like this:
10025

I have a 97 MS Access issue, I need to get resolve. A salesperson goes one
store and spent few minutes for try to sale products and then leave the store
and then start drive for the next store. After reach to the next store,
salesperson goes inside the store and spend few more ...

Ned help with allen browns popup calendar http://allenbrowne.com/ser-51.html
I want to show monday as first weekday, and change color.
In allen website there is this instuction.
To show Monday as the first column in the calendar, change the line:

I have a form with two date fields (DateModified and DateModified2), each
populated with "=Now()" on the click of buttons that trigger other events and
are formatted as General Date (m:d:yyyy h:mm:ss)
Then, I have a field in a query in which I want to return the time elapsed

I have a form with an option group. Allocated, Unallocated, all
In the table/query I have a corresponding field with either Allocated=1 or
Unallocated=2.
I want to report on Allocated, unallocated and All depending on the option

I would like to create a query that will return the (i) field names, (ii)
"data type" and (iii) "description" on any given table (as one can see these
three on a table when opened in Design View). My interest is to have the
data returned on a query and not a report. The Access ...