I have a database shell I've created with contacts, inventory, etc. information. I'd like to add an interactive calendar form if possible. I haven't found this information on the net to date, but have seen some access databases online with the capability.
Does anyone have advice as to how to...
I have a spreadsheet that list several different pieces of data. The spreadsheet looks as follows:
Cust Serial Date Amount Type
123 0656020652501 20060721 $115.82 P
123 0656020653011 20060724 ($40.12)X
123 0656020653011 20060721 $40.12 P
123 0656020658301 20060721 $10.18...
I am attempting to import a large text file, created using JCL, into Access for manipulation.
When I open a new database, and attempt to import a new table I receive an error message stating, "The Microsoft Jet database engine could not find the object '(path.txt)'. Make sure the object exists...
I have several tables, that when imported from our AS400 system, convert the date as Julian values. I would like to add a formula to a query that converts the Julian format into a legible date format.
Any suggestions?
Here's an example -
TM_DATE_EXPIRED_JULIAN_1 = 110365
The true date is 12/31/10
I am trying to create a query that will find numbers starting with a certain location zone, and ending with a certain location zone.
Data-
925-266-161
912-274-010
925-176-010
I need the query to gather data that starts 903-913 and ends in 010, like 903-xxx-010 to 913-xxx-010. Then the query...
I need to create a calculation that will return a positive number. I have a form that compares two fields: actual inventory counts and original inventory counts. I would like to take the difference of the two fields and divide that number by the actual inventory count to receieve a percentage of...
Hi all-
I have a subform in my database that pulls information from an inventory system. This subform should not be changed by the user of the general form, but is viewed by them for reference. Is is possible, for data entry, to set up the tab order such that it does not tab into the subform, it...
I wansn't sure what to name this thread as I am not sure how to solve the problem. Here is what my spreadsheet looks like:
Column: C E
1-2-00 $16.50
2-4-01 $11.25
6-10-02 $10.00
etc.
I have several rows of data and I need the formula add the dollar amount...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.