hi,
i've got a tabel called customer, which has usual customer details on it.
i've got a home page form, which a text box in it.
i want to display the total number of records in the customer table in it.
any ideas? it should display '2'
so far i've got;
=Sum(tblCustomer!MembershipID)
but its producing an error. its a simple problem, but i caint used access
for ages, and cant remember how to do it.
do i need to use teh exporession builder, or use vb for applications?
thanx
dev
4  1604 
On Sun, 22 Jan 2006 12:33:58 GMT, "DP" <DP@hotmail.com> wrote: hi,
i've got a tabel called customer, which has usual customer details on it.
i've got a home page form, which a text box in it.
i want to display the total number of records in the customer table in it.
any ideas? it should display '2'
so far i've got;
=Sum(tblCustomer!MembershipID)
but its producing an error. its a simple problem, but i caint used access
for ages, and cant remember how to do it.
do i need to use teh exporession builder, or use vb for applications?
thanx
dev
=DCount("MembershipID","tblCustomer")
Wayne Gillespie
Gosford NSW Australia
hi
that worked thanc.
how would i look fro something more specific. e.g.
i've got a field called 'city', how would i count teh number of people, say
from london?
i've got
=DCount("City = 'London'","tblCustomer")
and its saying 2, but there is only one eprson from london.
thanx
devin
"Wayne Gillespie" <be*****@NOhotmailSPAM.com.au> wrote in message
news:n1********************************@4ax.com... On Sun, 22 Jan 2006 12:33:58 GMT, "DP" <DP@hotmail.com> wrote:
hi,
i've got a tabel called customer, which has usual customer details on
it.i've got a home page form, which a text box in it.
i want to display the total number of records in the customer table in
it.any ideas? it should display '2'
so far i've got;
=Sum(tblCustomer!MembershipID)
but its producing an error. its a simple problem, but i caint used access
for ages, and cant remember how to do it.
do i need to use teh exporession builder, or use vb for applications?
thanx
dev
=DCount("MembershipID","tblCustomer")
Wayne Gillespie
Gosford NSW Australia
On Sun, 22 Jan 2006 13:41:09 GMT, "DP" <DP@hotmail.com> wrote: hi
that worked thanc.
how would i look fro something more specific. e.g.
i've got a field called 'city', how would i count teh number of people, say
from london?
i've got
=DCount("City = 'London'","tblCustomer")
and its saying 2, but there is only one eprson from london.
thanx
devin
All th domain functions have 3 arguments
The field to search.
The table/query to search
A where clause (optional)
So -
=DCount("MembershipID","tblCustomer","[City]='London')
Wayne Gillespie
Gosford NSW Australia
i understand. sorted.
thanx,
dev
"Wayne Gillespie" <be*****@NOhotmailSPAM.com.au> wrote in message
news:h2********************************@4ax.com... On Sun, 22 Jan 2006 13:41:09 GMT, "DP" <DP@hotmail.com> wrote:
hi
that worked thanc.
how would i look fro something more specific. e.g.
i've got a field called 'city', how would i count teh number of people,
sayfrom london?
i've got
=DCount("City = 'London'","tblCustomer")
and its saying 2, but there is only one eprson from london.
thanx
devin
All th domain functions have 3 arguments
The field to search.
The table/query to search
A where clause (optional)
So -
=DCount("MembershipID","tblCustomer","[City]='London')
Wayne Gillespie
Gosford NSW Australia This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: beavenour |
last post by:
I am looking for some help creating a more universal function out of
this lame attempt at javascript. I have little experience with
javascript and want to be able to universalize this function. ...
|
by: James Greig |
last post by:
hello people,
i'm just learning javascript, could someone point me in the direction
of an example of the following, or give me some clues as to how it
might be done:
what i would like to do...
|
by: rick |
last post by:
Can anyone help, I am try to create a simple form using a table, where a
user can fill out
quanty and price and have a total automatically calculated and inserted in
another field.
I stuck trying...
|
by: bin_P19 P |
last post by:
the code i have got is as follows and now im stuck
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"
"http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<title>Shopping...
|
by: Samir |
last post by:
Here is a sample form that I just made up. I would like a somekind of
script that when each button is checked or unchecked to dynamicly add or
subtract the total. If anyone can help, thanks alot....
|
by: giancarlodirisioster |
last post by:
Can someone help me modify this for future Usenet archival and to help
me solve what I don't know?
<form name="addform" method="POST" action="./submit.php">
<input type="text" name="Box 1"...
|
by: webguy262 |
last post by:
I'm trying to modify this script...
<script language="JavaScript" type="text/javascript">
<!--
/* This script is Copyright (c) Paul McFedries and
Logophilia Limited...
|
by: Rich_C |
last post by:
I'm sure this is very simple, but I have very little experience with
javascript -- and what I do know isn't helping me here.
I have a simple form where users can enter a quantity (qty) and cost...
|
by: HarisHohkl |
last post by:
Hi, I've this function in a class to update the total value.but when i try to remove the these row highlight in Bold it crash, what should i do????
void display_total_value()
{
double...
|
by: sammiesue |
last post by:
Hi,
I have form with 2 autosummed textboxes ("total" and "casinototal"). I would like to have a grand total textbox ("grandtotal") get its value from summing "total" and "casinototal", but it...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: marktang |
last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
| |
