Search results for query: *

Hello all! I have never really worked with Excel arrays but am not unfamiliar with how an array works and think that it is what I need to use to solve my problem. I have a daily report in Excel that is based on daily registrations that I pull off of a web based report. I pull the report each...

Hi! Is there a good way to create a list of target dates for specific deliverables based on a start date and end date? For example: StartDate: 1/1/2007 EndDate: 10/1/2007 Deliverable1: 1/20/2007 --> Should be 1/22/2007 because 1/20/2007 is a Saturday And so on... I don't want any...

I have an Excel workbook and an Access database in question. I built the Access database in order to replace the Excel workbook, but now the user only wants to use Excel to populate the data. I know that there's a way to do this by linking tables to the spreadsheet, only I only found ways to...

Hi all, I have a report based on several queries that all prompt for a Date range - [Enter Start Date] and [Enter End Date]. What I need to do is get these dates to show up in my final report. Any ideas? Thanks!!!

Hi everyone, I am working with a query where I am joining two tables. One table has all 51 states and a person's name associated with that state. The second table has two fields - state and count (count is associated with clients within the state, if that is relevant at all). Not every state...

Hello all, hope someone can help! I have a database where suddenly I can't see the database window. The database still has 7000 kb, so it must be there, and I use it daily, and the database window was there yesterday, but suddenly its gone. Please help!

I have an excel file that was given to me with dozens of tabs. Each tab has the same column headings with different data. I need to get all this data onto one tab. Is there a less tedious method than copying and pasting? Thanks

Hi all, I need help formatting a date in a table. Right now they appear as YYYYMMDD so today's date would look like 20050906. I want it in short date format, i.e., 09/06/2005. Is there a way to do this in the input mask, or anywhere else so they appear how I'd like? Thanks for any help in...

I need to be able to query a field based on text within the string. For example, I have a field called "Weekday" which can be any of the seven days of the week (Monday, Tuesday, etc...) AND can also be a combination of two days (Saturday/Sunday), therefore I did not want to use a combo box. If...

Hello all, hopefully this is an easy one. I've done a mail merge for Microsoft Access before where I needed to do an ordinary snail mailing with a form letter. What I'm interested in doing, seeing as this is the age of technology, is to create an EMAIL merge with Access. Is there a way to...

Hello all, hopefully this is an easy one. I've done a mail merge for Microsoft Access before where I needed to do an ordinary snail mailing with a form letter. What I'm interested in doing, seeing as this is the age of technology, is to create an EMAIL merge with Access. Is there a way to...

This may be a really simple question, but I've been working on BO for a year and haven't figured it out. How does one make a copy of a data provider? Like, if you only want to change one value of the criteria?

I have two fields that are both time fields. They are formatted as HH:MM:SS AM/PM. I need to be able to calculate the time between both fields, so for example: Time1: 8:30:30 AM Time2: 11:45:40 AM Expected result: 3:15:10 Then after I get all my time differences for all rows, I need to get an...

I have two fields, both time fields, formatted as HH:MM:SS. I need to calculate the difference between the two times, or time between. For example: Field 1: 08:30:30 Field 2: 11:45:40 Expected result: 03:15:10 And then I'd like to get an average of all of these time differences. I'm using...

I have a time field that is currently formatted as a five or six digit number depending on what time of the day it is. Example: 8:30 AM = 83000 11:45 AM = 114500 I want to format these numbers into the standard HH:MM:SS format, but don't know the code to do that. Also, is there any...

I have pulled data into a report where I have two fields that are different times, and I need to calculate the time between them. I have encountered two problems: 1) I cannot format the time field from HHMMSS into HH:MM:SS. Right now all the values look like 5 or 6 digit numbers. If I simply...

I think this is simple, just never done it before. I need to write a query that will calculate the number of days between two dates. Basically it'll be the number of days a contract was in effect. I have three fields - Contract#, DateIssued, DateExpired. I want to get the Contract# and the...

This is part 2 to a <a href = "http://www.tek-tips.com/viewthread.cfm?qid=1046216&page=1">post I had earlier</a>. So now I have the records I want from my first query, and then I made another query to capture the duplicate Numbers from the first query. Now that I have that duplicates query, I...

This is probably an easy one, I've just never done it before... In my table, I have two fields for which I want to find distinct values for a combination of the two fields. I also want to include other fields in my results as part of the SELECT statement. Any ideas? Thanks for any help in...

I have a table that has data in this format: ID Number Sequence Desc. 1 1000 1 Cat 2 1000 2 Cat 3 1000 3 Dog 4 1245 1 Mouse 5 1245 2 Mouse 6 1245 3 Mouse 7...