Hello all. My SQL view is below. Here is what I have. Two seperate tables that I am trying to bring together. I have created two Queries and what I am...

Is there an easier way to code this for a field in a Query for a report. The field will be in the detail section. Thanks DS If CDTax = 0 And _ CDWhere =...

What command would I use to find the position of the first alphabetical character in a string? Example: 145-54A = 7, 12-54CG = 6. Would use InStr if I knew...

I have an "update table" that I need to update to my "main information", however, I only want the update to happen if the numbers in the "update table" are...

I'm developing a database to store and analyse contract information. I've normalised all the tables and created the relational db and am in the process of...

Hi all, I am receiving "Error 93: Invalid use of null" when trying to run a query with criteria in a certain field; the query runs fine without the criteria,...

Hi, I have a transactional table called SBMSALE2008 that has fields called HPKey (the primary key), PartNumber and another called HPProductLineCode (along...

Hi, I have a table called Products that has two fields: ProductNumber and ProductLine. There are about 2000 product numbers. The ProductNumber is...

I have a single table with two ID fields. The second ID field is a cross reference to the first to show a link between two separate entities. ID1 ...

I have a password form, the code behind the OK button is as follows: Private Sub okbutton_Click() If Forms!.text_password = "fav1m" Then DoCmd.OpenForm "name1"...

Please guys everyone knows about the date settings on microsoft outlook so this fault is alittle harder than that to locate. Emails while in your own...

I am attempting to extract the first 2 digits of a 6-digit number in column CX for a new column. I've entered the following for the query: NEW:Left(,2) but...

In a query, is there a criteria that will count the number of characters in a field... For instance... Show me records w/ less than 6 characters in...

In Query1 I have two fields: CurScore ReqScore 1 2 0.5 3 2.5 1 3 2.5 I would like to create a third field (NewScore) where I count just the values...

How can I add a function to an expression in query? I have the following expression: OPSE Avg All: (Nz(,0)+Nz(,0)+Nz(,0))/CountItems(,,) I created a module...

Hello all. John has been helping on another issue related to this one. Here is the deal: 1.) When I start a new query and bring in one table everything...

I am trying to use an expression as a name of a field in a query. However it is not working. For instance, the expression Format("30/06/07","ddmmyy") comes...

Hi there I'm relatively new to access' more advanced features, like queries etc. and am happy ot supply more information as required. I have 'inherited' a...

jamba handy games downloaden jamba handyspiele fuer motorola jamba handy games 3d jamba handyspiele jamba handy game torrent + +

I have a main form that the user can select a ProjectID. When this is selected a subform displays all the records in that table for that ProjectID. My...