I have a complex query that serves as a basis for joining to a table whose fields need to be updated with values from fields in the complex query. Trying to...

I'm building bonds coupon-payments cashflow. My DB has NextCouponPaymentDate (NCPD), LastPrincipalPaymentDate (LPPD) and CouponFrequency (CF) (1,2 or 4 times...

I'm using a local copy of a database at the moment, however the same problem occurs with the network copy: Since yesterday, anytime i run a Query that has...

Hullo - I'm using access 2003 working on a database saved to a 'shared files' folder networked with another computer. Having created several parameter...

The simplest things can be the most confusing sometimes..... Trying to run what I thought was a basic update query. UPDATE zTempCB INNER JOIN ON...

I have a report which produces an alphabetic directory of names. is there a simple way to insert a record along the lines of "Wife's last name, see other...

I am trying to creat an update query that will take the decimal portion of a number and multiply by 60, then create a new field with the result. Everything...

I have an unbound form created to run a query/report. I have a combo box that selects the department to be queried and I want to add "All Plant" to the list...

I'm trying to supress those warning messages everyone else is annoyed with too, but I don't have the "setwarnings" option in the pull down menu of the...

Hi all, I have a start time (HH:MM), a duration (decimal) and a finish time Finish: DateAdd("h",,) Eg If the start time is 13:00, the duration is 1.5 the...

Sorry; not sure that's even a real word, but it expresses what I'd like to get at. Suppose you run a trucking company. You keep track in tables with...

Hi, Although I have a few books on MS Access I have not come over any topic that discuss the aspects of speed when creating queries. For example, in my case...

Hi, I am pretty familiar with Access, but not with SQL, so I wasn't able to try any of the solutions offered in other posts. My user has a database that...

I need to learn more about creating queries in Access and I'm wondering if you all would recomend this book? I need something easy to read and understand. I...

Thanks in advance for your patience, I have basic Access skills, but don't know how to search the help menus and forums for this issue. Suppose I have one...

This might seem a bit absurd in the context of SQL, but I'm wondering if anyone has felt the need to "step through code" in a manner similar to that which...

Folks, I've got a query which accesses 2 tables. One table is a list of Daily Orders. The other table is an Index of Item Codes (primary key is the item #,...

I have a list of Company Names in the CompanyTbl., sush as AAAA, BBBB, CCCC, DDDD, EEEE, FFFF. The CompanyPartTbl keeps track of a PartNumber and the...

I have a table with two products (currently) "petrol" &...

Hi how can change the "sumof" in the access chart into simple average? for example, i have 3 students and I'm trying to calculate their success rate in terms...