I am trying to create a cross tab query with 2 value fields, but it seems
Access does not allow this.  I need to count patient id field and sum
outstanding balance by quarter.
I am trying to create a report that will show number of patients and total

I currently have a field that is strickly a number field which I can
calulate totals, but is their away to have text in it on one day and number
in it  on others .  As an example I might enter "SL" for sick leave and then
the followind day have a number in it. I would like ...

Hi.
How can I transform 23,1875 into 556:30h
I'm trying to use format short time but the result is 12:00h instead of
556:30h

I have the following query which is invoked in a loop for each value of
account_id; otherwise the query is identical each time.
"select * from updates where account_id=33 and update_time >= 343837
limit 1"

1) I have made a select query on a table that shows all records.
2) I can change the select query to a delete query.  I execute the query and
records are deleted.
3) I repopulate the table.

Anybody know how to create criteria that will allow a dropdown list of
options to limit the query?

I have a main table which stores the most recent info of a record with
following details:
Unique_Ref_Num|Status|Dept
1                       | 6       | 1

I have this function in my query: URG_IN:
IIf([MCAUTH_URG_IN]"",N,[MCAUTH_URG_IN]).  The MCAUTH_URG_IN field can be
many letters of the alphabet, but if it is blank I want it to be an "N".  Can
someone tell me what is wrong with this query?

Can you please tell me how I combine 1 numeric field and 5 text fields:
this does not work:
SELECT
CStr([org_unit]+"-"+([ccy])+"-"+([account])+"-"+([sub])+"-"+([prod])+"-"+([cust])) AS [Key]

I have a query that I am trying to pull using "is null" and the query returns
nothing.  I know there are several records with a null value in the field I
am specifying it on.  Any ideas why it won't return any records?
Thanks.

Access 2003.  I've been doing pretty well lately making queiris but this one
for some reason, I can't get.....I have a query that has Vent Start Date and
Time and Vent End Date and Time.  I made an expression but it is giving me
the answer in days.  I need it in hours.  I pasted ...

Each row in a list of items has a number. 1, 2, 3, 4, and so on. The number
is used to sort the list in a report and the user can change the number to
affect the outcome of the sort.
Now a record (number 2, say) is deleted.

I am running what I thought was a very simple query to return records based
on a field called ProviderID.  The data type is text due to the possibility
of id's containing letters, or starting with 0.
When I type an ID in the criteria field on the design grid, for a provider I

I have a database used by several users. The version of Access are
11.6566.8107 & 11.6566.8122. Does anyone know what changed between those two
versions. I have ODBC calls failing in version 11.6566.8122. The error
message is very unhelpful!

I have a table where I have a field where a percentage is saved (budget
percentage).  In some cases, the budget percentage is 0%.
I have the following query:
SELECT qryTSExport.LastName, qryTSExport.FirstName, Sum(qryTSExport.Hours)