Search results

Found this while browsing around

Well, it's still being difficult. I've made the append query but I'm still having issues with the fact that access does not want to join the queries, thus not returning any results at all

Sounds like problem solved. I hope. Thanks

exactly that. I am trying to have a row of data showing for each record much like: Name | count of dates a-b | count of dates b-c| ----- that is my ultimate goal. Would I be better off if I create an append query that writes to a temporary table, in the layout that I want, and just...

I've been playing with the subreport, but it's not really accomplishing what I am intending.

The purpose is to create a report, but the whole reason I'm building this database is to create a report that mimics the old spreadsheet that was being used before. I'm open to suggestions.

Access 2007 I've created a set of queries (nearly identical) to sum records dating back 9 weeks (1 qry/wk) which will eventually work it's way into a report. each query is as follows, except for the date range changes SELECT tblShippingList.Name, Count(tblReceived.ID) AS...

I'm trying to build a query that will: a.) search within a certain date range b.) count the amount of records underneath each parent record c.) display each of the summarized parent records displaying only a sum of its children. part a: is the part I dont have a problem with. part b + c: I...

Access 2007 When I view my forms, they all take up the whole screen. How can I change this so that it is more like a window than a page?

Thank you, I was stuck thinking in If-Then terms. problem solved

I currently have a combobox set up in a form which the query references to sort through data. I am looking to create a checkbox that will let the query show all results. How can I set up the criteria in the query to accomodate this or will I need to create a second query and activate it when the...

I am attempting to enable/disable a button based on the results of a query based subform. I am unsuccessful in the various attempts I have made. Everytime I run this I get an error regarding the object that it is pointing to in this case sfrRMUDayEdit Private Sub cmdShowData_Click()...

the query is currently being used in a subform, do I target the subform or the query?

Is there a way to record the number of results that a query produces? I'm trying to restrict actions of command buttons.

Thanks for the advice, I couldnt get it working for the make-table, but once I moved it to the append query, it worked like a charm. Thx

Worked like a charm in the criteria box, can this also be applied in the Field box? I have a make-table query, and I'm trying to make a bulk entry, all with the same date. But currently I am using the same concept, but it is not grabbing the date that it is pointing to in the Field. Field...

Access 2007 I've created a query that has a date parameter, but how can I arrange it that I can collect the parameters for the query before I open the query inorder to avoid the parameters messagebox?

I guess the question really boils down to, how do I set my database up so that I can bulk create a set number of predetermined fields?

thank you for the help, it solved the problem. I appologize again for my inadequate knowledge of the subject, but I am slowly trying to rectify this.

Well I guess I'll a better way of describing it... I have one table with a list of contacts. Everyday I need to create an entry for each of those contacts verifying if data has been received. This data is to be spread between 2 different tables (1st table, "received", has entries for date...