Current datab only query 2 101 (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 structure 0 116 (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 marks 15 169 (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. 3 117 (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 QBE 4 112 (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 novice 1 124 (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. 13 112 (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 VBA 5 724 (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 Data 16 115 (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 year 4 136 (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