Queries

Query result shows all fields
I have not had this issue before with the old .mdb but with 2007 Access , when I am creating or editing a query in design mode, I click or drag only the field names I need, delete all others i dont need, but when I click on the datasheet view - everything else in the tables I used on the query appears - and I h... 17 May 2010 08:01

Determining EVERY month between 2 given dates
Hi everyone, I have a table with the following data upon which I would like to report: SomeDt SomeValue 1-sep-09 100 12-dec-09 200 02-feb10 50 14-apr-10 75 I need to report on this data showing values for all months within the given min and max dates on th... 18 May 2010 08:10

Flag a value in a group...
Hi all, tia for any insight. I have the following query that gives some totals for qty's in a releases table, pulling and grouping information (part number, rev and desc) from a details table. Table heirarchy is (one to manys) tblOrders -> tblOrderDetails -> tblOrderReleases SELECT tblOrderDetails.fldP... 17 May 2010 15:48

Sum using totals
I have a query that I use to sum groups of data... Works great.. However I want to perform a calculaton on the SumOfPayout... All I want to do is subtract 2 from the tolal.. IndexID IDStudio StudioID EpID ShortName Description Start End PaySumOfPayout12 8 LATA-010 Lata10 SF Period Payout 20-Mar-10 26-Mar-10 20... 15 May 2010 17:00

Filtering for fields with character
How can I filter for results that contain the charcter "(" ? For example if my fields are: A(2001) B(2004) C D(2055) E(2006) I would like to display results that contain parentheses brackets. I try filtering using the wildcard *(* but it does not work. ... 15 May 2010 13:44

Emailing a form created from a query
I am using Microsft Access 2007 to email a form to individual email addresses so they can update their details and email it back to me. The form was created from a query as the information is in more than one table. However when the recipient gets the email the form is blank and no longer contains the informati... 14 May 2010 23:45

Access 2007: Need more info on 'concatenante fields'
Beginner in Access 2007. Question related to queries: concatenante fields. Does the expression results show in forms? Also, pre-existing lookup data type in tables, when creating a query for the lookup data, will added data automatically be udated in the form selection drop-down entry box? ... 14 May 2010 20:31

Find Duplicates Query Wizard Question
After using the duplicate wizard, what is the next step? Do I manually select the records individually and manually delete each one while the query is opened? Thank you! ... 14 May 2010 16:08

Limiting Records in an Update Query
I have a report that generates assignment sheets for exhibitors who have received booth assignments so that the orders can be updated (for various reasons, we don't want the sales staff updating the orders directly). There is an update query that then flags those assignments as printed so that they are not pri... 14 May 2010 17:14

Date Question...
I am trying to create a query to give me the results from the first weds of each month back to the following day after weds. Having trouble formatting the Date function. Any help would be greatly appriciated. Thanks David ... 18 May 2010 08:10