Hi can anyone help with this: I'm trying to use an IIf Between and And statement to work out curriculum levels ie if between 1 and 4 then show '3c' if...

can anyone tell me what this error means and how to fix it? Thanks

Hi there, I have a bit of a problem. In MS Excel, I can easily compute a tiered discount using the mininum and maximum functions. In Access however,...

I have two queries which I have joined through a field. I am trying to delete records from one query based on a criteria. I had accomplished this using joined...

Hi Is there a way to order a table in the same order as the data was entered? I know in Oracle you could do this using rownum, but I have not been able...

Using Access2000, I am trying to use an unbound form to specify the criteria for my query. In the unbound form, I have multiple fields, where any of them may...

I have a database for budget purposes in each record has a "Notes" field for explanation. The data is accepted into the form and table without any problems...

Hello, I am using Access 2000. Can anyone tell me how to specify a criteria in = a query that selects records from a "Yes/No" field that have an answer = of...

Tell me if I have this straight. Setting up a Lookup Column in a field to view the real value versus a record ID is really best suited for the developer...

I have two tables.. The first contains contactIDno (autonumber) and other contact info. I would like to add records to the second table containing mailshot...

Hi, I am using Access 2003 on a XP machine. I have a table with 73,000 records with 4 columns: ID (data type = Autonumber), BIXS_Row_Code (data type = text),...

Hi there, I am hoping someone can help with my calculation error: I am trying to convert a formula into a workable solution in Access but am not getting the...

hello everyone, sometime ago we had notes on this, but are unable to locate them. We have a file with a lot of garbage in it. All we want to do is select...

Hi I have 4 separate tables of which all have fields "Surname", "Forename" and "DOB", plus a data column. Tbl_0 = S | F | DOB (this is all 5 users)

Hello, I have a query that uses a parameter on my form to update a combo box. My SQL: SELECT DISTINCT FROM tblPhases WHERE LIKE("*"&!!&"*"); Here's my...

Quick question, is a UNION queries supposed to return unique values? I have 2 tables, both with an field. When I generate an union query between the 2 to get...

i am trying to do an update of a table with an IIF() statement where if my criteria is true the upade copies the previous record i cannot get the synatx right...

Quick background...2 tables. 1 with all user information including Week1, week2, week3 etc. (up to week 17). Every week, i have to enter a value into that...

I am creating a query , say Query1 in which I am joining 2 queries, say Query2 and Query3. I have joined them on a common field, say Field1. Values of Field1...

I have a form that will be used by 20 users. It has about 50 controls. In order to produce the correct criteria, I need to base it on a query of a query (can't...