I have a report of customer summary: Name, ID, and Reason, Time, and Commnet fields. I want to achive these data in comma separated archived file. How can I do...

Hi, How can i query a table that will select only for those two tields are not equal. ex. Table1 stockno description field1 field2 1 ...

Hi I have a query which will sometimes return sales vales that are blank, so I have used a NZ command to return a 0 instead of a blank result: FD UNITS:...

I need to create a query that will give me averages on a list of numbers. How can I calculate the averages, but ignore 0 or null values. Addtionally if I am...

that when called will generate a random number between 100,000 and 999,999 and place it in a table. code must check this existing random number table to make...

Hello! In order to avoid double entry data, like 'Hällo' that should be concidered the same as 'Hallo' or 'Français' that is the same as 'Francais', is...

I am tryin to create a query that will search through multple tables to locate production informtion. Each Table has the same format and holds producton...

Hiya, I need to run quite a hefty piece of statistical analysis monthly using a whole heap of data. Whilst I'm aware that Access may not be the best tool...

Hi everyone, hope you are well I am trying to write a function that I can use in my query to alocate timeslots. Basically, I have data for each 15 min period...

In the process of migrating Access mdb fe/be to Access MDB fe / SQL (MSDE) be. What is the best method for passing queries to the server? Concatenate the SQL...

Hi gang, I've got a little issue here that is proving to be quite frustrating.. hopefully someone could show me my error. I have a query that is has the...

SELECT MonthName(Month(orders!date),1) AS , Day() AS , Count(orders.id) AS Countid, Sum(orders.amount) AS Sumamt FROM orders WHERE (((orders.paystatus)=1) AND...

need help - want to update a memo field in this way: original table has text in memo field - Notes 2004: xxxxxx secondary table made from this table has...

Is there anyway to set up a Query so that if the field contains a specific word it sends an e-mail to address in another field in the same record? I just want...

I have a table that has our asset inventory with tag_number as the primary key. We have some records of computers that have modems. In the modem field, we...

Sum(orders!amount*0.2) what does the above do?

I need a bit of help with this one. It should be rather simple, however, I'm stuck! writers block, i guess! How do I format this: IIf(IsNull(),Null,CDbl()) to...

How can I check if the third decimal of a number is 0? I know it can't be as hard as I am making it - maybe I have Access burn-out? I am checking (in a...

I have a simple parameter query that returns the sales orders for a particular sales area when promted, how can I get the query to return all orders for all...

It's me again. Thanks now for your help. I am trying to create a query which will allow us to determine the number of filings during a specified period of...