Queries

Query as data source for form
I have data in 3 tables called Carriers, Routes, and Subs. I can make a form display data from one table at a time. But, to access multiple tables, a query is necessary. I have created a query in Query Wizard which displays the relationships between the tables, etc. In Design View, with the Query as data sou... 8 Jul 2008 15:09

Group same records in one field and Total in another
hello, I have two columns in my querie. The first is Expenditure Authority and the second is Trans Amt. Sample data is below. Expenditure Authority Trans Amt. 913020 155565 913020 7555 913020 8844 0A730K ... 23 Jun 2008 19:56

Form queries
I would like to create a form and a report based on PARAMETERS selected by user. Because there are 583 possible selections I would like to make it easy for the user to drill down to the correct parameter value. I created a form with a combo box that has a row source that is a query that returns possible "Building N... 23 Jun 2008 19:56

counter value
I would like to write a query that inserts data into a table based on parameter data. The number of records inserted would be a parameter, but i also want to create a unique serial number for each record, incrementing by 1, starting with one of the parameter values. For example: Parameter item number - ent... 23 Jun 2008 17:53

Using IIF on Exclusive Fields
I'm trying to develop a query on a table that rather than have one column for the day ("Mon", "Tues", etc or "2", "3", etc), it has 7 columns of type tinyInt, one for each day. A Monday item would have a 1 in the M column. A Saturday item would have a 1 in the S column. All other columns would have 0. I wou... 24 Jun 2008 15:25

Insufficient Memory after XP memory upgrade.
Access97 now fails with Insufficient Memory message after a recent memory upgrade from 500M to 2G Removed and re-installed ACCESS and indeed complete Office PRO but seems to have a problem with system.MDW workgroup file re-installed .MDW file from backup and the insufficient memory problem occurs again. Fortu... 24 Jun 2008 03:06

Any execution sequence in Access?
Hello everyone, I wonder is there any pre defined sequence in Access when it executes queries and views. For example, is there any difference in efficiency of the following two queries? 1. SELECT * FROM table1, table2 WHERE table1.date=table2.date AND table1.name like "%A%" 2. SELECT * FROM t... 25 Jun 2008 13:58

Simple Append Query not Working. I do not have a clue why.
Hi, I have one table which is made from a tablequery. From this table I want to add everything to an existing table. The From table: Loadingdate Unloadingdate Pallets Trucknumber DATE DATE Number Text | | | | | | | | The To table: | | | Loadingdate Unloadingdate Pallets Truckn... 23 Jun 2008 18:55

I am trying to exclude pulling statuses into my query
Not In ("Completed"," Canceled") I want to exclude the status of Completed and Canceled from my query. I tried using different combinations of the above line, but it does not exclude them. Any suggestions would be most appreciated. -- Bonni ... 23 Jun 2008 15:49

Find the first value in a crosstab query
I have a crosstab query with YYYY-MM as column headings and cost codes as row headings. It looks something like: Cost Code, 2008-01, 2008-02, 2008-03, 2008-04... 18800 0 0 1.50 1.52 20200 0 0.91 0.95 1.01 36300 1.20 1.22 ... 24 Jun 2008 15:25