Queries

Basic question
I'm creating a database to track student tardies. I have one table that contains the student info, with StudentID as the primary key. I also have a Tardies table that uses Date and Period as combined keys, and also has a Remarks field and is joined on StudentID in a one-to-many relationship. I have a query tha... 29 May 2006 10:50

Currency to text
I have a currency field (must stay as cacluations are performed) but I need a query to export the file to another system so it must be a text file and must have leading zeros. Example: I have a curenncy field $156.10 should after query look like 0015610 (7 digit field). I have tried format I have tried Str$ -... 26 May 2006 12:39

Splitting names
Hello, Using Access 97, I do not know VBA, but use the query design boxes fairly well. I have a database where the Name field has the last and first names separated by a comma. The names are of varying lenght so using LEFT or RIGHT functions would not give me a good result. Will someone show me how to split ... 23 May 2006 14:58

Part of the data is lost from a memo field when run through a quer
Microsoft Access 2000 Ver 9 - I have a memo field to allow large amounts of text to be entered. However, when I run it through more than one query the field size automatically reduces to what appears to be 250 characters, thus losing the end of the field. Any ideas? I have had a search round for properties and ... 18 May 2006 07:41

Date field
I have Access 97. I am doing a database for someone. The database is for travelling allowances. He has a Field called serial no. in this field the serial no. is entered month record no. year eg May01/06, May02/06, May03/06. etc and the record number starts at 1 at the beginning of each month. He need a re... 18 May 2006 03:57

Run-time error '3265'
i'm using a2k and am starting to get the error in the heading about 'Item not found in the collection' when i execute the following VBA code. i've read a few questions posed of suppressing error messages in the queries group and thought i'd finally 'gotten' how to pull this off w/o disabling all error messages ... 11 May 2006 11:17

Using a form to select query parameters
I have a database that has several update queries that are used to update price information. Additionally, I have a macro built that runs the update query (that prompts the user for the PO# and price it wants to update) and emails the changes to an e-mail address. Here's the trouble - often times, a user will ... 15 May 2006 18:08

access database
Hi Guys, I have been thrown into this so please forgive me. I have a table called Users. This table contains the following fields: SMTPAddress, Firstname, Lastname, etc.... I have created multiple queries that perform searches on the SMTPAddress field. I now would like to create a query that will count th... 3 May 2006 16:50

Message: Overrun
In Access table, if I retrieve a variable and apply filter, then the sorted variable will be displayed. On the other hand, if I set a equation by combining different variables together for calculation, the value of the equation can also be displayed, but if I apply filter into the equation, the message "Overrun... 20 Apr 2006 00:26

Search Fields As Formatted in MSAccess2003
How can I uncheck the "Search Fields as Formatted" box in Access2003 as a default setting. Users forget to do this at the start of a Search and the search then takes a longer time. ... 10 Apr 2006 10:04