Queries

Using DLOOKUP with totals (aggregate) queries?
I have an totals/aggregate query that looks at a table and returns the total estimated structural engineering hours. I need to convert that SQL code to a DLOOKUP in order to use the result in a computation. Basically I have another totals/aggregate query that looks at a separate table and returns the total actual... 8 Jul 2008 12:04

append to a linked excel table
I have a excel spreadsheet linked to an access database when I try to append a query to the excel table everything seem to work fine but when I look at the table no data has been appended. I recive no errors (I can copy and paste data to the excel table) Anyone know what could be wrong? Thanks octet ... 9 Jul 2008 10:37

Access: problem with outer join - "Join Expression not Supported"
Hi, I am trying to narrow down an outer join, the problem is when I add the condition (compares char field to fixed text) to the where clause I get no results in Access, when I try to add to the outer join I get "Join Expression not Supported". The same query runs fine in SQL Server (but I can not run it there in t... 8 Jul 2008 10:01

filtering in queries
I have a table with a field that is to be formatted as "99999-9999-999" where the N stands for a digit: 5 digits, dash, 4 digits, dash 3 digits. I have purposly not formatted the input field because due to government fiddling, the format may change. However, for the time being, I need to periodically check t... 8 Jul 2008 08:59

Next item in line
I am not sure how to really explain this, but here is what I need. I have a list of items that are in chronological order listing the stages a project goes through. I need to create a query that shows the next item in the sequence. I tried to add a 1 to the id number, but obviously that only gives me a n... 8 Jul 2008 11:03

* Free Library management & membership software *
We are offering our Microsoft Access Library management & membership database 'LIBRARY SOLUTIONS' FREE of charge. To download, please visit our website http://www.base1solutions.com ... 8 Jul 2008 05:55

Nested IIf: Define ranges, >= And <=?
I'm trying to create a commission rate by defining several ranges based on the Sale_Price field's value. I am creating a calculated field in a query with the following syntax (for lack of a BETTER word) ;) Rate: IIf(([Sale_Price]>0 And [Sale_Price]<50,".30"), IIf([Sale_Price]>=50 And [Sale_Price]<=299.99,".25... 8 Jul 2008 05:55

Months are different from days
I have a query that looks at a table with a list of dates, and data. I want to use the query to pull out everything with in the past 3 months (not days like I have now >(Now()-90). I'm trying to understand expressions in Access so an explanation would be appreciated. ... 8 Jul 2008 23:23

Limiting A Query by Using a text format
All, I have a License_Text_ ID field with several different types of license formats. I would like to limit a query to only returning IDs with a format of "LL#######". Where L=Letter and #=Number. I need the query to only return those IDs with this exact format. What can I put in the query Criteria field... 7 Jul 2008 22:47

Turning off "null propagation" when adding fields
I'm trying to add three numeric fields together in a query. Some of the fields will have null values (in this context, the same a zero) from time to time. Because of "null propagation," I get a null sum if any one of the three fields is null. I want the sum of the available field values even if one or more i... 7 Jul 2008 18:41