Date Between Problem after changing table
Wed, 17 Dec 2008 21:31:00 -0800
There was a mistake on one table that had 2 fields named DATE and TIME, Date
was using Date() and Time was using Now(). I changed the fields to one
field, named CallInDateTime formatted "mm/dd/yyyy h:nn AM/PM" on the
form it is =Now() it works slick for the form and couple of reports. My
problem is ...
|
Count unique field1 combined with count field2, both grouped and
ungrouped
Wed, 17 Dec 2008 20:35:55 -0800 (PST)
I am using Access 2003 SP3
I have two tables, haema_Patient with PK 'ID' joined 1:many to
haema_Diagnosis with PK 'DiagID' and FK 'ID'. haema_Diagnosis also
records the hospital at which a diagnosis was made.
haema_Patient
----------
PatientID (PK)
haema_Diagnosis
------------
DiagID (PK)
PatientI ...
|
union qry problem
Wed, 17 Dec 2008 18:14:02 -0800
I get an unmatched column error returned on my union qry. The 2 queries in
the union qry have the same field headings and data type in the same order.
One query has 2007 data and the other 2008 data. Any solution to try would
be great - thx.
--
c.t. ...
|
?F?U?b?q?Z ?U?e?e?Z?h?^?h?c?q?Z ?Y?q?f?d?m?`?^
Wed, 17 Dec 2008 17:41:13 -0800
Ç÷ÈWÈUÈYÈlÈUÈhÈr ÈbÈ^ÈcÈiÈh ÈmÈ^ÈgÈhÈdÈXÈd ÈiÈYÈdÈWÈdÈaÈrÈgÈhÈWÈ^Èu
http://sanderswynx.chat.ru
...
|
filling in blank fields with next records values
Thu, 18 Dec 2008 01:20:10 GMT
hihi,
i have a table that looks like this
LotNo Date TimeStart TimeEnd
11111 01-Jan-08 13:30 13:35
11112 02-Jan-08 08:00
11113 02-Jan-08 08:10
11114 02-Jan-08 08:20 08:30
it is understood in my workplace that those blank [TimeEnd] is equal to the
next ...
|
Can a SELECT query join across three tables?
Wed, 17 Dec 2008 13:44:00 -0800
I have a situation with Access 2000 in which I need to relate three tables
together in order to retrieve the appropriate rows. The raw SQL looks
something like this:
SELECT table_1.foo, table_2.bar
FROM table_1, table_2, mapping_table
WHERE table1.id = mapping_table.id
AND table2.description = mapping_tab ...
|
Merge not displaying queries
Wed, 17 Dec 2008 13:36:05 -0800
I'm using Access 2003 and have a merge document set up. I have over 50
queries, but when I merge it's just listing a few queries. I vaguely
remembering doing something a little different to get the merge to display
all the queries--instead of selecting Access Database, it was DDE or
something like that? ...
|
|
|
Make-Table Query - Creating Tables For Separate States With One Query
Wed, 17 Dec 2008 20:56:24 GMT
I have a table with a number of fields of data as well as a state field. I
want to be able to automatically run a query off the master table that
creates separate tables for each state. Ideally, I'd also like the table name
for each of those state segregations to be name of the state. Any help is
appreciated!
...
|
Finding the Date nearest a given date
Wed, 17 Dec 2008 11:59:01 -0800
Hello All
i am trying to find a way of narrowing down to a record where the date is
just one record that nearest matches the date from another table.
this is the scenario, i have products which go under a warranty for a
certain number of running hours. these hours are recorded at specific dates.
these pr ...
|
calculate a variable base on the time entered
Wed, 17 Dec 2008 10:54:00 -0800
I wrote this in vb but it does not work. I don't know what I am doing wrong.
Please help.
If ([time] >= #9:00 AM# And [time] <= #12:00 PM#) Then meridian = "AM"
If ([time] > #12:00 PM# And [time] <= "8:00 PM#) Then meridian = "PM"
If ([time] > #8:00 PM#And [time] < "9:00 AM#) Then meridian = "Eve"
...
|
