Count using a field of the form and looking into a database

K

Kaiser

Hi everyone,
I am new to this forum and so far I have found a lot of really useful
stuff so thanks!!!
I have a question and its kinda complicated since I am trying to do a
lot of things at the same time. Here is the situation.
I have a form that is used to record activity. Most of the fields on
the form are Dlookups using a contract number. Once the user enters
the contract number, 5 fields do a dlookup on it and fill most of the
form. The dlookup is to a database that is constantly updated. So far,
this has worked perfectly!
I am trying to bring a count field in the database which is where it
gets complicated. I am trying to create a field that counts the ref #
(which is pulled through a dlookup on the contract#) so that every
time the user enters the contract # he or she can see how many other
items are there on the same ref# as this contract #. So if contract A
has the Reference # 1, and under Ref #1, there are 20 other items, I
want this field to show me 20. All of this data lies in the same
database XYZ.
Can anyone help??? I would really appreciate any suggestions you have.
THanks,
Kaiser
 
K

Kaiser

Never mind, I didnt realize Dcount was so easy to use! Thanks again
for all the great help everyone is providing!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I invoice a cost to a custom built MS Access Accounting Database? 0
MS access Form calculation 5
clickable search results? OR show record of record 6
Generate Sequential numbers and letters combined 8
Filter on Subform Not Displaying as Expected 1
Navigation Buttons Cause Error on Autofill Form 2
MS Access setting outlook reminders from a DAO recordset 0
Build search function in to a form 5

Top