Search Result

I'm using Access 2002.

I have a query field set up that references a form, Policy_File_Inv entory, that has an unbound field, BarcodeNumber.

The form has several options related to the BarcodeNumber field. I am interested in what happens when the fourth option is selected. (The first and second selections work fine as is. The third option just displays all records.)

...

I'm new to MS Access SQL and I'm trying to compare data to a table of multiple ranges in order to return yes/no results. I.e.: If this number is between X and Y, do this, else do this. My problem is that there are multiple ranges to be examined. These ranges are stored in a table (let's call it Range), and are all 3-digit numbers:
I'm trying...

I am trying to decode some set data (in codes) to a description. In Excel I would use a VLookup, but am struggling to write the expression in Access. I have built this into a column in a query, but Access is saying that the 'expression is too complex'. Any help on overcoming this would be greatly appreciated.

...

Hi. i want to sum the iif value and i dont know the right way to do that.
i attached the sample data in sum iif(zip file) please help me solve this problem....

I want to create a function like IIF in Microsoft Access. But SQL Server 2000 do not have boolean data type. Someone told me bit could be alternative.

The question is, if I define function like:
create function IIF(@boolexp bit, @tv sql_variant, @fv sql_variant) ...

I could

SELECT IIF(COLNAME*3, 'T', 'F') FROM TABLENAME

but could not use

SELECT IFF(COLNAME > 3,...

Hello! (MS Access 2007 form)

I have three yes/no (check box) fields for registration:
1. Full year (Sept-May)
2. 1st term (Sept-Dec)
3. 2nd term (Jan-May)

Of course, if they register and pay for the full year, I would like the 1st term and second term check boxes to automatically check themselves off. If they don't, I want to be able to check one or the other or both.

I've tried...

I have a customer table (user created and tech support took over) which holds basic customer data - names, address, etc. There is no primary key on this table and no data validations (YET). I have been asked to create a label report that will gather info from table and make labels. Easy to do.....BUT they want the labels to read Mr. & Mrs if the customers are married. There is a field which is home to "spouse name", and a duplicate...

Howdy, I have an Access 2007 database on a Win Vista x64 that is going to help me keep track of donations to my Clan. I currently have 3 Tables with the following Columns:

User - UserID is unique and the primary Key. Medal is a Foreignkey.

UserID | Username | Member | Medal

Donations - Username is a Foreign key

ID | Username | d_date | Amount

Medals - ID is the primary key....

I have what is basically an order form that I am working with. I did not create the form, and I would rate my MS Access knowledge as Intermediate, I do not know VB. The way the form works is that you click a radio button to select the item(s) that you want then you click a submit button at which point a table gets appended.
What I am trying to do is to have a price field that gets update when the radio button is clicked that takes (order...

I'm trying to split a text field ex: (10.00" od x 7.50" id) into 2 fields putting everything before the "x" into one column and everything after into another. I was able to achieve that using the Left() and Mid() functions. But I've run into a problem not all of the fields have an "x" some just have one dimension ex: (3.50" od) and the Mid() function returns that into the 2nd column, I need that 2nd column to...