Search results

ahh i see what you're saying. in my case however, i may have to respectfully decline that suggestion. and i think when (if) im allowed to post my db file you'll see why. there are only 10 or less people in the "requesters" table, and that will likely not change much. also, i'm the only one...

thanks for this i'm looking at it right now. will read through the entire thing. The only reason i have those tables with one field of data is because i didnt know how else to create a dropdown list when i first started designing this DB. i figured out how to like a combo box to a table, so i...

here's a pic of the relationships... its probably very unorthodox at best... thanks so much for your guys' help and advice and patience so far! it is very much appreciated!! I'm here to listen to the experts and learn! :D

well... i can't upload the database because it's dealing with alot of sensitive data - i'm going to have to ask before i can upload it. I understand this is really the only way for you guys to know what im dealing with here... i do not have any problems at the moment, just concerned with how...

So my primary table consists of 6,670 records. i also have 7 other tables of a much smaller caliber. I have 18 Forms that utilize my tables and queries to make certain tasks a tad more convenient. I have 10 reports (so far) with more on the "to do" list. I have about 84 different queries i...

Oh. well yes, im still new to access in general, so in order to create the report i pulled a field from the field list and put it in the detail section. then i copy/paste/edit to get the rest in place. beautiful. I just copy/pasted it all to the page header section and it worked perfectly...

So i have a union query pulling together about 3,000 records from other queries. I arranged all the counts and data I need to fit onto one page, but the report is copying that page (minus the header) for each record in the union query. I'd much prefer a one page report rather than a 3,000 page...

after hours of researching, i figured out a work around... which i wont take the time to explain now, but i've run into another road block :banghead: this one isnt so bad though i dont think. here's my SQL: SELECT Count(*) AS [AL Count] FROM [RR-ALCount] UNION ALL SELECT Count(*) AS [AO...

anyone have a solution? or an idea/suggestion? i've tried using Nz, but that didnt work :( this has to be a simple question compared to some other threads on this forum... also, happy friday!

sorry if i was unclear. im using the phrase "No Record" as a status for a document, meaning our company has no physical record of that document. it does not refer to database records. again... terrible naming... if i knew then what i know now... this query and all my other "count queries"...

ok i think i stripped it correctly.... there's only one table "documents" and one query "RR-NoRecordCount" open up RR-NoRecordCount and it will only display column headers. open up documents and change the "status" field of anyone one record to "No Record" and re-run the query. it works...

wait, count doesnt work the same way as sum does it? I have many queries just like this one, except the filter is based on a different field. but the "count" field is the same across the board. i think the reason this is the only query that gives me an issue is because its also the only query...

as clearly obvious, i r noob. the data type is text. the document names are numbers suchs as 4625-4228-7797. my (probably not the best) logic was that i would filter the records based on the 'status' field of "No Record" and then it would just count how many records there are with "No...

well the 'type' field shows if the document is one of 4 possible types i work with in this database. lets just say A, B, C, and D for now if thats ok. i dont think it's related to this query though, as the only fields from the 'documents' table i'm using are the 'status' and 'document' fields...

yes i did as a matter of fact. that seemed to be the most popular result when googling this issue, but it doesnt change anything for me. i just get my column headers with no records just like always. Also, i'm using Access 2003.... if that makes a difference. thanks for the reply!

Hey all, so i'm still new here and still new to Access so bear with me here... i learned by experimenting and google. i've pretty much used design view to build all my queries but i'm just beginning to learn SQL now. I have a count column in this query, and i would like for it to return a zero...

I can't upload it due to contractual restrictions :(

Hello, I'm a self taught Access user. Needless to say i know nothing about macros or VBA or SQL or pretty much any other acronym. I've been learning how to do everything by asking google and this forum seems to come up alot, so when i asked a question google couldnt asnwer i figured i'd join...