Queries

Crosstab query?
Hello I have 2 tables 1 Members ID FirstName LastName 2. Stats EntryDate EntryType ID -- From the Members Table RefType Amount What I need help to do is create a query that give me the summary (count) for each ID for Each type of EntryType (B, G, R). I can do this using several queries but would ... 26 Jun 2008 17:43

Please need help with query
How do I write a query that say the following: If there is a middle name, then Middle Name and space. If there is not a middle name, then no space. I am trying to concactenate First, Middle and Last Names. But do not want a double space if there is no middle name. Any help will be great appreciated Thank y... 27 Jun 2008 16:16

updating a field with a count
I have a auction database where I have x number of steers, y number of lambs, z number of rabbits, etc. After I get the database in order I would like to automate the sale_order field with the sale number for each animal within each species (so steers run from 1 to x, lambs run from 1 to y, etc). Is there an ... 27 Jun 2008 08:02

calculating currency formatted fields
I have a query in which I am trying to total up 3 currency formatted fields. The 3 fields are Lead, Advance and Close. The fourth column with the calculation is written as: Total: [Lead]+[Advance]+[Close] Instead of returning a total of the three fields it is returning the 3 values pressed together like the ... 26 Jun 2008 16:41

Easy query criteria question
For some reason I can't figure this out. I have two fields in my query (relevant for this question). [Port Num] (numeric field) and [Type] (text). I need my criteria to say that If [Port Num] = 210 then [Type] <> "F". What is the suntax to get this to work in the criteria line of the query? I've tried putting the f... 1 Jul 2008 10:16

Date Groups
I'm creating a report for total sales. The user will enter the date range and time period (days, weeks, months, years) for the grouping. This all works fine. I would like to display a time period even when no data exists. I have 01/08 10 02/08 11 03/08 7 05/08 15 I want 01/08 10 02/08 1... 26 Jun 2008 17:43

Counting in a Query
I've searched, but did not find an answer. I am attempting to have a query count the number of "X"s in 6 fields ([LO1], [CSI], etc.) in another query. These values pertain to US states, and the states are repeated numerous times, with varying values in the 6 fields. Values are either "X" or blank. I tried a... 26 Jun 2008 15:39

analyze a queries with excel
Does anyone know why when I analyze a queries with excel the format changes this also happens if I copy and paste. ... 27 Jun 2008 08:02

Copying data from one table to another
I have a Sales Branch Audit database in development. I have all sales branch information contained in a separate table (i.e. address, city, state, etc.). The Audit Form (which populates Tbl_Audit) uses a combo box allowing the user to select the branch being audited. That value is placed in the SBID field in the ... 30 Jun 2008 11:42

parameter query
I know how to create a parameter query. What I'd like to do is run a parameter query that displays many child records of one parent record that permits multiple parameter entries for the primary key. Can this be done? For example, the query returns: ID (pk) 12345 12346 12347 12348 12349 I may only want... 1 Jul 2008 11:18