reconstruct table that was normalized into several tables
Thu, 11 Dec 2008 14:22:01 -0800
I imported a table into my database and normalized it into several tables.
Now I can't figure out how to reconstruct the original table with queries.
The data relate to procedures done on patients. At a given "encounter" a
patient can have one or more procedures done. So the original table looked
like this, ...
|
Loop
Thu, 11 Dec 2008 21:40:40 GMT
I'm not getting the results I need on this loop. I'm trying to check the
value on each sheet in every workbook, and if that cell on each sheet is >0,
then append a 1 value to a table. The code runs, but no value is assigned to
the MasterTbl
For Each sht In wkb.Worksheets
If Range("AF70").Va ...
|
Multiple Selection in List Box.
Thu, 11 Dec 2008 12:27:01 -0800
I have been reading the threads relating to this item and I think I have lost
the plot somewhere. If I wish to use this functionality in a listbox, will I
have to write a code to do it? If so, where do you write the code, in the
event of the listbox, or in the event of button which then runs the query
after ...
|
How can I append a table and set a date field to a specific date
Thu, 11 Dec 2008 11:26:02 -0800
Not sure I worded the subject clearly, but here's what I'd like to do: I
want to append a table with 12 new records. Each record has a date field and
the new date field would be the first of the month, with all 12 months
represented. Here's what the appended records would look like (the Link
Field column ...
|
sort by last name
Thu, 11 Dec 2008 19:20:32 GMT
I have a field [SetterCompany] ex John Smith. I would like to sort by last
name in a query that is the "Row Source" for a "List Box" I know dividing
the field into 2 fields "[first] [last]" is what should have been done, but I
can't do that now, because they are hundreds of "queries, tables, forms..."
that w ...
|
Parameters
Thu, 11 Dec 2008 11:10:09 -0800
I have a combo box that collects info for a query. How can I get the query
to return ALL records. I basically have four options in the combo box, can I
add an All to that selection or maybe a check box? ...
|
Defining Text field sizes in destination Make-Table Query
Thu, 11 Dec 2008 10:43:00 -0800
when extracting fields from ODBC DB2 tables into access using Make-Table Query
howdoes one define/limit the destination text field size?
Access seems to default to 255 or 50 characters which is problematic on
large numbers of records when the field only needs to be 3 to 10 characters
Keeping blowing 2GB l ...
|
|
|
query for attendance
Thu, 11 Dec 2008 10:27:49 -0800 (PST)
I have an attendance database to record student atendance.
My database data like following:
studentID, Attendance date, Attendance code
1 Dec/01/2008 Absent
1 Dec/10 /2008 Sick
1 Nov/5/2008 Late
I need a query report like followin ...
|
Do I need a Report & Subrept or Can I do this with a Crosstab Quer
Thu, 11 Dec 2008 10:20:01 -0800
I have two queries.
One query (qryInventory) pulls the current inventory levels [current], min
inventory levels [min], and optimal inventory [opt] for a given product model
[product_model].
The other query pulls the each transaction for each product model over the
last 14 weeks. I am then utilizing ...
|
populate an ole table field with pictures
Thu, 11 Dec 2008 09:59:03 -0800
I hope this is the right venue for this question. Sorry and could you
redirect me, if not...
I have a database that tracks student information. My site head would like a
new field that would contain a photo of the student. He wants our guidance
people to be able to save the photos as jpgs to a serverside ph ...
|
