Hi - really "new bloke - knows nothing" question so apologies before I start.......... All i'm trying to do is run a query in Access 2003 that returns a...

In Access query, I have two fields calculating running sum using DSum function. In the third field I try to add the first two fields together. For...

Hi, I tried an UPDATE query on an existing table to populate a new field with the following; "Tag"= & "-" & Format(,"0000") & Format(,"00") but the result...

Hi, I have an database with more than hundred rows and columns Column 1, Column 2 and Column3. I would like to setup new query with DISTINCT function just...

I just been shown how count iif and sum iff work and have promptly messed it up. I have a main form with subform that contain contracts. The back table are...

I have a table with following fields: Assembly P/n#, Unit Price, and Assembler. I want to create a query form that allow me to search for the Unit Price and...

hope someone can help. thought i knew what i was doing but.... here is a sql statment to show the appropriate records for contract. I want the query to...

I have a table (JOBS) that I have details of who does what,where and when. The lead person is selected from another table called LEAD. I want to create a...

I have a query to select records for printing a report. Sometimes I want all the records, and sometimes I want a particular one. To choose the particular...

I have an update statement that uses the IN predicate the exclude a list of values from another table. However, I would like the values to have wild cards at...

Hello I have a Vehicle Database. In the Vehicle Table I have a column where I can select what key # belongs to this vehicle. It is bound to my Key Table,...

hello, I want to add this "http://www.lebans.com/mousewheelonoff.htm" to my 2003 database. I am having trouble figuring it out! I have a few form and some I...

I am trying to group the top 5 values in a query that is reading off two different tables and I am not having much luck. In one table entitled "Stock List" I...

help with this sql select distinct in field in database river school and also if I want to use the criteria row in design query for this, how would it be...

Hi I have two tables: CHARGES (2000 records), PAYMENTS (1650 records) I want to run a query against these two tables which will give me only the 350 records...

Hi all... Using Access 2003 VBA I'm doing a conversion from Dbase and I have set up the following recordset where Lname is the last name being searched for...

Have been away from Access for a few years. I need to create an append query that runs when I add a new record and need to know how to make it take the...

I am using Access 2002. I am writing a query can creates a 'flat' result from three other joined tables. One field is a memo field that contains a large amount...

I am using Access 2003 I have a form employees used to check out equipment. Each piece of equipment is given a number. The employees look up the equipment...

I would like to find the that record of a job " using a "Auto Number" field and all the other info, or atleast the info I need, with that record. Ex. Sometime...