Queries
in [Access]
|
Need Min Value from Row and Heading Value that Corresponds to it. I have a table that looks somewhat like this w/o the *'d headings: h1 h2 h3 h4 h5 h6 h7 *Min Price *Heading $5.00 $6.00 $3.00 $4.00 $9.00 $1.00 $9.00 $1.00 h6 $3.00 $6.00 $8.00 $65.00 $9.00 $2.00 $4.00 $2.00 h6 $4.00 $9.00 $5.00 $7.00 $1.00 $2.00 $8.00 $1.00 h5 $9.00 $7.00 $6.00 $3.00 $9.00 $8.00 $2.00 $2.00 h7 ... 7 Feb 2010 01:05
Changing existing data in database to title case I have a nonprofit database that I am trying to change cities names to title case instead of all caps. I was sent an empty database that has a an update query that I can run to convert the case in tblCities. I tried to save this database to my hard drive and go through the backdoor privileges to Import the que... 7 Feb 2010 01:05
group query I'm trying to create a query that gives me the average price of each product based on the last 10 purchases. The table is called "t_worksheet", with fields called "buy_price_alt_currency" which represents the price, "processing_grade" which represents the product and "collection_date" which represents the pur... 5 Feb 2010 18:27
Record with longest entry I know this may sound a little paculiar, but I need some help to write a query that will list the record that has the longest entry (textual length - Num chars) in a field. I have a table - tbl_contacts with 3 fields of interest - first_name, last_name, email I need to extract the first_name and last_nam... 5 Feb 2010 16:14
Insert Items from Yes/No CheckBox into Query I am trying to figure out how to dynamically insert results from 20 yes/no checkboxes into a Query. I'm pretty sure it will require VBA and some kind of loop will be required, right; For Each. . .Next Should I add some kind of unbound object frame? Is there a good demo of how to do this online somewhere? ... 5 Feb 2010 17:20
Delete Query Hi, I am trying to create a delete query that deletes records older than a specific date, the date is entered by a field on a form by the user. All records prior to the date the user enters are removed. Within that query, the date and time is part of the primary key field, so I need to extract the date fro... 5 Feb 2010 18:27
Specific filter for the data in a field Hello, In a field there are entries that have the symbol * entered for some reason. For example: DBW*R2 3*FLEW QQ*IF94 How can I filter and find all the data in that field that has "*" entered. I can't seem to find the filter for it. Thanks Dimitris ... 3 Feb 2010 09:28
cursor changes to hand when focus on label Hi , I have a form with different labels, when clicked opens appropriate form to operate... everything is fine in my application, only thing is when the cursor moves to label i want it to show hand icon when focused on label... pls help me.... how to do it.... ... 3 Feb 2010 09:28
query syntax error SELECT [EventsID], [EventName] FROM Events WHERE (([Catagory]=(Event Catagory[EvtCatID]))); The above is what I have in my query builder Events is a fld Datatype autonumber EventName is a fld Datatype text FROM Events iis the Table WHERE Cataory is a fld datatype Number Event Catagory is a tbl ... 2 Feb 2010 17:25 |