Hello, I could use some help on how to count unique Session#.  I've reviewed
several posts and tried to implement those suggestions but wasn't successful.
What I'm trying to do is come up with a way to count unique session#s from
the Sessions table.  Here is my SQL:

Im not a professional user of Access. Im using Microsoft Access 2003. I
have a table without any primary key. The thing I want to do is use
Field1 in Table1 to get the matching data into Field2(Table1) from
Table2. Table2 has Field1 as well as Field2. So like I'll enter data

I have a table that has three columns: Site, temperature, and date. There
are 7 different sites and multiple records per unique site for any given
date. What I want is to convert this table into a table with 8 columns: 1
date column and 7 Site columns (actually temperature ...

I have a query that retrieves a variable  nubmer of records based on certain
parameters.
What i want is to be able to add 5 records to the query over and above the
existing retrieved records that are essentially just blank, although having

When I attempt to perform a group by (either select or crosstab query) on a
field calculated in a previous query, I get a "Data Type mismatch in criteria
expression" error.  I am not sure why this occurs.  I can display the field
fine if I don't have the total line showing in the ...

I am passing several parameters to a function I have created, but I need to
get back 2 parameter values - how do I do it and how do I reference it? eg.
Exp1: breach (a,b,c)
breach will = the return value, but how to get a second value back?

I have a table with dates that have multiple appointment times.  I need to
know how to buid a query that can select the first appointment time for each
date in a selected date range. I am working in Access 2003.

I got a suggestion to bind a query to a blank form, however I donot quite
understand how to do it?
Any suggestions would help greatly

I have the following calculation which comes out wrong due to the us eof NZ.
AvgMktValue:
IIf([AssetType]="Swap",(NZ([Beginning_PAR],0)+NZ([End_PAR],0)+NZ([BegUnrealizedGains/Losses],0)+NZ([EndUnrealizedGains/Losses],0)+NZ([BegAccruedInterest],0)+NZ([EndAccruedInterest],0))/2 ...

I need to create a file with the results from an access table, the file can't
be delimited as it needs to be processed using position number instead of a
delimiter. How do I do this?
Thank you,

Using ACCESS97
Trying to use DSUM for running totals in a query.  I’m not very good with
SQL.  I use the query design sheet.  Read MS support article id 138911 on
this, but I get the same amount  for my ‘runsum’ field. Other than the

I'm attempting to store images as OLE binary types.  I'm pretty confident
that I have the storage down, but retrieval is alluding me.  I can't find
articles on the subject.  I'm using ADO.net 2.0.  Is there a way to
determine the size of the data or do I need to store a separate ...

I've generally had good success filtering continuous forms with combo boxes
using criteria like this:
Like [Forms]![FrmAssyStatus2]![CboOrderID] & "*"
In the above case though, the OrderID field being numeric, choosing '79' in

I have a table that has three columns: Site, temperature, and date. There
are 7 different sites and multiple records per unique site for any given
date. What I want is to convert this table into a table with 8 columns: 1
date column and 7 Site columns, with temperature the value ...

I am trying to set up a column which is generated by selecting from a drop
down list in another. E.g. When  selected in a a table field Country
"Netherlands" it show sautomatically "EUR" in field 'Currency"next to it.
Field "Country" detemines basically what is shown in field ...