|
Date - Beginning of Month Hi, simple one - I need to calculate the date of the begining of the month for the date Post Date which is in another field of the query. Tried this - Date("01",month([Post Date]),year([Post Date]) and variants of this expresson but no avail... month([Post Date]) and year([Post date]) both work and return ... 6 Jul 2008 02:47
Duplicate entries in a query Hi. I don't know if I can explain what I'm trying to do. Maybe I'm over my head. I've got a car club database. One table is name/address information. Another table is year/make/model information. The third is the joining table, putting members and cars together. Some members have no cars. Some members have mor... 5 Jul 2008 13:32
charts not populated on replica's on my pc or replica pc ,this is access 2007 saved as 2003, charts come up ok on master automaticly, but not on replica's. Any help, thanks in advance. Al ... 4 Jul 2008 15:08
Formatting a Number in a Query Field All, I have a field value that is formatted currency. I need to format the field in a query to have leading zeros and retain the decimal values without the decimal. Example: Field A= 137.19 I need to convert it to 0013719. I've attempted to convert it to a string and format it to"0000000", but that just... 4 Jul 2008 15:08
Query Too Complex I have nested queries that when run on a local table runs correctly. When I switch the first query to use ODBC tables I get query too complex. If I run the individual queries (in the nest) they work all the way to the very last one (that the report uses). Other than the ODBC connection the difference is local t... 4 Jul 2008 16:09
most close return I would like have a query or method to get most close value like following: Code Value A+ 95 A 90 A- 85 I would like to have the query return A+ if value is greater or equals than 95 and return A when the value between 90 and 95. Is it possible to have a quer... 4 Jul 2008 17:11
Help to select record by checking multiple child items Hello, I have a table consisting of student names linked to another one with the date and status of passed tests (one to many relation). It does happen that a student passes after the 1st test or needs sometimes to take it several times before succeeding. We have something looking like: Student 1 - date 1... 4 Jul 2008 13:05
How to look-up ID# In my query I use the following to look up a case number which is really the Auto Number ID: Like [CASE ID#] & "*" However, when I look up record 28, it finds all of the 2800s and not 28. Any suggestions? Thanks, John ... 4 Jul 2008 16:09
Simple update query question I have a table containing city names. They are all in uppercase. I'm trying to use an update query to change them all to proper case (first letter upper, the rest lower). What do I put in the update to: field of the query to achieve this? TIA KM ... 4 Jul 2008 12:04
Really weird query responses. Right, this has been confusing me for days now and I have thrown in the towel and need to get some advice. I am getting some really weird results from a query. The background: I have a table that amongst other fields has fields for the total annual spend in years 1,2 and 3 of a contract. All the fields are in... 4 Jul 2008 07:57
Subtract positive number from negative number I have a query similar to this: SELECT Sales.ThisYear - Sales.LastYear AS SalesDifference FROM ThisYear, LastYear; This works fine if they are both positive. However, I have an instance where the sales for this year is negative and last year is positive: ThisYear: -80,000 LastYear: 20,000 Result in Acces... 4 Jul 2008 05:55
Query Join on Multiple Field Indexes I have one Table with a 2 field Primary Key. A second Table has a 2 field Index. Each of the 2 fields is defined the same in both Tables. I want to Join the two Tables in a query on these 2 fields - one a Primary Key in one Table, the other a 2-field non-Primary Index (known as a Secondary Key in other databas... 5 Jul 2008 13:32
Can you create a table from the output of a query? Using MA 2007 ... I would like to create a new table from the output of a query. Can this be done ... if so how? Thanks Bob ... 3 Jul 2008 20:44
Record Count This is a field in my query Field Eligibilty Date: DateAdd("m",7,[Start Date]) Table Total Expression Sort Show Yes Criteria Format mm/yy that returns the following example correctly: Start Date Eligibilty Date 01/01/2008 07/08 But what I dont know h... 3 Jul 2008 19:43
Ranking (tried a solution by John Spencer, but didn't work) This is my current table "allunitbatch". Want to automatically rank the batch Ids within each MD Batch Id group so it gives the results shown in the Rank column below. Batch Id MD Batch Id Rank APPL-MOM-309-07-01 APPL-MOM-309 1 BANA-HTL-120-06-01 BANA-HTL-120 1 BANA-HTL-1... 3 Jul 2008 18:41
how do i use input parameters with criteria I have a select query which is mainly made up of expressed columns based on "IF" statements comparing the two table in the query then returning a value. I have input paremeters based on a [Warehosue location], [Audit Start date] and [Audit end date]. In which I have identifeid what to return in the event any of... 3 Jul 2008 16:38
query tables using multiple listed values from another table We are trying to set up a query where we have a table with static data that is all located in the same column and we want to use this data as a search criteria for another table. We are NOT linking the tables at this point. The goal is to be able to build a query that will use the static data from table 1, wh... 3 Jul 2008 19:43
Ranking query I've gotten this to work for me, but the sequence is reversed. The entry with the highest # primary key is listed 1st, then down to the oldest. What have I done wrong? SELECT FormalCharges.UniqueID, Count(FormalCharges_1.UniqueID) AS Sequence, FormalCharges.DefendantID FROM FormalCharges INNER JOIN FormalChar... 3 Jul 2008 19:43 |