I've been having problems with my dates
Could you please help with my date queries?
Day functions are not working. "Pulling the correct information"
Monday
Date()-((((Weekday(Dat e()+2))+3)))
Tuesday
Date()-((Weekday(Date( ),2))+5)
Wednesday
Date()-(Weekday(Date() ,2)+4)
Thursday
Date()-(Weekday(Date() +2)+0)))
Friday...
Dave Smith
Last Activity: Mar 8 '16, 02:44 AM
Joined: Dec 16 '10
Location:
-
HELP WITH min(SERVICE)
I’m looking for some help with my sql.
• What I’m trying to do is ‘his
• Take the Date of Service
• Group all matching Master Account Number
http://files.engineering.com/getfile..._with_SQL.docx
Have sql look at the group of Master Account = Then find the lowest Date of Service in at Master Account group.
So the outcome would look...Last edited by Rabbit; Dec 19 '15, 05:57 AM. Reason: Please use [code] and [/code] tags when posting code or formatted data. -
Thanks Rabbit, That's the direction I would go. -
Thanks Rabbit for responding
My term of Scorecard might be incorrect. I’m looking to build a report with four plus summary reports might also have Pivot tables, charts and wording. Would that be the same as “scoring registration application”?Leave a comment:
-
Can a Scorecard be made in MS Access - HELP!
I’ve been asked to build a scorecard. I have been looking through different forms along with using the Google search and have not found anything that either shows me some examples or ways to make a scorecard or better yet, a how to make a score card using ms access.
Can someone point me in the right direction?
Thanks -
I'v never done a TransferSpreads heet( ) before, Do you know of a sight that would give me detailed instructionsLeave a comment:
-
Thanks Pat, I'll try changed the field1 nameLeave a comment:
-
When I hit debug, this row was highlighted
rst.Fields("Fie ld1") = .Cells(lngRow, 1) 'Get the value from column 1 into Field1
No I dont have a column with those names, do I need to change then to one that I have?Leave a comment:
-
I have a file located in my Documents titled: Testfile.csv
When I run the Module in the database it opens the file but then gave me this message "Run-time error 3265 - Item not found in this collection"
any Idea's
...Code:Public Sub ImportCSVUsingExcel() Dim app As Object 'Excel.Application Set app = CreateObject("Excel.Application") 'New Excel.ApplicationLeave a comment:
-
Thanks everyone for the great advice. This gives me a couple of options.Leave a comment:
-
Importing 340 columns into Access 2010. "How?"
I receive a "Data Dump" that comes to me in a csv file.
Once I open and save it in excel there are about 18000records.
The header row has 340 columns.
This will be a weekly process, I'd like to automate
Needing to import the excel table into access.
Thoughts:
Does anyone have code that will reach out from access to my excel file and import just certain columns... -
How would I call this function Median([Feildname])?Leave a comment:
-
Hi NeoPa, I know you;ve been a huge help already, but now I'm getting the error below?
There was an error compiling this function.
The Visual Basic module contains a syntax error
Check the code, and then recompile itLeave a comment:
-
Please forgive my ignorance. Would this code go in conjunction with all the code above?Leave a comment:
-
NeoPa, you must be a teacher or one in your past life.:0)
I want it to return the median of all records in the field, but the median for all records for a given LoanName
I would guess the formula looks something like this
Code:Median("MyTestTable","w_Ovg_Points","LoanName = ",LoanName)Leave a comment:
-
Thanks NeoPa, could you help my understand what I need to do after I paste the VBA. Thank you soon muchLeave a comment:
-
Help finding the Median using MS Access
I’ve spend the last day researching online how to make access calculate the Median.
I really hoping someone can help me find what I need to do to find the median Number of Loans w/Ovg Pts for each name.
I have also attached my sample database so you can see what I’m working with.
I have found code, but not know VBA I don’t know how it would work
Any help would be greatly appreciated... -
Thank NeoPa. Greatly appreciatedLeave a comment:
-
Thank you both very much. I'll be back if I have any more problems
Thanks againLeave a comment:
-
Thank you Pat, Just the advice that I will be doing update queries for most of the stuff mentioned helps a lot. I guess the Modified and update are the same think so I will only be using one of them. I’m using a formula to get the workstation. Is there a better wayLeave a comment:
No activity results to display
Leave a comment: