Queries

Change field Value using update query
Hi, I am stuck into a situation where i need to update a value in a field of a table. The situation is like this. I have a table "Device" and "tblassignment" with one to many relationship. The primary key d_ID of tbl.device is linked to a_deviceID of tbl.deviceassignment. There is form called "frmassignm... 7 Jul 2008 01:15

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 03:48

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... 6 Jul 2008 08:53

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... 7 Jul 2008 18:41

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