Search results

I have a simple crosstab query. the column heading is an aging based upon the invoice date vrs a date to be entered by the user. so for example the invoice date is 12/10/2009. The user enters 12/31/2009 so the query would "age" this as 9 - 30 days old. However if the user entered say...

I do a lot of simple query items in MS Access. But I am taking my first SQL course in jan. Up until now all my SQL has been self taught by looking at examples, and reviewing code of other users. I have a need that I can not figure out. I have a table, basically two columns CR 123456yz...

thanks for the answer thanks for the answer, I understand.

i have a small table, about 14,000 records. currently all the dates in the table are YYYY-MM-DD 00:00:00. so 2007-2-28 00:00:00 I built a query and set the format to MM/DD/YYYY when I run the query the date showed correctly 02/28/2007 (no time stamp). However when I did the export it...

yes I am using a crosstabl query yes I am already using a crosstab query. This issue is, the columns has about 245 days, i.e. one column for each work day in the year. I need to take a whole week of data and summarize for each week, so that I only have 52 columns, i.e. one column for each of...

I track my daily work in an access data base. very simple. each day I enter the date, activity, the person I was helping, and a value ie. 1.5 hours etc. I might work on the same project many times that week, i.e. 1.5 hours on Monday, .5 hours on Tuesday, and 1.0 on thursday. my new boss...

I have one table with my account listing i.e. 1200000 1470000 2100000 3505000 etc etc in another table I have the default profit center range (line of business) that each account will use if an end user does not code the journal entry correctly. i.e. acctfrom acctto pc 0000000...

thanks for comments what happens when you have budget amounts but no actuals. or actuals but not budget. Actually my data set as all ways. Actuals with no budget. Budget with no current view. LOB in budget and current view, but no actuals. Actuals and budget for a LOB but no current view...

thanks for the reply I should have made it clear, I am basing my report off a query not off the table. I use a period field instead of a date field as that is how I get the data. Besides in my case, all dates would just be the end of the month i.e 1/31/2003, 2/28/2003 etc. so actual dates vrs...

Anyone out there have a suggestion I really need to be able to udate this form. No one with experience in this area? If you need more info, to provide an answer, just let me know.

I have been working in access for about 5 years. However, most is very straight forward and with the help of this board and searches I have answered most questions. So my issue, I need to build a small report system for our budget and planning group. At first I thought it would be straight...

field name You have probably thought of this but just in case, for field names I only use a-z letters. Can you change the field name to perccomplete. I do not know how to use a special character in code, but just thought I would mention this, just in case your application is just being...

I have a simple application. We are converting to a new chart of account. Our parent company has made some recomendations on the proposed new account number. It is called Project One Chart of Account (POCA) The application has 4 tables tbl 1current chart of account acct acctdesc POCAcomments...

I have created a form. I have account number as a combo box linked to a query "qryinputaccts" which chooses a subset (6200000 - 6999999) of the total accounts (6100000 - 6999999) from "Tblaccounts" i.e all non salary accounts. I have the combo box control value for "Limit to List" set to...