Search results

Hello, I am creating many reports that are essentially the same, with a few tweaks. So is there a way to change the control source in a report, meaning change it from table-x to table-z, but keep the report in tact, because many of the field names are identical? Thanks

Is anyone having an issue with a query not saving the sort order? The only way I know to sort is to list the field in the query, check it off as "show field", then choose it a 2nd time and sort "ascending" and uncheck it for "show field." So the field is listed twice but only shows in the...

Hello, I have the following DSum that works fine until I add a Paid Date criteria. The field Paid Date is formatted "Date/Time" in the table. AE CTAS By DateT: IIf([GeneralManager]="No RVP" Or [GeneralManager]="",0,DSum("[Service Commission].[NetSale]","Service Commission","[ID] <= " &...

Hello All, I have a query attached that I wish someone could help me with. Unfortunately, I don't use VBA coding. The first thing that needs to happen is whenever a NO."1" appears after a "0", then the NO. must change to "1" . This occurs for as long as ALL of the 3 fields (AE, Type, LFType)...

I have a query that I need to do a subtotal in, but so far can only figure out how to do a running sum. I can't do this in a report because of other things running. The running sum would be fine if I could figure out how to only show the last total amount of the group, and NOT each record's...

I have 2 queries that create 2 separate tables, A and B. The 2nd query is dependent on the answers from table A, made from the 1st query. I put a calculation in X-field in the 1st query, but the resulting answer in table B formats this X-field as text, no matter what I try. I'm not great...

Does anyone have a suggestion as to the best way to deal with deleting and replacing a table in a query? The table I'm deleting is already in a relationship so it won't delete. Thanks.

Hello, I very desperately need help with a query that I'm creating for a client as part of a bigger process. I have a running sum in a newly created field of a select query (soon to be make table query). The DSum is working fine except I need it to start over at a change in employee number...