access 2003, I have a query with 2 tables, Payable and Vendor, 4 fields "Vendor_ID", "Total_Amount" and "Invoice_date" from the Payable table and "Name" from...

Dear all good day.... pls help me here. I have created a table d1 d1 fields ac_no cust_name addr_1 tel_no now i have created a form with 4 textboxes...

I am trying to create the "ComboField". The field is composed of Date, Left 4 Characters of DealID, and PhaseID. Can someone show me the sql for doing...

I am baffled by this problem. When I execute an append query in vba by the db.execute strSQL, dbfailonerror command I am only getting 76 out of the expected...

I have a "New Start Time" in my query that is calculated from "Est Run Start" Est Run Start = 10/27/2009 6:45:00 PM New Start Time: FormatDateTime(,2) =...

I have a union query in two pieces. One piece deals with payments by cash and checks, one deals with payments by credit card and wire transfer, all per...

I need to know when a specfic count is zero. However, when I use the 'count' function, if its zero, I simply don't get anything. I have no sceond table, so...

I have a question which probally has a simple answer but I am a bit stuck on it.. I have a table which stores quite a bit of data over a long period of...

If my row heading in my crosstab is the months of the year, how do I sort them so they show in calendar order and not alphabetical order?

Hi, I have the following queries, is it possible to place one inside the other (sub query) Test1 SELECT TableC.PID_No, Trim() AS End_Date FROM TableC GROUP...

I thought I read a cure for this but have forgotten what to do. Macro open form displays 'Data type mismatch in criteria expression.' Action failt showing...

I have two tables, one with Transaction Data and the other table has Client Names. I need a Dynamic Counter Function that is based on a series of Select...

Hi, I have a user database as shown User Score u1 1 u2 2 u1 4 u3 7 u2 1 u1 6

I have a table where the values in the first two columns, BranchNumber and ReferenceNumber, have only been populated when they change. I want to create a...

Donde comprar cartuchos dsi, comprueba esta pagina web www.cartuchosdsi.es donde estan los distribuidores de r4i,ezflash y m3i...

I have a form that I use to filter a query. I'm having trouble with this: !! is a fixed/0 decimal formated combobox that queries the fixed/0 decimal numeric...

Sorry, but I don't even know how to ask the question so my web searches have been unproductive. I have three...

am trying to create a querry to use in making an invoice following is the querry in SQL view SELECT Challan., Challan., .CompanyName, ., ., .Price,...

I'm trying to run a single query that will give me the count of records in each of three one-to-many tables. The first table consists of claims, the second...

I am looking for SQL to rank the following data based on premium. Highest premium = rank 1 and so on. Any ideas? Policy Key Company Key Total Vehicle...