Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Crosstab Query
I have tried several ways to build this crosstab query, but can't get results. Result Desired: A crosstab query with row heading-partID and column heading orderDate, the value is quantity. A query for each customer. This isn't a problem so far, here's the twist: I want to sum the past due...- palnud
- Thread
- Replies: 6
- Forum: Microsoft: Access Queries and JET SQL
-
Insert a Number, and renumber sequentially
I have a form that has a field called Show Order. This is the order in which the entries in a sports event are going to perform. An entrant may request that they perform in position 5, and there may be 20 entries already listed for the event. What would be the best way to insert this entry as...- palnud
- Thread
- Replies: 1
- Forum: Microsoft: Access Forms
-
Linked Field Format
I'm importing a text field, and the negative numbers are in parenthesis. They come into the table field as an error, #Num!. How do handle this? Thanks.- palnud
- Thread
- Replies: 2
- Forum: Microsoft: Access Tables and Relationships
