under what conditions would a query of a set of text values, when made a row source for a combo box,return numerical values (the position within the list of...

I have 3 Queries and want to combine some info to list all employees that do not qualify for bonus #1 Query:EmployeeInfo_qry (this query represents all...

I'm trying to format a workbook from an output query, but for some reason it doesn't fully complete the first time. But anytime after, it runs fine. ...

I was trying to use isdate in a query. I have a field that contains dates, numbers, text, symbols. I'm trying to extract just the records that are dates. I...

Sorry for the double post. I don't see my first one. In any case, I made an error in the first one so... UNEstNtWtNz: Nz(,) ULEstNtWt:...

I am attemping to use Duane Hookom's code to return a list of item numbers and concatenate the equipment numbers where those items are used. The items...

I have a query with a field "payroll" and another "contribution". I also have a calculated field to work out what percentage of the payroll was paid as a...

Hi, I've posted this in microsoft.public.access.conversion already but am unsure of if it might be better answered in this newsgroup. I apologize for the...

Hi, I have two tables. One is my Orders, one is my rejections. The orders table lists all orders that have been attempted, not necessarily filled. The...

I have two databases. One is created using an import macro to import the data from a csv file. This csv file is created from a barcode scanner with part #'s,...

Hi all! I need help with a insert/add query that I created. It calculates well all the fields I need, but when it inserts them into the destination table...

I am trying to total data between two dates and then plot on a chart. Right now I have a query as follows: Start Date / Term Date / Total Sq Ft by North /...

I am constructing a data base for tracking referrals with in my department and have hit a little bit of a wall. Here's what i have to work with. There are 2...

I have the following query that returns what was completed yesterday, but of course on mondays it shows nothing as it only looks for yesterday. I would like to...

Hi, If I have one child table with a relationship between 7 parent tables and I want to use a form to add new records to my child table, would I want to have...

Hi how can change the "sumof" in the access chart into simple average? for example, i have 3 students and I'm trying to calculate their success rate in terms...

Can anyone help me to figure out how to perform a multiple task activity? Here is the deal: "List the book code and title of every book that has the type SFI,...

UNEstNtWt: Nz(,) UNEstGrWt: IIf(Nz(,0)0,Round(+ ,6),Round(+,6)) This returns the "Query too complex" error. I suspect it's because the query is trying to...

I need help performing an exercise in SQL Language, and here is the deal. Customers who are part of a special program get a 15% discount off regular book...

Hi there, I'm new to MS Access... Can anybody please help me with the following issue:- I have a Query table and I need to count the instances of records...