Search results

I'm trying to understand how "Non-Join" queries (if that is the proper name for it) work. I know you were taught that queries must be joined on some field to get the results but a query like this confuses me. Also, I can match the date using "Between" criteria but supposing that I had no...

Yes, you are right @GPGeorge. I was trying to get everything in one form but you gave me an idea. I'll just use a list box to display all the outstanding invoices and bind Payments to the subform for data entry. Thanks.

Thanks. Yes, I understood what @plog and @theDBguy were saying but I wanted a way to list out the outstanding invoices after selecting the payee in the main form. Also, try to apply a payment to each record (the outstanding invoices) in the subform. Which can't be done with the current design...

In the subform, how can I make the fields AMTPD, CHQNUM and PAYDATE updateable?

Hope this thread didn't go dead?

In the op I've attached the db on how far I reached.

SUBTOTAL - The total before Taxes/VAT, I need to use this amount in another report. PAYDATE \ CHQDATE - Yes they are the same. PAYEE - Yes, they are the same also.

Ok noted, but what would be the best approach? Here is what I'm trying to achieve Purchases are made so I created a Purchases Table. Cheques are written out, so I have a Cheques Table Now here's the problem, Cheques are written but may be applied to several Invoices. Additionally, Cheques...

I made a query and bound it to a subform but the field [AMTPD] on frmPAYABLES is not updateable. Can someone explain what I am doing wrong, please?

I can't believe that I missed that Nz 😖. Thanks @MarkK

I'm trying to use excel to connect to a ms access query. The query in the attached db is named qryDaily. What may cause excel not to see the query, I know that if your query has the Nz function Excel don't see it. Can someone suggest a workaround (other than to make a table from the query)?

Yes, Agreed. But ever since I started assigning the PRICEID to each sales record, my db is speeding. I pulled a 6 month report in seconds.

The Accounting Control for that would be an "Edit Invoice" form and it would follow the rules of the initial Data Entry.

@Minty you are right on both accounts. A helper field really comes in handy and I try to integrate them in my tables whenever I can. Also an SQL server does makes things 100 times better when it comes to querying. @plog You will still need the ITEMID because if you are doing Data Entry you...

Hello all, If you happened to come across my posts, most of my questions are related to getting the latest price or rate during data entry. I've gotten lots of help on the forums dealing with it but I think I may have a better solution. A typical pricing/rate table looks like this...

After weeks of debugging this I finally got @CJ_London method to work. Things to take note of: ComboA - The combo that provides the parameter ComboB - The combo that will display the filtered and non filtered Rowsource 1. ComboB's Rowsource must be set in the Property Sheet. This query/table...

I was reading this link https://stackoverflow.com/questions/33526344/crosstab-query-from-a-query-with-a-subquery Essentially on posts with similar problems, they were suggesting to remove the subquery altogether. Like these...

@Pat Hartman suggestions and advice are always solid. Congrats 🍾

I read on some of the forums that once your source query have a subquery in it you will not be able to make a crosstab query. How can I get around that? In the attached db I want to create a crosstab query from the query qryWKLYHRS that would look like this...

Thanks @arnelgp. That looks very good. I'm seeing everyone taking my vba sql and making a query gui with it in order for the continuous form to work. Is that the proper way to do it? Or can the same thing be done through vba? Because one of the problems I was having was trying to pass the...