QueryToJoineMultipleTables
Sat, 20 Mar 2010 17:18:01 -0700
I have the following 3 tables
Parts1-------*PartStyle*----------1 Style
PartNo PartNo StyleNo
Price StyleNo Description
I am trying to write a SQL statement that would return a record with the
columns below:
PartNo Price Desc ...
|
Days in part of the month
Sat, 20 Mar 2010 16:53:01 -0700
If I have a date ('VisitDate')then if I need to know how many days in that
particular month from that given date, the following VBA code helps:
Day(DateSerial(Year([VisitDate]), Month([VisitDate]) + 1, 0))
If I need to calculate the number of days in that month before the visit
date, how will I write a st ...
|
Fields in a query
Sat, 20 Mar 2010 08:40:01 -0700
I am trying to create a query but when I run it I get the message - query too
complex. Am I limited to the number of fields I can incorporate into a query
or is there a way round this. At present I have over 150 fields. I want to
create a query that illustrates how pupils are progressing and applying
themsel ...
|
DSum in Query
Sat, 20 Mar 2010 08:00:07 -0700
DSum in Query
Hi. I think this is probably an error in my syntax and Iâ??d really appreciate
some help please. I have a financial database that has many Tables, each
table has many fields primarily holding currency data.
I understand from research that it is incorrect to calculate and store a
â??resultâ?? ...
|
syntax for Week number
Sat, 20 Mar 2010 01:25:01 -0700
Hi,
Can anyone help me how figure out a correct syntax for week no.
I have tblRev with fieldname:Date
I want access automatically display the week no. after
entering a Date in my field: Date.
Please can anyone help
Thanks ...
|
E_lookup
Fri, 19 Mar 2010 21:01:01 -0700
E-Lookup ...
|
Help with a partial match query
Sat, 20 Mar 2010 02:36:45 +0000 (UTC)
I asked this question here many, many years ago and have since forgotten
the answer.
I have a table with address data in it, spread over several fields. One
of the fields is called "Zip" and is a text field of 5 characters in
length.
I am trying to write a query that will prompt the user to enter the fi ...
|
|
|
BUILDING UNION QUERY
Fri, 19 Mar 2010 15:45:01 -0700
I HAVE 2 QUERIES FROM 2 SEPARATE TABLES
ONE HAS THE TREATMENT SALES FOR THERAPIST BY DATE
ONE HAS THE RETAIL SALES FOR THERAPIST BY DATE
I JOIN THE INFORMATION FROM BOTH QUERIES INTO ONE USING UNION QUERY. I HAVE
TRIED USING THIS BELOW:
SELECT tblTherapistInformation.TherapistID,
tblTherapistInformation.Typ ...
|
Count
Fri, 19 Mar 2010 14:20:02 -0700
Hi,
I have data based on test results. My data is in 3 tables as listed below
(I'll only listed pertinent data for this action):
Table 1: Time
Table 2: QuestionID, Correct, Value
Table 3: QuestionID, QuestionDetail (for sorting purposes)
I need to be able to count how many times each question was missed, ...
|
Adding lines together to create one line
Fri, 19 Mar 2010 14:18:01 -0700
This is probably very simple but somehow I can't remember how to concatenate
lines, so I have one line. Here is example:
Table: Notes
OrderNo LineNo Note
111 1 aaa
111 2 bbb
111 3 ccc
222 1 xxx
222 2 yyy ...
|
