You may have a table design problem. You should be able to identify any transaction especially if you want to print/manipulate a specific transaction.
What is the table structure of your Transaction Table?
orangeCat
Last Activity: Jul 27 '21, 09:33 PM
Joined: Dec 21 '07
Location:
-
Research UPDATE QUERYLeave a comment:
-
Personally, I think you are trying to put too much intelligence into the TaskId. Use a date field for a Date.
One field one fact. Keep it simple.Leave a comment:
-
Base your report on a query and not the table.
Something like
Select the fields you want FROM YourTable
Where "Plant fields??" is not NULL
You will have to adjust with your field and table names.Leave a comment:
-
How do you determine Customer Balance?
eg.
For a given Customer
Balance = Sum(All Invoiced Amounts) - Sum(All Payment Amounts) before ParticularDateLeave a comment:
-
You didn't put these values in, right?
You used QryEstMileAge for queryName and the proper field in the query?Leave a comment:
-
Wouldn't that be
With RecSetx
.... .fields(0) ' would be the field you wantLeave a comment:
-
Are you really sure you want to do this sort of thing?
Why not have separate fields?
Suppose your Table is about Employees
with fields
EmployeeId (auto number Primary Key)
EmployeeName (text)
EmployeeBirthDa te (Date/Time)
other Employee fields
You can retrieve Name Age etc by means of a Query
Do a search on Normalization to get more info.Leave a comment:
-
Distinct does NOT remove anything. It really brings back only 1 records for the field involved.
If you want to count the duplicates/replicates you could
If the field is intended to be the primary key, you appear to have some structure issues.Code:SELect count(possible dup field) from Table
Leave a comment:
-
I agree you need a query with Form or Report that identifies Overdue and upcoming Service/Inspections.
However, if you say you can't implement the solution, then perhaps your table structures are at fault.
What tables do you have? What fields in which table?
What exactly is the issue with the proposed solution?Leave a comment:
-
Well, that is why I said if the string to be replaced is
always " - ".
The only other advice/approach I can think of is Regular expressions.
You may want to Google that for some explanation and samples.
This could be set up in Access using vba and setting a reference to the appropriate library.
Good luckLeave a comment:
-
If the string to be removed is always " - "
space + dash + space
then use something like
Replace (Description," - "," ")
You would have to repeat this replace until no more
" - " strings exist.
This will not affect "1-800..." or "on-line" etc
**I'd be cautious depending on a memo field to be proper paragraph structure.
...Leave a comment:
-
Show us the query that you tried.
Your reference to fields such as payment1, payment2... and date1, date2... suggest non normalized data (table structure issues)Leave a comment:
-
It sounds like your tables need to be restructured.
Do a search for Normalization.
What exactly is Table2_lot1, Table2_lot2?Leave a comment:
-
orangeCat replied to customer is placing a order, already a customer, if not add then proceed with orderin AccessHow do you intend to identify a customer?
Do you record a phone number?
Do you record an address?
Do you record the Zip?
You could check for phone number and zip
Check for DCount( parms ) > 0
If present, customer exists
If not present, customer doesn't existLeave a comment:
-
orangeCat replied to How to query for an interval between 18 and 6 (hours, as integer in the table)?in AccessIstoric_Turnari .ora>=18 And Istoric_Turnari .ora<=6;
I don't think this is possible,
What can be greater or equal 18 AND Less than or equal 6
Do you mean
Istoric_Turnari .ora>=6 And Istoric_Turnari .ora<=18
Note you could use the Between operator. In Access it includes endpoints.Leave a comment:
-
orangeCat replied to How to refresh to original when form is loaded after the user right click sort?in AccessIs there an option to Remove Filter or Sort?
If so, click it.Leave a comment:
-
Export that data to a separate file... .csv or .datLeave a comment:
-
How do you relate Product to Supplier?
The Products to be reordered are
Select Product from ProductsTable where
QuantityOnHand <=ReorderLeve l
You have to sort out How to relate Supplier and Product.
You should do some searching on Proper Naming Conventions as well. No spaces in field names.
Good luck.Leave a comment:
-
Did you do a little testing? What have you tried so far?
What do you plan on doing with the coordinates? If you plan on doing arithmetic, I think text won't work.Leave a comment:
No activity results to display
Leave a comment: