Hi all, I want to create the following query: 1 | 2 | Sum of 1+2 ----------------------------- 2 3 5 1 5 0 5 3

Hi, I have many items in a database. And now I sort, filter items and give them an order /1-last item/, than I sort these ordered items /1-last item/ with...

Trying to total a field on a report. example: _Field_ $44 $58 $21 Total: I know this must be easy. I know I can do it in the report or the Query (this report...

I'm learning from Access 2000 for dummies and need to have this report done today. I need some guidance. I have two...

I am running several reports from the same query (I change paramaters within the query then run the report). I want to be able to create an invoice number and...

I am trying to TOTAL (or Sum) an already calculated field I've added to a query. It doesn't work to =Sum(field) in the report so I believe I need to do this in...

Hi I am trying to update a table from a query with an update query. The source query is an aggreagate query. My update query is: UPDATE tblEquipment AS...

Hi, I have the following union query. Basically I am trying to merge the two tables. The Tbl_Summary_PO_Details table contains the expected delivery date...

I have several saved queries many which pull information from Memo field. However, only the first 255 character are being retreived, but need them all. Is...

Hello All, Can someone help me? I have 3 tables in an ACCESS 2007 database, SUBJECTS (the parent table), TRACKING (the main table with most of the data),...

I've done a lot of searching and cannot find anything within the forums or access itself that will do this (and my VB experience is limited to writing macros...

Hello all! I have a query to count how many records meet a certain specification, which is then routed to a form. (The count is set to count the number of...

Getting this error message in Excel when creating a pivottable by pointing to an Access query using IIF function. Received undefined function error...

Is it possible to auto size the small table windows that appear in the top half of the Query By Example (QBE) window? My table and field names frequently...

Love the new interface here in the Discussion Groups. Regarding Access: when building a query in design view, I frequently have tables with names longer than...

I have a query with 3 fields: Last Name, First Name, Company Name. If there is a Company Name the Last Name and First Name are null. I combine 3 fields into 1...

Hi, I have a problem with an append query where i need to increment the number in a field by 1 each time, but the field cannot be set to autonumber because...

I have set up a query in Microsoft Access which is linked to our AS400 server. I have created pararmeters within Access which asks for certain fields which...

Hello all! In a form, i'm using DCount("","query1") to count the number of items in a query. Of course, it does not check for unique ID numbers, and will...

I'm constructing a database to track staff workload over time. Each staff member has their own table with one day for each row. There are queries set up to...