Syntax error missing operator
Thu, 02 Oct 2008 09:38:16 GMT
Hi,
i have a database holding details of tasks within a project, i have a main
form containing some information, unique task ID number and overall job
description and a subform with various yes/no fields relating to the main
task, with the data from each form being held in separate tables linked by a
primary ...
|
Query in access with "*"
Thu, 2 Oct 2008 02:13:01 -0700
Hi,
i would like in a query seek elements with "*G", meaning including the "*"
doesn't of course work with like "*G"
who can help me
fdv
...
|
Passing Parameters to query from drop downlist in Data Access page
Thu, 2 Oct 2008 01:16:03 -0700
Hi,
I have no clue how would i pass criteria parameter to my queries, The input
should be a drop down list on a data access page.
Once i select a particular option from the list this should pass the same
string to criteria which would result in relevant records in following pages.
I know how to to do thi ...
|
One to Many, the many in one field
Wed, 1 Oct 2008 20:15:00 -0700
I have a db with injury info. There is a related table with 0, 1, or more
Corrective measures.
What am trying to do in Access 2007 is write a query that will allow me to
put my basic Injury Info and then put all the Corrective actions in "one"
field so that I can write it to Excel. So
Injury table
...
|
CrossTab: Time Block/interval
Wed, 1 Oct 2008 19:07:01 -0700
Hi,
I am trying to create a cross-tab query with the time that a patient is
admitted to the hospital. however, the Columns i need to have the total count
per hour, and the rows the list of the doctors. the count for each time
interval will be based upon the count(MedRecNum).
Bascially, I am able to create th ...
|
Find difference of records in different fields in the same table.
Wed, 1 Oct 2008 18:48:05 -0700
I use a database to keep track of my mileage for IRS reasons. I am able to
find my total business mileage but I also need to find my personal mileage on
a daily, monthly, and yearly basis. Basicly anytime I want. Date range?
This is how my table is set up that I enter my mileage data into.
Trip Date ...
|
Problem: Slow query design window using linked a tables over network.
Wed, 1 Oct 2008 17:18:49 -0700
Hi folks,
I have a problem of extremely slow query design window open and save
operations.
Same query design that opens or saves more or less instantly when it doesn't
involve linked tables, instead takes 10 to 30 secs to open or save when
linked tables are involved.
Example:
MyDB.mdb is located on ...
|
|
|
Pull every Nth record based on starting value
Wed, 1 Oct 2008 16:38:01 -0700
I am using Access 2002. I have a sorted table and I used the DynamicCounter
logic to number the rows 1 through end of file, as I can not use another PK.
I need to query the table starting from a row number the customer will
supply and then pull every Nth record also supplied. Row number could be
722, 1545 ...
|
Referential Reference to Parent Form in Query Criteria
Wed, 1 Oct 2008 15:43:00 -0700
For the source of a subform, I have a query that has as one of its sources a
second query that is dependent on the value of a field in the parent form.
For example:
The data source for subFormA is QueryA. QueryA depends on QueryB (to avoid
ambiguous join issues, otherwise I would combine them in a single ...
|
Help running 5 queries with same input criteria
Wed, 1 Oct 2008 22:24:40 +0100
I have 5 queries that I run every month into which I put a start date
and an end date. At the moment, I have to run each query separately &
must input the same start date and end date in each. I put them into a
macro, but it still prompts me for the start date and end date of each.
Is there a way that I can inpu ...
|
