|
|
Vacant Time Slots Query by
Debbie D.
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...
|
|
2 |
146 |
|
|
|
|
3 |
211 |
|
|
Count Unique Records by
BBTMAMA
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...
|
|
2 |
205 |
|
|
date and time by
Jay
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...
|
|
2 |
85 |
|
|
Use wildcard or value from form by
axle
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...
|
September 11th, 2005 10:31 PM
by axle
|
2 |
104 |
|
|
Date and Time by
Jay
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...
|
|
1 |
87 |
|
|
Make an updateable query by
TerryC
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...
|
September 12th, 2005 01:06 AM
by TerryC
|
2 |
114 |
|
|
|
|
3 |
204 |
|
|
Challenging Thinking by
Jay
I have a input table as follows:
UserName Action ActionTime FirstLogOnTime LastLogOffTime
User1 Logon 10:04:24 10:00 ...
|
|
1 |
84 |
|
|
Challenging? by
Jay
I have a input table as follows:
UserName Action ActionTime FirstLogOnTime LastLogOffTime
User1 Logon 10:04:24 10:00 ...
|
|
1 |
93 |
|
|
|
|
1 |
159 |
|
|
Date format in crosstab query by
Matt
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...
|
|
3 |
245 |
|
|
|
|
2 |
85 |
|
|
calculating data from multiple fields by
David
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...
|
September 12th, 2005 10:57 AM
by David
|
8 |
94 |
|
|
Return Top records not Top values? by
Val
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...
|
September 12th, 2005 11:01 AM
by Val
|
4 |
75 |
|
|
Dealing with "almost" duplicate records by
Cheese
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....
|
|
3 |
166 |
|
|
Why is this not an updatable query? by
cvegas
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...
|
September 12th, 2005 01:36 PM
by JohnFol
|
1 |
89 |
|
|
Not Between not working! by
Todd W
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...
|
September 12th, 2005 02:20 PM
by Todd W
|
6 |
80 |
|
|
Repeating an empty query by
EliotF
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...
|
|
1 |
65 |
|
|
Current Expenditure by
Alylia
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 ...
|
|
9 |
108 |