I have a query that include 2 tables as follows: Options Details Product Product Company ...

Hi, I have a main table called "dvd" with unique 105,000 records where DV-ID is my field primary key. I have field called "V_ID" in my "dvd" table that...

Does anyone know if you calculate the 'Domain Aggregate' functions in a given context? If a table has a lot of employee's in it, I only want to count...

Hi, I have a continual form with text boxes, what I need is how to add the value in all text box and show the results in another text box at the footer of the...

I saw an explanation of this somewhere but can not find it the second time. If I want to run a query, for a report, on a certain client how can I get the...

I made a Query by Form (QBF) wich uses Dynamic Query Def. All works fine. My question is: Is it possible to show this query in a form (datasheet) and change...

I would like to update one field in my table with info from another table. I have 3 primary keys. Can someone please help? I am a novice at Access. thank...

I cant seem to get this to work right. I am trying to use an IIF statement in a query and it doesn't seem to work. I want the query to pull information...

I have a database with one line being the sex of the person. I want to count how many people of each sex were input. Also I want to count by age groups hwo...

I have a list of keywords, linked to different documents (many to many relationship). I would like to show in a form the list of keywords and the number of...

Hi, I trying to produce a query where I'm trying to combine two tables - 1 master list of all parts manufactured, price and their code number & 1 list of an...

What kind of expression in the criteria of a date field would accomplish this? I'd like to return related records of a date field where the value is...

hi, does anyone know the query formula that can work out the day from a entered date. cheers fiona

I have got a database of users for a specific software the users have jobcodes GFI for example i need to be able to create temporary jobcodes for a certain...

Hello everyone out there I have a table that has a lot of duplicate entries. It mas mainly two fields an 'ID' field, and a Field_B. Question 1: How can I...

Does anyone out there know how to match the Access system calculation of percentages? The one I'd like to match is the one that is used in the MS Graph pie...

I'm new to Access having only used dBase for my queries sometime ago. I have written the following query how ever it returns no records at all. If I change...

I have a completed form and I need to create a qry. The qry needs to ask for a specific Employee name from 7 text boxes. Please help im lost... Reguards, Chad

Hello I urgently need to modify an old Access application, with no real knowledge of Access. So, I would greatly appreciate help. I believe it was originally...

Hello, I am trying to run a query inside of a query (the results of one query feeds into another). My query1(pteamquerylookup) runs fine and returns a single...