I posted this question on the MS Frontpage forum but didn't get any
responses - hopefully here!
I've got a simple DB with 2 fields - one has placenames from a series of
maps, and the second a one-letter code for the specific map on which the

I am trying to append some data from a query to a table, but am running into
some issues.  Specifically I am entering delivery orders into a form which is
updating a table (lets say "delivery") which also uses some data from my main
"customer" table to fill in the gaps (to cut ...

I have a problem in excel when i try to import data from MSSql with
Import
external data: I must use the same condition in two places in the same
query..something like that:

Not sure if this is the correct newsgroup...
I have imported an Excel spreadsheet that has the appearance of a report
(headings, totals, etc).  It imports easily and each column becomes a field
in a table very nicely.  I can build a table stripping out unnecessary

Hello members,
for readability of my users, I need transform a field that contain hours and
minutes in decimal (i.e. 6,83) in hh:mm (i.e. 6:50).
Thanks in advance for help.

Hi I currently have a table with 10 seperate numeric fields, for each record
there can be between 1 and 10 of thiese fields populated (by unique numbers
i.e no number should be replicated twice throughout the whole table).  Is it
possible to get all these numbers into one field ...

I am constructing a crosstab query using the crosstab wizard and I want to
get customer payments by year. However, I do not want the results displayed
by calander year, rather by billing year. (In this case from 1 July to 30
June).

I haven't been on this newsgroup in a while. I'm browsing through your list
of posts, and so many are indicating "No Longer On Server."
What's up? Am I doing something wrong?
Thanks,

I have a query with customer name appearing per order number. How would I get
a count of the number of orders per customer so customer name will only
appear once and the total number of orders will appear instead of each
individual order?

I need a query that will retrieve records if 'r' appears in any one of two
fields.  If field #1 has 'r' and field #2 does not, I want to return that
record.  
Also if field #2 has 'r' and field #1 does not, I want to return that record

If the Nz function is not used in the code below the summation of the field
QtySent is succesful.  If the Nz function is applied to the QtySent field the
summation is still successful.  But as soon as you apply Nz to the
LossedorTossed field the summation fails.  Instead there is ...

I have a query made up of several different queries. The results are a count
so the data displayed is only one record. I would like to be able to add a
"date of visit" field to my query and specify the time period I would like
the data for. When I add this field to my query and ...

I am trying to concatenate a field in a list of records.  I have used the
sample given be Duane Hookom.  When i try to type the expression for a
concatenation i receive an error that says that concatenate is an undefined
function, but when i copy and paste the code from Word, i ...

Why am I getting different query results from these 2 queries:
Select pname, dservice from visits order by pname; returns 13,749 records.
Select pname, dservice from visits where "t" ="t" order by pname; returns
25,620 records.

I'm using Access 2003 but my database has a 2000 format. When I have a
serious amount of records to export, a problem occurs and Access
crashes. This happens when I got more than 500000 records to export.
The data exported in another Access db or csv files.