Description:
Microsoft Office Access newsgroup.
|
|
|
Office 2007 - rename query problem
|
| |
I'm using Office 2007 - Access. I rename a working query. I run the query but it asks for a paramater which has the old name it. For example: "qStreet.field1". The new name of the query name is "qStreetNew". The correct field is "qStreetNew.field1". I renamed it back to the old name and it works and doesn't ask for the parameter. Can't seem to find out why this... more »
|
|
|
iif function syntax problem
|
| |
i have the following expression in the criteria row of my query and it returns no records. can you help me with the syntax? IIf([Forms]![Form2-WAREHOUSE]! [SPECIAL] Is Null,[SPECIFIC-TBL.description ],[SPECIFIC-TBL.description] Like "*" & [Forms]![Form2-WAREHOUSE]![SPE CIAL] & "*")) when my form field is null i want the query to return all the records, but... more »
|
|
|
Crosstab query question
|
| |
I have a question about using crosstab query of course maybe there is another way and any help would be great appreciated. The problem is that the crosstab query is that it uses some type of function(sum, first, min) etc. I need it to just show all the data. An example would be: Instrument Date Result... more »
|
|
|
It takes SO LONG TIME to open a query in design mode
|
| |
Why does it take SO LONG TIME to open a query in design mode? I can understand that it takes a long time to run a query that returns millions of records. But why won't it quickly open in design mode? (MS Access 2003 on Windows XP)
|
|
|
Access query to get monthly and quarterly report
|
| |
Hi, I will require 5 tabs in the report. All reports should be able to use the same result set, but not all columns will appear in each report. They will just present the data differently. for example: if month falls with in the start and end date should show yes otherwise No. Immediate help will be appreciated.. thank you in advance... more »
|
|
|
Link multiple excel files at one time
|
| |
I have about 60 excel files that I want to link in an Access database. Other than manually link each file individually, is it possible to link all at one time? Many thanks!
|
|
|
Group - Combine Consecutive Dates into a Date Range
|
| |
I am attempting to combine all records within a table into a date range. John Doe | 1/1/2010 John Doe | 1/2/2010 John Doe | 1/3/2010 John Doe | 1/10/2010 John Doe | 1/11/2010 John Doe | 1/12/2010 John Doe | 1/15/2010 I would like to see Name | Start Date | End Date John Doe | 1/1/2010 | 1/3/2010... more »
|
|
|
One prompt for Four Queries
|
| |
I have four queries that are used as subreports in a summary report. All four queries use the same prompt (for the same field): [Enter Patient Contact ID] How do I get only one prompt so that the keyed in patient contact id is used for all four queries?
|
|
|
Query <3 years
|
| |
I am trying to query from a query to find how many people have a duration of <3yrs. Query#1 (qrySeen2008) has: ingPtID LastOfdtmVisitDate I need to find out of these people who has a duration <3yrs. I need to use strDoFrstSx from tPtData to do so. So I made another query using ingPtID from qrySeen2008 and added... more »
|
|
|
query a table and subform
|
| |
Help, I have 3 tables 1. Printer table: printerID, ModelID, SerialNum, MACAdd 2. Toner table: TonerID, ModelID, PartName 3. Invoice table: InvoiceID, Date, Qty, PrinterID, TonerID How can I pull up toners based on the printerID in Invoice table? I set the TonerID as a combo box, Could anyone help me with the query that i need. The... more »
|
|
|
|
