My bad. I'm trying to clean up my db, deleting old queries. I'm wondering if there is a way to find out if a given query is being used by any other...

Using Access 2003, I have a Union Select query to combine information from two separate tables. In one of the tables there are two records that in one field...

I would like to know, first, if it is at all possible and second, if so, how to: 1. Join SQL Server 2000 table with an Access 2003 mdb (local) table 2. Append...

I am attempting to sum various sums that are conditional. Basically, sum A + B, where A is: SUM(IIF(="HC ",PCPYAJAM1,0)) AS YTD_PENHW1 and B is:...

i have a query that will return a large number of results (0000's) - but all i really need the total of entries under different criteria. Is there a way i can...

I had write a function in module to get multi value and used it in Query unsuccessful. How am I modify to get "Fax" value using function in SQL. I prefer to...

Can't help but try posting in Report forum aswell. -- Regards Ashley Smart "Raj" wrote: Dear ALL,

How do I code a user form to maximize on open ? Some of my users have resolution on their monitor set so they can't see all objects unless form is open full...

I have a table containing numbers and I have configured it in standard format, i.e. 12345.68 shown as 12,345.68. However, when I transmit the data into a new...

I created a data base table with names and addresses to mail to - I would like to sort out only 4 states out of the 30 I have - can someone help me?Thanks in...

Hi, Short overview of the set up: qry1 retrives data-- acct, sale1, date1(mmyy); qry2_crosstab acct as rowsourse, date as column source, sale1 as sum...

I'm trying to write a query in Microsoft Access database that will give me a random statistical sample from the data in the table. For example I have roughly...

Hi there, I have a nested query. THe first one shows records for date 1 (say July 29). I have a second query that shows records for date 2 (say Aug...

I have a form that has a query named "qry_MemberFirmsView" but this query is not updating the table "tbl_MemberFirmsView". The value is in the query but not...

Hi there, I have two queries that give me the information that i need. I want to join these queries together to have the results show in one query, not two. ...

In a query, I want to display the value in a field if another permission field is yes. Ex: I want to display the email values in a list if the permission is...

Hi all, I have a form linked to an "invoice header". It contains a subform linked to an "invoice line" table. On the subform, I have a couple of calculated...

Hi! Thanks for your help. I'm using Access XP. I've created a query that needs to pull all client/matter numbers. The numbers appear like this: ...

In AccessXP, I'm looking for the proper way to set up a query that takes a number of records (rent and CAM amounts for each of several properties) and combines...

Hello Access Gurus, I have a group of empty fields attached to purchase orders I need to update with the same number. Right now, I am having the update query...