I have an Excel file that needs to be updated nightly and sent to a user. I can't find anyway using the existing marcos that would allow me to set a automated command to run the query on a scheduled time (12:00 am) and update the Excel file and send to the user.
Anybody have any ideas?
Thanks
egrill
Last Activity: Dec 12 '07, 03:47 PM
Joined: Jul 9 '07
Location:
-
Scheduled - Access Export to update an Existing Excel File
-
Duplicate records - SQL Below
Everytime, I run this query I get 3 or 4 duplicate records. I can't figure out what is going on. Any help would be appreciated. Thanks
[CODE=sql]
SELECT dbo.INVOICES.OR DER_NO AS "ORDER_NO", dbo.INVOICES.SA LES_REP AS "SALES_REP" , dbo.INVOICES.TE RMS AS "TERMS", convert (varchar,cast (dbo.INVOICES.I NV_AMOUNT as money),1) AS "INV_AMOUNT ", dbo.INVOICES.ST ATUS AS "STATUS", dbo.TRCK_GRP.NA ME... -
Quarterly Queries - Automating the Date
I can access the date field from OBCC tables and do the normal date range for a quarterly report for each quarter
I need the formula so I can sort the records into individual quarter having them side by side with the appropriate sum of the date.
For example the result would look like this
Name QTR 1 QTR 2 QRT 3
ABC Comp $10000 $12000 $ 120000
DEF Company... -
MS ACCESS " Calculated Field" - Keeping the results
I need assistance on how I can keep the results of a calculated field as part of a record. Each time I use the form I loose the previous calculation. I can set-up the form calculation but want to maintain the result information especially when I make changes to the record. I loose the information for the previous record when I add new record is added. (The point is maintain the calculation as part of the record.) The example I have establishing... -
Thank you it worked just great. Thank you for the assistance -
Emmi
Thank you. Thank you. I wish I could buy you lunch sometime. It worked as your said. This saves me a lot time.
Have a nice dayLeave a comment:
-
How would that work? I run the real time query in Access; it gives me a new table result. The query is based on a vendor request that I need make so I get the correct information How do I link the results into an Excel so I can send it as an attachment in an email to the warehouse manager (remotely)?
I would love to stream the data from ACCESS right into Excel and skip the export function each time.
I think we are...Leave a comment:
-
Yes. The tables in the query are linked to a real time database. It has not parameters other than to pull the data from the tables based on the query parameters that are predetermined.Leave a comment:
-
MS ACCESS Query Results linked to an Excel Spreadsheet
I am looking for away to link the results of my query to an Excel spreadsheet that will automatically update and then emailed. Right now I export and send. I need a more efficient way. It is on-going report done 3 times a week. Can I build a marco? -
Thank you. It worked perfectly.Leave a comment:
-
Translating Dates into a week of and a grouping header
I need to be able to group date field by week. I can identify the week but I need to translate the ww into a date. For example; if the date falls in the 5th week of the year, I want to group all the dates that fall in week (jan 28 though the Jan 31) all together. Does anyone have work around solution or know what functions I could use in a query or report. I have done with using the Monthname function but can't find a similar function for week... -
Thank you. It worked perfectly....Leave a comment:
-
Thank you. I think that would just cause the date to change. I need to sort so I can have the records within the same serial (week) together. Thank you again for the assistance....Leave a comment:
-
Translating the serial number of calendar week into "week of _______
I have figured out how to extract the serial number of date field into the corresponding number of the week using the DatePart function. The would like to take the 5 and translated it identify the week of associate with the series. For example if the serial number was 5 it corresponds the the fith week in January which is the week of January 28th. Does have a work around or knowledge of the next steps to get this information. Thank you
... -
egrill started a topic I am having trouble getting a the correct value type when linking OBDC - ACCESSin AccessI am having trouble getting a the correct value type when linking OBDC - ACCESS
I am linking the tables in Access through my SQL server. It is accounting programming that uses status determine the type of document; 8 for sales order and 11 for credit orders. 11 are negative currency however, they are being puled as positives which throughs off the totals, etc.. Any one have a logic or way to make sure 11 status are credits. -
Negative Values Using Access - ODBC Link
I am linking the tables in Access through my SQL server. It is accounting programming that uses status determine the type of document; 8 for sales order and 11 for credit orders. 11 are negative currency however, they are being puled as positives which throughs off the totals, etc.. Any one have a logic or way to make sure 11 status are credits.
No activity results to display
Leave a comment: