Dear All,
I'm trying to import daily data from other department to my access file. The thing is their data aren't in columnar order and I need almost all the data they've provided which is scattered in different specific row and column.(Please check the attachment for the sample file)
Is there any way for me to import their original format data to my access table without changing their format?
Since...
eko99312
Last Activity: Jul 28 '12, 03:58 AM
Joined: Oct 19 '09
Location:
-
Import specific row/column from Excel to Access
-
Taking record from other table an copy it in a datasheet form.
Almost the same like my previous question.
To make a Purchase Order (PO) normally user should give us Requisition. The requisition already input to a table (Requisition table) through a form.
The PO form contain
1. PO number
2. PO date
3. User
4. Item
5. Quantity
6. Price
7. Completion date
8. PIC
To avoid entering the same data in Purchase form (for number... -
Copy or duplicate a record for repeated job or action in a form
I have this Purchase form contain
1. PO number
2. PO date
3. User
4. Item
5. Quantity
6. Price
7. Completion date
8. PIC
Sometimes every months, I often input to a Purchase Form the same Purchase Order with the same supplier, products, and price. The question would be, can I easily copy the record I chose and paste it in a new record?
Help would be grateful.
Regards. -
Open specific record in a form from a datasheet form
Let's say I have this form called Attendance List. The list was in datasheet form. In the list there were names and date checklist. The question is, I want to edit one of the names by double clicking on the datasheet and it will pop up Employee Form. To pop up Employee Form by double clicking on the names are easy, but the trick is I want the Employee Form shows the specific name that I wanted (or the specific name record), normally it will open... -
Report : Problem using Count(IIf ...
I made a report concept from a simple query that contain as follow
When I click the view button, the query shows the date and the reasons record. Well, I assume the query works well....Code:SELECT [Table1].[Date], [Table1].Reason FROM [Table1] GROUP BY [Table1].[Date], [Table1].Reason HAVING ((([Table1].[Date])>=[FirstDate] And ([Table1].[Date])<=[LastDate]) AND (([Table1].Reason) Is Not Null));
-
How to input data in an access form like ms excel?
Dear All,
As you know that input data on excel is easy than access, you can simple click the date that you prefer and input the value that you want. For example :
Consider that the month that I use is November 2009 :
If i use excel it will look like this,
...Code:Country Day in a month 1 2 3 4 5 Australia 4 3 China 5 2 England -
Create Inventory Report base on Query
Dear Experts,
Pardon me if this question already been asked before.
I have this two table as follow :
Sales
SalesID SoldDate Product Customer Qty
S-1 1-Nov-09 Candy Jason 5
S-2 3-Nov-09 Bubble gum Rudi 9
S-3 15-Nov-09 Candy Junior ... -
Dear AJ,
Thank you so much for the answer.
Since I don't understand SQL, I tried to apply your method by using query design view, and it works very well. Wow using 2 queries, why didn't I think of that.
And for NeoPa, I appreciate your answer and I'll learn more about your method.
Regards,
Eko -
Select first row in multi group query
Pardon me if this question already been asked before.
I tried to sort a query to meet my desire. Here is the example:
My goal...Code:[I]Date Customer Supplier Price[/I] 31-Oct-09 Charlie Australia $ 100 20-Oct-09 Omega Singapore $ 50 4-Oct-09 Charlie Australia $ 20 5-Oct-09 Omega Singapore $ 60 15-Oct-09 Charlie China $ 200 20-Oct-09 Charlie China $ 300
No activity results to display
Leave a comment: