Queries
in [Access]
|
an ALIAS question? hello gurus I have a Report based on the Cross Tab query shown below: TRANSFORM Count(qryEmp.SiteID) AS CountOfSiteID SELECT qryEmp.SiteName, Count(qryEmp.SiteID) AS [Site Count] FROM qryEmp GROUP BY qryEmp.SiteName PIVOT qryEmp.MtgCode; Each record in the detail section of the report shows SiteN... 22 Mar 2010 13:06
parameter query issue with single date Hello- I have a form that is used to update records in an table. The table has a field called "RecordUpdated" that gets a date from the form when the form record is updated. I used the following code on the forms BeforeUpdate event: Private Sub Form_BeforeUpdate(Cancel As Integer) Me!RecordUpdated = Now() En... 23 Mar 2010 12:30
Query with 2 parameters asks for 3 I want to search on first and last name at the same time, so I have made a combined field called BigName. When I run this query I get a request for three parameters not two. BigName comes up as a parameter. Query1 PARAMETERS mBigName Text ( 15 ), mSuburb1 Text ( 15 ); SELECT Customer.ID, Customer.Title, Cu... 21 Mar 2010 10:30
Days in part of the month 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 strai... 20 Mar 2010 21:05
Help with a partial match query 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 first... 20 Mar 2010 16:38
IIF and formatting i am having problem in building 2 iif in one expression: i have a file called CUR including the following 840, 422,... ect i was building an expression when cur=840 to put it USD and cur= 422 to put it gbp Expr1: iif([cur]=840, "usd", [cur]=422,"lbp") i received syntex error. if i choose only one canges it ... 19 Mar 2010 19:02
left join query is not working I have created a temp table that store ms project plans in an excel format. Each week, I import the updated plans into the temp table and then I then run an update query that updates my master table with the lastest information in the temp table - the join query The problem is that not all the updates are being ... 1 Apr 2010 10:10
Converting a Date I have a column with dates in the format mm/dd/yyyy. I would like to have an additional column the will give me only the month and another only the year, all from the above date column Pls Advise. Thankyou. ... 19 Mar 2010 19:02
dcount in a crosstab query TRANSFORM Count(MyQuery.ID) as CountOfID SELECT MyQuery.Code, DCount("*" , "tblActivityDetails" , [ActivityDate] >= #3/14/2010# and [ActivityDate] <= #3/20/2010# and [ActivityID] = tblActivityDetails.ActivityID) AS Total, Count(MyQuery.ID) AS [Total Elements] I have above DCount in my crosstab query. It seems ... 23 Mar 2010 20:38 |