I have a form where people input invoice data.  Within that form is a subform
where details of the invoice are entered, such as product and amount.  The
main form is linked to the Invoice table.  The subform is linked to the
Invoice Detail table.  The two tables are joined by the ...

I want to set up a select to get the sum of a value but I only want to sum up
the first 5 rows.
Example:
select sum(x)

Can someone tell me what datatype a query parameter should have to
enable a parameter value of "X" or " " (as in null)?  "Text" datatype
doesn't want to work.
Richard

Looking to show the Date in a 2 different text box on my report, If I get
these 2 I will work the rest out
1st Day of this month and the first day of next month 1-Jan -2008 and 1-
Feb - 2008

I have a control with a data source as follows:
=(IIf([chktaxable]=-1,[txtPriceNet],0)
I'd trying to set up another control that would sum this as follows:
=Sum(IIf([chktaxable]=-1,[txtPriceNet],0))

I have been supplied with data extracted from a third party database.  I have
two CSV files for two different tables.  I have also been given an Access
2003 database that the two CSV tables have been imported into and linked via
a query.  The problem is that one of the fields ...

Can someone help me write DSN-Less connection between MS Access and Pervasive
PSQL V9.0?

Is there anyway in which I can run a select query, but only return say the
first ten rows to save time? Running a query against a million records takes
some time and whilst making ammendments I quickly want to review some of the
returned formats (say the first ten).

I have an Access 2003 application that is typically used for large amounts
of data entry in a relatively short period of time by multiple users - all
accessing the same back-end MDB file. I am looking for a way to back up this
MDB file to a different PC on the network on a ...

For starters, I'm nowhere near an access expert, and I am working under
limited time and resources.
I have an access database and i need three other users to be able to access
and make changes to it from their own respective computers (all of which have

Hello.  I have a strange request… I am not looking for any one answer in
particular, but perhaps your opinion on how to deal with the following
situation… and may be how your company dealt with the following:
The company I work for has grown very rapidly, almost to quick.  We went ...

I currently have sort of a search engine form. It has several options that
when selected creates a query on a large set of data. Everything seems to be
in order. Everything is based on my Generate button at the end. When I click
it, it is supposed to open a form with 2 graphs on ...

I have a table that lists names and dates, where each name can appear
several times, each paired with a different date. I would like to make
a query which would list each name in one row, but add the dates
togather into a (horizontal) comma separated list.

Hello,
I have a field which I would like to use the lookup wizard for to generate a
drop down list for the user to select from.
My question is whether my databse would run faster if I used:

I am working on a project that requires me to populate a column with the
exact info from another column. Is there a way that I can pull in the same
value as another column in a table?