I have a form and report based on a query. I need to change the query based on what the user selects on a form. Using VBA in MS Access 2002, can I change a...

I've merged the results of 2 queries into a UNION query, however I suspect that one of the fields has lost it's date format. The reason I think so is that...

After calculating an average, I need to classify each member as 1, 2, 3, ... 10. 1 = an average of 3.99 or lower, 2 = an average of 4.0 - 4.75, etc. How can...

Im trying to build a form with multiple check boxes that each apply a filter to the records displayed. I need for the user to be able to select any...

Hi, I thnk I am missing something obvious, but I an stuck, and seem to need help getting some fields in a table updated. Table 1: R_BSA_M This has fields for...

Hi Duane, Thanks for your reply. I have been trying to get this to work for a few days without success so I have broken it down to a simple problem. I have a 3...

I am having a problem with the iif statement when I use it in the criteria for a query for a combo box (Combo2) that is based on the selection of another...

Hi Duane, Thanks for your reply. I have been trying to get this to work for a few days without success so I have broken it down to a simple problem. I have a 3...

not mach no find area fridays@don hill ,S?s photos myspace images thnik you

I have a report that groups three fields together, 'conveyor type', 'conveyor name' and 'maint. records'. There are multiple 'conveyor names' and 'maint....

I am using Access 2000 - I have one column of numbers (probably 1000 numbers in total) ranging from 1 to 9 - Does anyone know how I can count the times that...

Hello Gurus, Scenario: I have an oracle database connected thru ODBC. I want to append data to Table- A that has following in it: Col1 (Integer), Col2...

I would like to have the append query create a fixed number of rows based on the value from a field value. For example, field value = 10. I would like my...

i have the following in criteria of a query. IIf (forms!frmarchiveinvoicesoptions!txtacceptedarchivetype = 'wholesale', "N",...

When in query design view on desktop (large screen), I can see the fields and criteria pane in the bottom half of the window, but when in query design view...

the following iif IIf(!!='wholesale',"N",IIf(!!='retail',"Y",IIf(!!='all',NULL))) attempts to place no criteria filter in the query when 'all' is found. ...

Hi, I have the following code to export a query to excel using a command button. It was working well. Now user tells me he can't get it to work. If I log...

Example: I have a query that will count all Active Customers based off Account Numbers (unique). The query when run will obviouslly give me a count but can...

Note that it could be FAR EASIER to have the junction table minimumQty already filled with all the possible articleID, storeID, with NULLs under the qty if...

I have three queries, each building off the previous, and by the final query, some of my number data has been converted to text data, and I need to prevent...