Recent content by liltechy

I have created the report in Access, but I don't know how to (or if it can be done) have the report open to the current record that is open in the Powerbuilder database. liltechy

The linked table that I have in Access comes from a PowerBuilder database. When the application(PowerBuilder - AIM) is open and the CSR goes to a specific record, I want them to be able to go into Access and print a report with that current record. liltechy

I am creating a database to generate reports based on the current record in another database (table linked via odbc). I have linked the table where the current record would be pulling from, but how do I get the current record to show up in my report? Please help. liltechy

JonFer, I forgot to put 0 in my Sequence table. Please disregard the previous question. liltechy

JonFer, I have one more question, when it gives me the newdate it starts with 30 days from the AuthStDate and then it give the individual dates. How can I get it to give me all the individual dates starting from the date after the AuthStDate? liltechy

Jonfer, I figured it out and it works wonderfully. Thanks a bunch. liltechy

Jonfer Where do I put the SQL? liltechy

I'm not quite sure I understand. How will a crosstab give me the dates between to two dates? liltechy

Here is the problem: AuthStDate is a date field. AuthEDate is a date field. I need to create in a query another field that will list out the individual dates between the two dates. For example: AuthStDate = 6/25/2003 and AuthEndDate = 9/30/2004, I need to see 6/26/03, 6/27/03 and so on. So...

There is one report that is printed that will need to show all data, so it all needs to be in one sheet.

Thank you that did the trick. liltechy

Is it possible to do a autofilter with conditional formatting? I have a small spreadsheet that I need to print every month but I do not want to print the months with 0.00. Below is the data that I have tried to autofilter without success. MONTH Current Boardings YTD Boardings...

I am trying to automate a spreadsheet and need some assistance with a formula. Here is what the answer should look like for July: ALL ITEMS DUE BY 8:00AM ON THE 6TH WORKING DAY - AUGUST 9 This is my formula: ="ALL ITEMS DUE BY 8:00AM ON THE 6th DAY - "&UPPER(TEXT(WORKDAY(NOW(),-7),"mmmm d"))...

Thanks so much that works great. liltechy

I have a financial workbook and need some assistance with a formula. sheet1 is where I enter my monthly totals. Sheet2 is the financial report. What I can't figure out is what formula do I use to have the current month's entry show up on Sheet2. Here is what sheet1 looks like: Acct# Descr...