I am helping someone to setup an database in access. We have the tables and forms, reports,queries setup. But on of the query that we are having problems with....

Is it possible to base a report on more than one query? I have two text boxes, each based on a different query. I just used the properties value of the text...

Hi Folks - I have a main table where all the data is kept and several queries with the same data sorted in various ways. The columns in my main table...

I have spent the last several days looking on this site for any help for calculating a 7 day high and 7 day low. I have found many discussions about dates and...

I've tried unsuccessfully, using DCount and a subquery to number records in my query. In a query called "ModelCount", I'm trying to number the records...

I have a query and it is pulling 3 fields, Item, year, qtySold. How do I write the query to show me only the items that sold 0 in year 2004 and 2005? Thanks

I have a duedate and recdate that I would like to know what the days between are I have tried DATEDIF(,, "D") it is unidentified. Help. Mary Lou

Hi. I have a table called tblCustomer and a table called tblSales. My table customer has a Cust_Contact column that has some blanks in it. My tblSales table...

I wish to sum the total employment for mulitple locations of each company. The database has hundreds of different companies. How can I group each company by...

Using a three table join, I am trying to get an aggregate sum of one field from one table and the count for a field in another table in the same recordset. The...

Trying to use = ( \ 86400) & ":" & Format(( \ 3600) Mod 60, "00") & ":" & Format(( \ 60) Mod 60, "00") & ":" & Format( Mod 60, "00") to convert interval to...

This code calculates the age of an entry - but only in days!!!! Counting days it works fine, but I need it to also show hours. Example: 2 hours should show .2...

I am trying to send a daily appointment sheet to my Salesmen. I don't want to send an entire data base, just those appointments for each day. I've tried...

I have monthly sales data for a number of tenants. I want to get a YTD Sum and ad Running Year Sum i.e. June_2004 to July_2005. I have no problem...

We just converted to Access 2003 from Access 1997. I was able to copy and paste criteria into a parameter query when promted. Now I can't get the copy or paste...

When running a crosstab query, one cannot tell ahead of time what columns are going to appear based on parameter criteria fed to an underlying query that...

Hi there, using A02 on XP. Not a programmer. Have a problem figuring out how to get the data I need. I want to find all the contract records I need from...

I want print blank (Nothing) if the value of the field is 0. In my query i have a field Select...

How do I create an update query that updates a table from a query? I have a query that I need one of the fields to update into a table. Can this be done? In...

Hi Can anyone tell me a quick and easy way to pass the results of a query in access into excel to chart data through a DDE link ? I'm aware there is charting...