Queries

UPDATE query - Macros??? Visual Basic??? SQL??? Help!
Ok so i need to populate a field [Work] with the contents of two other fields in this table [ORGANIZATION_TYPE] and [UNDERSERVED_AREA]. Essentially this is what i need it do do, however i know i can't combine all these together. I probably need to write some code for it, but i've never written any codes othe... 24 Jun 2008 20:34

Export crosstab query to Excel: Decimal problem
Dear John, I'm trying to show 3 year budget comparison. I use qryUnionBud to put 3 year tables together. SELECT * FROM qryBud UNION ALL SELECT * FROM qryBudLY UNION ALL SELECT * FROM qryBudPR; In the crosstab field, I set property to standard with 0 decimal. When export to Excel, it become 2 decimal. ... 25 Jun 2008 09:51

Addition/Subtraction
I am very new using access. I have put together a small inventory database. I have a items table, disbursement table and receiving table. I want to pull the number together into one report. example: Mop -- 10 in stock (items table), disbursed 7(disbursement table), recieved (received table)4 total should be... 25 Jun 2008 16:02

UPDATE TOP value
I am having some issues with selecting the TOP value in an UPDATE query. I am not an expert and I am looking for advice on the best way to proceed. Here is a UPDATE query I am using that works. It updates the PrizeAssigned field to "1" in the Main Table where Weight1 is equal to 200. dbs.Execute "UPDATE Main ... 25 Jun 2008 12:56

forms queries
Hi, I need to create a form which has a button when the user clicks on the button it generates a query and produces a report from info in different tables. I do not know even where to begin, can someone help me? Thank you ... 24 Jun 2008 16:27

Crosstab Query: Column Headings Replicating Fields!
Hi, Here is my SQL view for my question: TRANSFORM Sum(Orders.FreightCharge) AS SumOfFreightCharge SELECT Orders.ShipCountry, Orders.ShipCity FROM Orders WHERE (((Orders.ShipCountry)="France")) GROUP BY Orders.ShipCountry, Orders.ShipCity PIVOT Orders.ShippingMethod; I had tried to do the following in or... 24 Jun 2008 20:34

Access 2003 INNER JOIN
My Inner Join is not working correctly. I have changed it so many times to what should make sense, but my results now fluctuate from 18M records to 0 records! This is what I have: Table1: c.master, c.subacct, c.description, c.custid, c.custdiscount, c.[master/sub discount] Row 1 Data: 911111111, 91... 7 Jul 2008 02:16

Union Queries - Parameter Value Prompt
I would like to combine information from two tables with identical data fields into one. I have used a UNION query. One of the fields contains numerical data (with decimal). When I run the query, I get a popup box asking me for a "Parameter Value". When I run the Query, the same information I put in for the... 24 Jun 2008 13:21

run-time error 1004
Hello, I am getting the following error message when I try to run an Excel macro that is accessing a SQL Stored Procedure via a Pass-Through query in MS Access. Run-time error '1004' [Microsoft][ODBC Microsoft Access Driver] Reserved error (|); there is no message for this error The VB script is as fol... 7 Jul 2008 15:36

Multiple queries vs. one query
I need help. Right now I use three queries with certain criteria in each one to access three versions of the same format of form. It is kind of a nuisance right now because if I make a change to the form. I have to change all three forms as well and now I am using a subform in this as well, which means I am goin... 24 Jun 2008 17:29