Search results

Bob, Congrats on the new job!!! :D

Here's a sample file of what I think you are attempting to do. First I created a query to combine 3 numbers for each record as a string. For each combination of number positions (1-2-3, 1-2-4, 1-2-5, ... , 3-4-5), there is such a query. Also, in each query described above, I use IIF...

Try DSum("number","table1","[name]= 'a' AND " & "[id]<=" & [id]) Keep in mind this will only work for the case where [name]=a. You can use the field value in the query. DSum("number","table1","[name]= '" & [name] & "' AND " & "[id]<=" & [id]) A word of caution, it's not a good idea to use...

bakerratface, Your formula DSum("number","table1","[id]<=" & [id] & "") does the following: - Sum the field 'number' for ALL records in 'table1' where the field 'id' is less than or equal to the value for [id] in the current returned row in this query. See these two articles, they might be...

bakerratface, You can use DSum but it is slower that using a subquery statement. See these two threads: - Running Sum (using DSum) Query to create Graph / Chart (where I learned how to do running totals) - Really Urgent DSUM Problem (in particular, read Pat Hartman's post on using DSUM in this...

Maybe this might be helpful. - Running Sum / Total / Count / Average in a query using a correlated subquery

Whipped up a quick example of using a multiple-select listbox to change a query's SQL statement. Basically I'm changing the arguments for IN part of the WHERE clause. The ChangeQdefSQL() function is not required (you can create your own way to do it) but since I already had something that did...

MiikkaT, Just curious, are you only going to allow up to 3 criteria? :confused: Or are you trying to handle an unspecified number of criteria? :eek: Am I correct in assuming that you have at least three tables; i.e. one for papers, one for keywords, and one for assigning multiple keywords to...

CEH, Glad that helped! :)

How about using the Cdbl() function?

http://www.snopes.com/politics/taxes/sschanges.asp http://www.ssa.gov/history/InternetMyths.html http://www.ssa.gov/history/InternetMyths2.html

Was on Aundair, but since the server merge, I'm now on Khyber. What server are you on?

Maybe this will be of help - Form - Editing Records (Add, Delete, Save, and Undo changes)

Running Calculations (Total/Sum, Average, Count) in a Query

What would be considered a low value? The following SQL shows data from tblData where lngValue = Null or lngValue < 5. SELECT tblData.* FROM tblData WHERE (tblData.lngValue Is Null) OR (tblData.lngValue<5);

I agree with The_Doc_Man that the data is not normalized and it would be better to have it normalized. Learning to normalize your data is the foundation of learning databases since almost everything else follows from how you normalize your data. It was one of the hardest things for me to learn...

Not sure if this is any help but it is worth knowing about. From AllenBrowne.com - Flaws in Microsoft Access: Conditional formatting

There's a site that talks about conerting DoMenuItem commands to RunCommand Terry Wickenden - Converting DoMenuItem to RunCommand I had a thread a few years back that was along the lines of this thread that may have some helpful links. Add, Delete & Duplicate Record

Are you trying to do that for all your tables? Set options for a shared Access database (MDB) Did a quick search and found these KB Articles. - ACC2000: Record-Level Locking Does Not Appear to Work - PRB: Jet 4.0 Row-Level Locking Is Not Available with DAO 3.60

Friday, That's great news!!! Glad to hear that things are looking better for you! :D