I have a input table as follows: UserName Action ActionTime FirstLogOnTime LastLogOffTime User1 Logon 10:04:24 10:00 ...

I want to limit the number of records showing for individuals with multiple Addresses. Following is my table structure. tblARTISTS tblADDRESS_TYPE ...

Hi Description I am having problems creating an updateable query to base a form on. I wish to have a continuous form displaying various envelopes we hold in...

Table has a field with Date/Time data type ( 09/08/2005 21:45:35 format). I need to separate its Date and Time portions into two fields (Date Field and Time...

Hi I have a query that uses in the criteria section, text boxes from a form text box names on the form values a Name Date From Date To I want the query to...

Table has a field with Date/Time data type ( 09/08/2005 21:45:35 format). I need to separate its Date and Time portions into two fields (Date Field and Time...

I have two tables, Client Info and Client Visits. The first table has general info that does not change so Client info is entered one time only. The second...

Hi everyone: I am trying to put most of my functions and procedures in an external MDE and reference it through the library. I can seem to see the reference...

I have database, the purpose of which is for students to book a date and time for a test. Tests can only be taken at the following days/times and...

Hi, I have a simple table to record a range of jewellery with an image for each variation. The fields are Item, Pattern Number, Stones, Image (Picture)....

Field 1234 Anywhere St #29 34 Anywhere St #345 1 Anywhere St #1 How can I extract the Street Numbers from the above records? I only want the prefix numbers,...

Greetings For a union query of two tables, is it possible to include the name of the table as an additional field for each record, so that I know from...

Hello. I have a union query that returns the correct records. I want a count of how many records are brought back. After moving to a union query I'm having...

I am trying to split on field into three in a query, Redgum QLD 4850 Newcastle NSW 2300 Rye VIC 3950 Mount Victoria NSW 2710 Perth WA 6000 Glenelg SA...

I've used a database for a year, many users adding info to it. I've written many queries and they've worked beautifully. This week I've been getting a "record...

on a continuous form with the record selctors on, can the record selector icon be changed from the asterisk to something a little more application specific...

When creating a query, using the simple query wizard the linking of all tables are done correctly. However, when designing an existing query the tables that I...

Dear All, I've tried to research this question, but maybe my terminology is wrong.... but basically this is what I am after... I have a table which includes...

In palin English, I have a table based on club members and several other fields of numeric data. Some of the fields are numbers, some currency and some text....

I have a database in which I store some date and times. When from Excel I use the MSQuery Tool to return the information it is bringing the date and time back...