I have a volunteer table and a uniform table, they share a primary key of id#. Unfortunately, when I built the uniform table and populated from the volunteer...

Totals Query I created a payroll database that tracks piecemeal work for clients with disabilities. The subreport has fields for calculating their pay. I...

I am going to make myself a bit more understood this time. I have a table with the fields: Name of stock Type of stock Place Kept Supplier name Rating. The...

So, once again for all you who are reading today, I have a form ... frmSales that is based an a qrySales from tblSales, it includes a field "fairdate". I...

I have a table of addresses, 16 in each recordset. I want to create 8 pairs of unique addresses from each record set. for example: Rec No Address 1 A 2 B

Hi, mydata table is sr nos (int+mod) 1 14 5 1 18 9 2 23 5 2 29 11 3 16 7 ...

please don't multipost. for more information, see http://home.att.net/~california.db/tips.html#aTip10. "cliff" wrote in...

hi, I am quite new to access. trying my best to learn. I have small problem mytable is something like this sr nos 1 14 1 18 1 25 2 16 2 23 2 45

I would appreciate any help with creating a query that would identify duplicate rows per address field. I ran a duplicate query made a new table with all...

I have a database that tracks when I make site visits to various job sites. At times one site may require multiple visits. I have one table, with Job...

i need a query to view the dates and report names example: There are Three columns(Frequency, DAY, REPORT)in a TABLE, now my query should give me the date...

I am attempting to amend an existing query which currently only lists the License expiration date for each employee based on "Between xx/xx/xx And xx/xx/xx"...

I have a database table consisting of your basic fields of name, date etc but have 2 fields with Amt Owed and Balance. I have a second table that has...

Hello, I am trying to set up a query which displays a combo box asking the user to select 'the type of item'. the item type is a field on a table i have...

Hello Group, I am attempting to build a search form that incorporates mutliple table fields (~ 20 values from one table) and some of the fields are list boxes...

I have a D-Base with 6 tables, 3 of which (tables A B C) I want the user to be able to delete all the information in. I want this to be to be done using a...

Dears, Please help me with this. I have a table containing about 10000 customers, and each customer has his own CUST_ID. Now I want to make a form...

Dears, Please help me with this. I have a table containing about 10000 customers, and each customer has his own CUST_ID. Now I want to make a form...

Can someone tell me how to create a simple sub query using an existing query??

Hi, I have a query to highlight if I have sent a form to someone and not heard anything back. There is a date sent and also a 'returned' which is completed...