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 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 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...

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...

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...

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

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

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

Sir, I would like to make a bank statement and having problems in calculation because when i m calcualing it calculate whole field not record wise please help...

I have a crosstab query where the value crosstab outputs a date. I want it to output in medium date format but it always gives the general date format. Every...

Hi, I´m trying to change the column name using ALTER TABLE, but I didn´t find any example how can I do that. Could you help me? -- Robson Previato

ok here is my problem i have the following tables bottle size ( which has its own keys) item which has the field price in it and a drop down menu for the...

I totally understand the method for returning Top N values per group as explained in KB article 210039. I want the last 5 or fewer items bought by each...

One of my tables (originally designed in Excel) has about 17 fields. I have several hundred (or even several thousand) records that differ by one field entry....

All I am trying to do is to change the status of a shipment. I have the status field set to a look up with 3 values in it. Every time I try to change a value...

I have a database setup with street names and valid address ranges (tbl_segme). In another table, I have customer addresses (tbl_unpub). I want to compare...

I have a query that depends on an input box. I would like to add a failsafe to the query so that if the input box is wrong or mis-spelt the user is re-prompted...

Hello, I have query into expenditure data as at month end should be entered. An example of the field format is given below Item of Expenditure Jul 31 ...