Search Result

Hello,

I will give a simple example. I have a table [RuleMap]. It has a field called [Rulename] and[Ruletype]. [Ruletype] has entries like Handbook, Guidance and Legislation. Some of the records do not have the [Ruletype] mentioned against [Rulename].

I have designed a query in the Query design view. I do not want to see the [Rulename] where [Ruletype] is Legislation. I have used "<> Legislation" in...

This is the code that i put into the SQL screen.
the data is as follows
BS 1 = 80
BS 2 = 101
BS 3 = 20
BS 4 = 100

and the query asks me for the Blood Sugar Level.
If i use numbers below 80, or 100 and up it works correctly. but if i put in 83,87,95,99, etc between 80 and 100 it shows 0 results even though it should still show the results from above.
what am i missing?

...

Hi,
I have 3 tables in mysql
**User**
---------------------
`id` (auto increment)(PK)
`user_name`
`password`
`first_name`
`last_name`
`created_at`
`modified_at`
`email`

User_Role
-----------------------
`user_id` (PK)
`role_id` (PK)

Role
----------------------
`id`(PK)
`name`


The Mapping file User.hbm.xml...

Happy Halloween all,

I have been struggling at work with a DLookup using multiple criteria. I would like a text box to display the results of a DLookup based on the values selected in three comboboxes and the table that runs them all. Here is my code:

...

I have a query that has two date fields. One date field is from the Request Table and it is called RequestDate - the date the employee requested training. The second date field is called ClassTaken from the Enrollment Table - and it is the day the employee took the training they requested. I am trying to create a report that asks the user to input one set of dates for the RequestDate field and a different set of dates for the ClassTaken date fields...

I need help with this task...

I have a form "myForm" which has multiple buttons on it, such as “John”, “Tom”.. etc, I have one Report "Parts Report" and Query "Parts Query" for that report, Query has a field "Owner".

Case Example: when button "John" is click a report is generated and all entries with [Owner]="John" are listed

When “Tom”...

Hello

I've tried using the MS Access Northwind sample DB and I've downloaded a few other sample Microsoft Access DBs from their website. I keep on running into the same problem for trying to retrieve user input from a query form.

In the Northwind DB, there is a query named "Invoices Filter". In the criteria for the OrderID field in the Invoices table, the following is entered: [Forms]![Orders]![OrderID] ...

To start, here is my DSum expression:
Develop: Nz(DSum("[DB_" & [CSOs].[Name] & "] + [Ben_" & [CSOs].[Name] & "]","CSO","[Strategic Planning]='Ability to Develop'")*-1,0)

I actually have 4 of these, each one with a different option for [Strategic Planning].
For more context, the [CSOs].[Name] part is drawing from a separate reference table which cycles...

Hi

I am trying to tidy up an access database that has traditionally just been used as a spreadsheet. I have split up the information into different tables and need some help transferring information.

I now have two tables:

Client Info - Client ID (primary key), Name, DOB,
Client Address - Address Id (primary key), Client ID, Address 1, Address 2, etc

They are linked (client info)...

Hi everyone,

Thanks in advance for trying to help me out.

I have a SQLDataSource which is running a dynamically generated SQL2005 stored procedure. (That is, the stored procedure creates a varchar string and ends with an exec(@string) command.) The datasource is used by a gridview to display the result. The stored procedure gets a number of parameters which set bit values for "use query criteria 1" , "use...

Foreign key from another table, and a primary key from the one being used.

i am still sort of a novice to access programming,

I have “tblMain” with a primary key “tracking number”
“tracking number” has a one to many with the table “tblPend”
“tblPend” has a primary key “RecordNo” and a status check box “status”

Status...