OK I hope I can explain myself the best as possible: My data presents it self like this in a table. Always! Several hundred lines. AAA BBB ...

Hi, Sorry for poor title. I have an app with the main table called 'files'. I also have an entities table (read: contacts), and a roles table. The roles...

In the design query grid I want to match the letters "ABC" anywhere in the column 'description'. I could not get instr to work by using: InStr(description,...

I have a field and in the field I want to remove the - symbol where it appears so if the fiels is 1234-5678 what function can I use to make it 12345678...

Hi, I am trying to import Excel sheet into Access but I encounter with a problem in ZIP code field. Even through I set ZIP code column with ZIP format in...

I am getting the following error message when I try to run a make table query. what could be causing this? Invalid argument. (Error 3001) You tried to...

I am trying to write an archive for an Access 2002 database. To make this simple I'll explain my problem as if I am working with 1 table. I use a make query...

Query SELECT tblStaff.StaffName, RandomDateInRange(#1/1/2001#,#12/31/2001#) AS DateOne FROM tblStaff GROUP BY tblStaff.StaffName; Module Public Function...

I have a form that keeps track of updates made to another table. However what I would like is to update the other table with the changes. Example I have 1...

Hi, I'm having problems with a form for registering worktime activities. A user can enter several activities on the same date. In a form, I want the user to...

I'm currently the database administrator for a relatively small (less than 100,000 entries) database. Currently in our field_samples table we have our unique...

I'm having trouble with a pair of multilist boxes. The first (NameListBox) provides parameters for a query that updates on click. The second multilist box...

I have the follwing text in a table. 10 100 1000 I would like to format the data to output as displayed below. Zero fill, 5 characters not including the -,...

After a join, database has numerous occurrences of a number. I would like to count the number of occurrences of each number in a frequency table and if there...

I am using the InStr function in combination with Left to split up a name field - as follows: FName: Left(,InStr(," ")-1) This works mostly except if there...

How can I modify this part of my query's where statement: ((TblAssyShipments.DateDueSubQty) (Forms!FrmAssyStatus2!TxtOldest)) to work so that no filter...

Hi all, I have a query set up for my report that is supposed to return all records where the Admit Date is before or equal to the selected date, AND the...

Hello, I have a table that has the students firstname, lastname, and 40 different Yes/No fields of courses. If a student completes a course, I put a...

Hi again, I have a situation that may call for either a multiple nested IIF, or a Switch(), or a DateDiff, something else I haven't even heard of. Basically,...

I have a linked database that i am pulling data from but when I try to add a parameter in one of the feilds I get the ODBC error, when I try to run the...