Search results
-
A
Adding query fields to a subform when the subform contains fields from a table
@PNGBill: I went to look at my queries, revised them and made improvements. The form finally works now. Thanks for the reply. -
A
Adding query fields to a subform when the subform contains fields from a table
Hi guys, since I'm not an expert with Access, I'm having lots of trouble with it. I want to create a form that contains a main form and a subform, and when the forms are filled out, they update information to two tables. So far, I've created a main form that can update info to the... -
A
Iff and DateDiff
IIf(day()>ReturnDate, DateDiff("d", day(), ReturnDate), 0) . . . I intend it to be: "If today's date is > ReturnDate, Find the difference between Today's date and the ReturnDate, Otherwise, return '0' as the number of days." Could somebody tell me why this formula isn't working out for me? It...- adagio12
- Thread
- Replies: 3
- Forum: Modules & VBA
-
A
Query with counts, '0' values, and a calculation
Thanks for the welcome! Anyways, I finally got it figured out. I had to add the "Nz" function and add 'join properties'. I guess it must be a common problem that people might have with Access; it should go on a list of FAQs. Now I'm struggling with a joint 'Iff' and 'DateDiff' function... -
A
Query with counts, '0' values, and a calculation
Hi guys, I tried looking up other threads in this forum for some problem similar to mine, but no luck. I'm trying to build a query that could calculate the # of available products in stock. It seems simple when you think of it, but I couldn't get the results that I needed and couldn't...