I am putting together some scripts to run in VB to create an ACCESS database and it's schema. As a part of each table I want to have a timestamp field that...

Hi I am trying to determine how to write a particular query. I have 1 parent record with 2 child records. The parent has neighborhood on it. Each child has a...

Hello. Can Access tell what is the current UTC or GMT time ?. I would like my database to be shared between customers in different countries and I would like...

Hello, I have two tables of data, and I want to test the data in one table against the data in another. Here's the wordy scenario. Telephone exchanges...

I have tried to apply some infromation off the message boards to my Data Base. I have exhausted all the Help from Microsoft office and cannot seem to fix this...

Please help rewriting the following SQL query for MS Access. Thank you. SELECT O.ONE_ID, O.TWO_ID, O.THREE_ID, O.SEQ_NO, O.STAT,

I wish to use a form to show the results of a query between customer and equipment serial no activated by a control button. Then control button runs the...

I have a query which works fine but I want to get the user to be able to chose different criteria. Date()-90 Date()-120 between 17/02/2006 and 17/06/2006 ...

I have a two tables. the first table has a list of all mutual funds for all clients and the recommended replacement along with the effective date. The...

I have written a union query as follows to determine the best location match based from a table of possible gas analyses. The union query should be running...

I am using Office XP or Office 2000 Premium. On some of my compagnys computers, the expression for today, date(), is accepted in a query, and on other...

I am creating a new empty numeric column in a make table query by using the construct New Field:0 This creates a new field in the new table, but it has...

I am trying to create a query linking an existing query and existing table, but it will not allow me to open the query?! I get the error message "Type...

i have an Access2003 database with a main form that has several sub forms. Part of my code writes data to the main form when it is about to close. Below is...

Hello, I am going crazy trying to figure this one out. I have a table with 3000 records. I want to find the price that coresponds to the id number. the...

I'm using Access 2000. I'm studying some complex joins in a book that says SQL2 will do some things that SQL1 will not. Does Access 2000 support SQL2...

I want to Find any record using the ‘Run_No’ as the User parameter, where it will find any other ‘Run_No’ with a matching Keycode for...

I have a file from a customer, who has formated the name field like: "John***Doe", how can I extract the first name and the last name and break them up,...

I am running a sql passthrough in microsoft access 2003. I want to be able to retrieve certain data that meet the criteria I input in the pop up box. How...

Is there an expression that would state that for the Date Field it would be for Current Work Week and then for the Previous Work Week?