Current datab only query2101 (4/30/2007 3:54:05 PM) I have a query that will be made into a form. The query has all the records selected and inputted by users except for the location field. Oly one user will be inputting and assigning the location field. Wh... Utf
query issues - need to change database structure0116 (4/30/2007 3:25:41 PM) I am having trouble figuring something out and hoping someone out there might be able to help. I have built an Access database for a hospital education department to track education activities that employees h... MES
replacing quote marks15169 (4/16/2007 4:52:46 PM) I need to replace strings that have " marks in them and It keeps giving me an error. I need to delete html tags like so i've been using a replace function that looks something ... Rcarman11
Passing a variable to a select query.3117 (4/26/2007 2:39:07 PM) Hi all, I am trying to select cmr from Customer table and pass this variable [Cust] to a query. When I open the form to select the customer it gets copied into the variable. So far no problem. When the OpenQu... Leo
Please Help: Querying same field several times for a count in QBE4112 (4/27/2007 9:29:23 AM) Hi. I am having no success with a task that I have been given in work. The .csv that is required contains 20 fields and for the most part these fields can be added to the query by double clicking. Where I am... pilch74
SQL Learning for novice1124 (4/29/2007 10:06:35 PM) Can anyone recommend any good reference books for learning SQL. But only as it relates to Access (baby SQL as it's referred to at work). Any recommendations greatly received. Thanks, Jason ... Jay
NOW what! Need help with ANOTHER expression.13112 (4/28/2007 5:50:47 PM) I have an anniversary date for some folks in my contacts database & want to know how long these folks have been married. YearsMarried:=Int((YearsMarried: Now()-[AnniversaryDate])/365.25) I get an error messa... Sue
top N values per group using VBA5724 (4/28/2007 12:24:00 AM) Hello, I am trying to follow an example for finding top N values using VBA given at this link: http://support.microsoft.com/kb/210039/en-us#appliesto I've had success with this in the Northwind example datab... Utf
Trim Data16115 (4/26/2007 2:18:03 PM) I know this may be answered somewhere but I am new at this and need very specific steps. Screen shots also help. I am running a query. In one of the fields "addr: it has information like this example. 236... Utf
Finding records with no entry within past year4136 (4/28/2007 5:22:53 AM) I have two tables [Tbl_Customers] and [Tbl_Orders] these are linked by [CustID]. When orders are entered into [Tbl_Orders] a [Date of Order] field is populated with current date. I am trying to write a query t... bg17067